Basic objective of this whitepaper is
>Identifying a key setups to complete Demand planning to supply flow
>Identifying the role of advanced modules like ASCP to achieve better execution of Supplier scheduling process
>Basic flow of ASCP

Setup

Step 1: Item creation
Note: Item should be ‘Purchased’ and ‘Purchasable’ enabled. Ensure ‘planner’ is entered under general planning tab (At organization level) Ensure it’s a ‘Buy’ item. 
In the MPS/MRP Planning tab – the item should have a planning method
– MRP Planning (Or method of planning used at the Location)
– Create Supply

Step2: Create Blanket Purchase Order and Approve it

Step3: Create Approved Supplier List , Make sure Global parameter is set to Yes

Step 4:  Make sure ‘Planning schedule’ and ‘Shipping Schedule’ is enabled under planning tab
Step 5: Create Sourcing Rule and Assign it

 Step 6: Create Demand of Item (Demand can come from various sources , I have taken just one example where demand is entered in Master demand schedule

Step 7: Run ASCP Data Collection (From Advanced Supply Chain Planner)

Step 8: Create Plan (Optional if Plan already exists)

Step 9: Launch Plan

Step 10:  Viewing ASCP Plan result

Step 11: Execute Push Plan (From Advanced Supply Chain planner Responsibility)

Step 12: Create/Build supplier schedule and confirm it.
Responsibility : Supplier Scheduling

Generate Schedules and Confirm schedules.. Once schedule line is confirmed it will display in iSupplier

View Data in iSupplier Portal

The basic concept of Mass Allocation is dividing a cost on some factors.

If we take a simple example then consider 3 departments X, Y and Z using a single landline telephone. Each department has 2, 3 and 6 employees respectively. The bill for month of June-09 of landlines comes out to be Rs.1700. If you have to calculate the telephone usage for department Y. How will you do that? Is it Rs.1700? No. Is it 1700/3 (total divided by total number of employees in dept-Y)? No, because there were 8 more person using the same landline connection. The answer is that you will allocate the total cost into each department based on the number of employee it has. So in this case the allocation will be 1700*3/11 and you’ll get Rs.463.

Here is the department wise total of the telephone bill:
Department X: Rs.309.09 (2 employees usage of 1700)
Department Y: Rs.463.63 (3 employees usage of 1700)
Department Z: Rs.927.27 (6 employees usage of 1700)
This is the formula for MassAllocation A*B/C where,
A = Total Cost
B = Factor (Number of Employee of particular department)
C = Total Factor (Total Employees)
So the Allocation formula for Department Y will be
A = 1700 (Total Landline Bill for a particular month)
B = 3 (Total Number of Employees in Department Y)
C = 11 (Total Number of Employee in all three departments)
In Oracle General Ledger this facility is given to divide or allocate your expenses or revenue income on your selected distributing criteria which can be your number of departments, branches, head count, covered area, etc. In my above example I used Head Count as the basis of allocation.

Steps for generating a Mass Allocation Journal:
  1. Pass a Standard Journal – This will identify your “A”
  2. Pass a STAT Journal – This will identify your “B” and “C”
  3. Define Mass Allocation Formula Batch and Journal.
  4. Validate the Formula.
  5. Generate the formula for specific accounting period.
Let’s see how we can carry out the process of Mass Allocation in General Ledger.
First let me take a scenario. Consider an organization with 4 divisions or departments:
1. Enterprise Resource Planning (ERP)
2. Software Development (SD)
3. Software Support (SS)
4. Network Infrastructure (NI)
The COA Structure of this organization is Company-Branch-Department-Product-Account
The segment values of Department or the hierarchy of Department segment is
0000 – Common or No Department
1200- Information Technology (Parent) (Child Ranges: 1201 – 1299)
1201-ERP
1202-Software Development
1203-Software Support
1204-Network Infrastructure
Let’s allocate the telephone bill expense of Rs. 18950 for the month of June incurred at Karachi branch on the number of employee each department has. The allocation basis in this example is Head Count per Department.
The account code for Karachi branch is 101 and the natural Account for PTCL expense is 50201 and each department has 9, 11, 5, and 3 employees respectively. That is ERP has a head count of 9, SD has 11, SS has 5 and NI has a head count of 3.

Now the Mass Allocation procedure steps starts.

STEP1: We will create a total cost or “A” of the formula. Pass a Standard JV in the period of JUNE with the following Lines
Line1: 1-101-0000-00-50201 18950(DR)
Line2: 1-101-0000-00-10122 18950(CR)
Line 1 Account Description: XYZ-Karachi-NoDeparment-NoProduct-PTCL Expense
Line 2 Account Description: XYZ-Karachi-NoDepartment-NoProduct-Bank
This journal entry is equivalent to paying your PTCL telephone bill. Ideally this expense entry should be coming from Oracle Payables. We are manually entering this actual journal so that we can created a Cost Pool “A” having an amount of Rs.18950.

STEP2: Now we will create the “B” and “C” or Usage Factor and “Total Usage”. Pass a STAT JV. STAT is short for Statisticaland it can be used by changing the currency from PKR to STAT. The STAT journal doesn’t need to be balanced. But they do affect the account balances if we inquire on the currency type of TOTAL but let’s not get there, it is a different topic. Simply pass a STAT JV to create “B” and “C”. Remember the Period of the JV should be JUNE as the Standard JV.
The account code combination for the STAT journals in this scenario will be
Line1: 1-101-1201-00-50201 9(DR)
Account Description: XYZ-Karachi-ERP-NoProduct-PTCL Expense
Line2: 1-101-1202-00-50201 11(DR)
Line3: 1-101-1203-00-50201 5(DR)
Line4: 1-101-1204-00-50201 3(DR)

By passing or posting this STAT journal we are creating a basis for expense allocation. The line 1 tells that the XYZorganization has 9 employees at Karachi branch in ERP department incurring PTCL Expense. We can enable UOM on STAT journal by enabling the profile option JOURNAL:MIX STATISTICAL AND MONETARY to YES. Similarly so on and so forth. Now where are “B” and “C” in this journal? You can see 4 lines with changing Department codes, these four lines individually represent Usage Factor “B” which is 9, 11, 5 & 3 and collectively they represent Total Usage “C” which is equal to 9+11+5+3=28.

Now moving on with STEP3

Create a MassAllocation Batch and then a Journal. Name it Karachi PTCL Expense Formula.
When you open the formula entry form you will find the three constant of the Mass Allocation formula A, B, C and two other fields T and O. “T” stands for Target Account and “O” stands for Offset Account. I will explain these Accounts later. Let’s continue with the formula.
Now give the account of the “A” which is 1-101-0000-00-50201 having the value of Rs.18950. On the account entry form you will find that the system prompts or asks for Ledger, it is an optional field. This option of ledger set is used when we are allocating cost from multiple ledgers. And there is another LOV having the value as
C: Constant – The segment is constant and doesn’t need any Loop or Sum. And the balance should be picked against “A” as a constant
L: Looping – The segment needs to loop from first value to last value provided in STAT JV.
S: Summing – The segment needs to sum the value in provided in STAT JV.
Generally the account code in “A” doesn’t not need any kind of looping or summing. So every segment should be given the value of C. The value this account has for the particular period should be picked as a constant. Keep the currency as Entered.
Now move on to enter the code for “B”. The account code for Usage Factor in our example will be
1-101-1200-00-50201. Note that I have given the department code as 1200 which is parent of the departments we selected for allocation basis. Give every segment a Constant C but the segment of Department will be having the value as Looping L. Why? Because we need to pick the individual values of 9, 11, 5 and 3.

REMEMBER: looping is only done on Parent Value of the Segment. In this example 1200 is the Parent department which has the child departments 1201, 1202, 1203 and 1204.
The system will automatically pick the allocation basis by matching the natural account and the looping segment.

REMEMBER: The currency for “B” and “C” should be STAT.
Now give the account code for the Total Usage “C”. The account code will remain the same as “B” with 1200 as the department code. The only difference this time is that instead of Looping we will give the Department segment the value of Summing S. so that we can have the sum of head count which is 28.
It’s time to give the “T” account. No, it’s not the T Account as we see in Ledger. It is the Target Account of the cost pool or these are the Debit Accounts which should hold the allocated expense. In our example these account are the accounts we gave in “B”. Yes the account code combination 1-101-1200-00-50201 with 1200 as Looping. IN FACT, usually the accounts given in “B” are repeated in “T” and account given in “A” is repeated in “O”
Let’s proceed further by entering the “O” or the Offset account. This account is same as the account we gave in “A”. This is the credit account. The account code combination given here will 1-101-0000-00-50201 with every segment as Constant.
With this step we have completed our allocation formula. The final Journal generated with this formula should be
Line 1
1-101-1201-00-50201
6091.071
Line2
1-101-1202-00-50201
7444.643
Line3
1-101-1203-00-50201
3383.929
Line4
1-101-1204-00-50201
2030.357
Line5
1-101-0000-00-50201
18950

If you enable the Full Cost Pool Allocation option then the system will post the rounding difference to the account with highest value. In this case the all the rounding will be given to line2 account. The first four accounts are the accounts we mentioned in Target field and the last account is the one we mentioned in Offset field. The accounting done here is that the PTCL Expense posted on a Common department was credited and distributed to four other departments on the basis we defined in STAT journal in Step 2.

If the concurrent request ends with an error then check the Output and Log file for error details.
This is how the accounting works. Everything pertains to what an Organization owns, have and what it has to give. There is always a balance to what it owns and what it has to give.
This “balance” is converted into an equation, also called the Accounting Equation, which is:
ASSETS = LIABILITIES + OWNER’S EQUITY
though I’ve understood it this way:
OWNER’S EQUITY =  ASSETS – LIABILITIES
Let’s take a simple example to justify the above equation, say you have Rs.1,000 but you know that you have to pay a loan of Rs.400 that you borrowed from your friend.
So according to the equation Rs.1000 is your Asset, Rs.400 loan is your Liability and Rs.600 is the Equity that you own.
Every organization which is registered with Government is obliged to disclose the above mentioned balance in a document called Balance Sheet.
That’s all for the accounting equation.
Moving on after the accounting equation,
There is a
  • Debit (Always on the Left Side, written as “DR” for shorthand) and
  • Credit (Always on the Right Side, written as “CR” for shorthand)
  • Debit Side should always be equal to Credit Side or
  • Left Side should always be equal to Right Side or
  • DR = CR
With the Debit and Credit comes in the
  • Increase in balance or
  • Decrease in balance
There are 5 natures of account. Every account can have any one nature and that’s why we can also call it natural account. These natures are:
  1. Assets
  2. Liabilities
  3. Revenue
  4. Expenses
  5. Owner’s Equity
ASSET: Literally asset is any thing which is valuable to a person, organization or any entity. For example we say that “his quick learning ability is an asset to him” or “Her writing ability is her asset”. Why do we say that? Because quick learning skill or writing ability adds value to a person. A writer sells his writing skills to earn money, similarly in terms of business anything which is valuable to a business is the asset.
Say your organization is a pharmaceutical and manufactures Medicines, then all the chemicals used to manufacture medicine is your asset or in other words the Raw Material is your asset. The cash your organization own is an asset because it can be used to buy items or pay your employee who in turn are used to run your business. There are different types of assets, the broader categories of asset are Current Asset and Fixed, but let’s not discuss it here. For now it is enough to know that asset is anything which is valuable to your organization.
Asset INCREASES when it is Debited and DECREASES when Credited.
Any organization which is registered with the government and exists as Legal Entity is obligated to disclose its Assets on the balance sheet to the government and its Creditors. You might ask Who are creditors and Why is it that an organization is obligated to disclose asset to them? With Creditor comes in the liability.
LIABILITY: Comes from the word “Liable”. Literal meaning of Liable is “to be obligated” , “to be responsible” or “Legally responsible”. In terms of accounting you become liable, responsible to pay when you buy or purchase any thing from another entity. You are liable to compensate whatever you’ve bought. Generally an organization records its liability and pays it afterward. Again, there are different types of liabilities like Short Term Liability and Long Term Liability.
Liability INCREASES when it is Credited and DECREASES when Debited.
OWNER’S EQUITY: This is the share of owner in the business.
Equity INCREASES when it is Credited and DECREASES when Debited.
REVENUE: By definition it is the total gain before inducting any expense. It is mostly associated with the Asset. When any organization sell goods or renders its services, it records an increase in Asset and with this increase comes the gain it has made from selling the goods or services. This gain is called Revenue or Income.
Revenue INCREASES when it is Credited and DECREASES when Debited.
Revenue are not displayed in Balance Sheet. They are reflected in Owner’s Equity.
EXPENSE: By definition any payment made is an expense. How payments are made? Either by Cash or Credit which eventually means Cash. So redefining Expense “The outflow of cash to any person or organization for its supplied Goods or rendered Services”. We incur expenses daily, for example, taxi fare is an expense, dine-out payments are expenses. Expenses are associated with Liability. Whenever an organization books a liability, it is mostly against some expense. There are different type of expense
Expense INCREASES when it is Debited and DECREASES when Credited.
Following table shows the Tabular form of the effect
Nature DEBIT CREDIT
Asset Increase (+) Decrease (-)
Liability Decrease (-) Increase (+)
Equity Decrease (-) Increase (+)
Revenue Decrease (-) Increase (+)
Expense Increase (+) Decrease (-)
In Oracle General Ledger, when we attach the “Natural Account” Flexfield Qualifier to a segment. System attaches the 5 nature on the Value form. When we add the Natural Account Value, we have to define the nature of the account as well.
When we define the natures of the account, the accounting rules of Debit and Credit works accordingly. Like in Payables, the line item is Debit side, so if you’ll give an expense or asset account, it will increase and vice versa.
It is necessary to understand the application accounting behavior in order to properly suggest and implement the accounting solution in an organization.
1) It is possible to release an order line independently of other order lines
    and order header.
   Yes you can using the shipping transaction form.(From pick release you can release
 complete order and not independently the lines).
 Immediately after the order is booked, we can come to the shipping
 transaction form, pull up that order, and for a specific line, we can
 “Launch Pick Release”. We can also subsequently create a delivery for this
 order line and then ship the order as well. Hence we can ship an order line
 independently of the other order lines.
 Pick release can also be used to release lines independently, by providing
 conditional scheduled ship dates ,request dates,in which case, it will release
 those specific lines.
 
2) Once The order is booked ,are the delivery details/lines created ??
  Yes. immediately after the order is booked, the delivery lines are created (not deliveries)
  (which can be seen from the wsh_delivery_details which reference the sales
  order). However once the deliveries are created (either automatically after
  the pick release or manually based on the system options), these deliveries
  lines are asssigned to the delivery created. Only after
  the deliveries are created we can ship (or ship confirm) them.
3) What is Defer Interface?
   There is a flag in global parameters setting which is Defer Interface.
   Typically once the order is ship confirmed, then the
 trip stop report is printed and the order is ready for interfacing to AR.
 However if the defer interface flag is set, then even after the ship confirmation,
    the trip stop process does not pick this up and is subsequently not invoiced.
 Defer Interface flag can also be set at the ship confirm window level.
 
4)How do we apply credit holds to Orders :
 One way of applying a credit hold for an order (based on the customer credit)
 is to use the credit management. Another way is to specify within the OM,
 the credit limit at the customer or site level as follows,
  Customer => Profile : Amounts
 
   We can specify both order credit limit (which is specific to an order)or credit
   limit(which is entire credit limit).
 
5).What are Deliveries and Delivery Lines, and which one is created first?
  Lets take an example. Let us say there is a sales order which consists of
   two lines. Once the order is booked, two delivery lines are created automatically.
   If there are two order lines, there will be two delivery lines,so for each
   order line, there is a delivery line.  Then as a next step, we assign these
   delivery lines to a delivery. And if the autocreate is checked, then automatically
   a delivery is created after pick relase  and the two delivery lines are assigned
   to the newly created delivery.
    
6) What are Container Items :
    Container Items are also inventory items,which are flagged as “Container”
 in the Physical Attributes tab. Usually they are not Customer orderable,
 customer ordered ,invoicable etc. ;
    Items => Physical  Attributes => Container Area.
 
    We can also set the item as a Vehicle as the case may be.
 
7) What is packing the Items :    
   Usually we  Pack the Items, that is when we need to define the Container Item
   Relationship,which is defined here,
      Setup => Shipping => Container Load Details.
 
 Here you specify the relationship between the regular items (like say Printer)
 and the container items (like Box, Carton)and the maximum quantity that can
 be filled in that container etc.
 
 Once that is done, we should be able to do the packing.
  
   8) What is partial cancelling of the order line.
   If you change the order quantity say from an original value of 50 to ,say, 45,
   then the orderline is said to be partially cancelled.
   write more about this
  
   9) What is splitting the order lines and how does pick release help in the case
   of split lines ?
   Let us say we have an order which requires multiple shipments over time, then 
   you would split the order line, rather than creating multiple order lines.
   So in each split line, we specify the quantity and the request data,warehouse
   from where it should be shipped. Based on this, the scheduled ship dates are
   also populated accordingly for each split line. 
   Once this is done, during the pick release process, we can specify up to which
   schedule date /request date we want the lines to be released and then accordingly
   the lines will be released.
  
10. What are line sets,ship sets, arrival set, fulfillment sets?
      Line set is a generic term,which you specify at the order header level,
    which can be a ship set, arrival set or fulfillment set.
    If you specify a ship set,say 1, for a group of lines, then during pick
    release we can release the lines based on that ship set number.
    Also a line can belong to a ship set or arrival set,but not both.
       
 
13). What are backflush transactions ?
 Backflush transactions are those WIP (workin process) transactions which pull
 the inventory for the manufacturing operation. It is an issue (outgoing from
 inventory) operation and not a receipt operation. 
  
14) What are the examples of ShipOnly and InvoiceOnly orders.
    Ship only orders are those where we just ship the item to the customer and do
   not invoice them. Example of shiponly orders are demo items, and sample
   items,which the customer uses and probably returns them after.
 Invoice Only Orders are those where we just invoice the customer,but we do not
   ship any item.Example of Invoiceonly order could be a subscription item
   where we just invoice the customer for that month,but we donot ship
   any item.
    
15) What are trips and stops and how they are related to deliveries.
   A trip consists of atleast two stops, one the pick-up point and one a drop-off
   point. When we ship confirm a delivery,a program called “Interface Trip Stop”
   is automatically run which creates a trip stop and the delivery is assigned
   to that trip.
 
16)What are the different kinds of Orders
       Regular sales order, RMA, Drop ship, Internal Sales order.    
  
17) What are the possible reasons the inventory quantity can be driven negative
   for reservable items.
   Usually when we pick release, a quantity is reserved and if there is not enough
   quantity then the reservation does not happen, and the pick release will fail.
   However after a successful reservation , when we come to the delivery lines,
   we can change the shipped quantity on the delivery lines as well. If that shipped
   qauntity is more than the requested quantity and if that quantity is more than
   the available quantity, (and if negative quantities are  allowed) then the
   inventory quantity can be made negative. if negative quantities are  allowed for
   that inventory organization, then those records might be stuck in the inventory
   interface.
  
18) Can we change an order after we book it ???
    Yes, as long you dont violate any processing constraints.
 
19) What is the difference between Pick Release and Pick confirmation.
 Pick release is the process that you do in Order Management which will create a
 move order and it goes thru approval, allocation and transaction.
 Pick Confirmation is an inventory operation which is basically transacting a
 move order which results in a subinventory transfer of the material from the source
 subinventory to staging subinventory.
    Hence Pick Release will internally call pick confirmation process.
  
20) What is retroactive billing ??
  
21) what is shipping document set??
   A shipping document set is a set of shipping documents,which you specify at the time
   of ship confirm,so that Oracle shipping wil print all those documents. And they are
      Bill of Lading => A receipt given by the carrier to the customer,acknowledging
         the goods being shipped and specifying terms of delivery.
      Waybill =>it is identical to Bill of Lading, but it is not a document of title.
      Commercial Invoice=> prints all confirmed shipped item in a delivery along with value.
      Mailing Label => address label showing where we are shipping.
      Pack Slip  => slip which shows the contents of the package.
      Vehicle Load Sheet Summary =>specifies the loading sequence of items in a delivery.
   
 Please note that the document set need not consist of all of the documents.
 
22) Is it possible to book an order with out any line items ? What would be the
 business scenario for this kind of order ??
  Yes.
 
23) What is packing slip ?
   Let us say we have an order consisting of 10 items. A pack slip mentions all the
   items. Basically it is just a confirmation from our side ,what we are shipping.
   A bill of lading is a document from the carrier what we are shipping. 
 
24) What is pick slip?
   A pick slip is a document printed by the move order process in Inventory,which
   tells what has been picked.
 
25) Does the order header close immediately after all the order lines are closed??
        
26)What is the backordered status in the delivery lines mean ?
   The term “backorder” or “backordered” is a status,which means that during
 pick release, that item is not having enough stock and hence the status of
 the order line or shipping line changes to backorder. Please remember that
 backordered is just a status, it does not initiate any kind of drop ship
 process,to purchase that item from a supplier etc. To resolve this issue ,you
 will have to manually do a receipt for that item and have enough quantity onhand.
 
27) What are the different modules which Order Management will interact with ?
 
 Order Management interaacts with different modules based on different kinds
 of items, pricing, type of shipping etc
     Inventory (for pick release, shipconfirm)
  Pricing,Advanced Pricing  (for formula, attributes, qualifiers, modifiers)
  Shipping Execution (shipping transactions ex delivery,trips,stops)
  Manufacturing (for BOM Items, assemblies etc before/after booking process)
  Purchasing (for drop ship, internal sales order, RMA receipts)
   
28) If aline is stuck at Shipped status, and is not closed, then what is the
 difference between running Workflow Background Process in Inventory versus
 Order management,coz running from Inventory is pushing to AR ?
  
 
29) Does Order Header close immediately once all the order lines statuses are closed?
 
 No. The standard functionality of the Order header closed an order header at
 the month end even if all the lines are closed in the middle of the month. So
 even if we run the  Workflow Background Process for Order Header, the status
 will not change to Closed for the Order Header. However this does not stop
 interfacing the lines to AR. 
 
30) Can you explain the difference between the Subinventory Transfer,Move Order,
 Inter-org Transfer And Internal Sales Order?
 
 
31) Explain the process of backorder during the ship confirm process.
   
   We know that during the pick release process ,if there is not enough quantity
   the delivery line status will automatically change to backordered. Now even
   during the ship confirm, we can do a back order. During pick release the quantity
   has moved from source to staging subinventory.
   Sometimes we may not ship the entire quantity that is pick released. The business
   reason for this could be that we need that material for some urgent or important
   customers and hence we might partially ship the quantity. And this is done in
   the following steps as follows.
 
 — In the delivery line, the requested qty(say 100) and shipped qty is null. Let
 us say we want to ship only 60 and not the remaining 40. So in the shipped qty
 you enter 60, so the backordered quatity will be 40
 
 — In the ship confirm window, in the unspecified quantities list box change it
 to “Backorder”. Then the 60 will be shipped and the remaning 40 will need to be
 pick released.
 
 — Now come to the sales order and look at the lines, the original line will be
 split into two lines one with 60 ,having status of shipped and one with 40 having
 a status of “Awaiting shipping”.
 
 — Do an explict subinventory transfer back from staging to source subinventory as
 this will not happen automatically.
  
 Hence understand the status “backordered” ,the quantity needs to be pick released
 again.
 
32).  what is the difference between bookings and revenue ?
 typically revenue is referred to as current sales while booking is referred to
 as the projected future revenue.
 
33)   what is the difference between billing and invoicing ?
 Billing is a generic term used for AR invoices, credit memos,debit memos etc,
 while invoicing information specifically refers to AR invoices.
 
34)   what is item conversion and customer conversion ?
 Lets say we have Oracle ERP A and ERP B and we are trying to convert items
 from A to B. Then, when you bring an item X from A to B system, then that
 id/code will be preserved.
 The other option is to create corresponding new items in system B for each
 item in system A and then try to reference the items from system A.
 
35)   What is customer conversion and how does it affect order management ?
 Basically when we are integrating two systems, then we need to bring in the
 customers of one system to another,so we can transact in the new system
 i.e we can create orders.
 Hence if we are bringing open orders from system A to B, then we need to
 do the item/customer conversion, because the open orders in the new system
 will be referring to the old item numbers or customer numbers. For new
 orders, that means the orders themselves are created in the new system.
 
36)  what is business alignment ?
 Business alignment is basically business aligning with IT. For ex, IT might
 implement a new version of oracle ERP with new features ,then the business
 should agree to the change and be able to adapt to the changes.
 
37).  What is a Managed Service Point :
 Means some company XYZ takes care of a particular functionality (like billing
 invoice,check printing) in some other company ,say like Cisco. And for this
 service, cisco pays them a flat usually monthly payment. Usually the managed
 services provider works remotely from the company i.e managed services offerer.
 
38). What are the checklist of items that happen while booking the order ?
 Scheduling,
 Credit check,
 Checking Hold if they exists,
 Repricing,
 Process Price adjustments (apply modifiers),
 Payments (Authorization of credit cards)
 Sales credit verified,
 Constraints are validated,
 System parameters are validated,
 tax calculation,
 Configuration Validation,
 Workflow progress based on the type of order,
 Shipping data are populated,
 IB(Install Base), CZ(Configurator) are populated.
 
39). How do you fulfill the software Orders versus tangible item orders ?
 
For tangible items orders, fulfilment is shipping the order; and the IB instances are
created once the item is shipped. For software orders;  the two ways of fulfillment are
Ship the cd box or fulfill it online (by downloading etc);
        If it is fulfilled online, the IB instance is immediately created with out the serial number;
        And once the product is shipped, that is when the IB instance can be updated
 with the right serial#.(you cant put a serial# on the box).
 
40). How do you ship the orders which you frequently ship the items together ?
 
For ex, let us say you very frequently ship the order consisiting of one cd, one hardware
token and one user manual. Then it makes sense to group them into a BOM(bill of material)
Kit. That is a BOM of the type of Kit. A kit is a group of components,but a kit itself is not
shippable although the component items are shippable. Also ensure that the on hand exists
for all the component items so the pick release/ship confirm will not fail.
 
41). what is defer interface (at ship confirm) in order management ?
 Basically at the time of ship confirmation, if the Defer interface is checked/enabled
 then the Interface Trip Stop program is not run. If the Defer interface is not
 checked/enabled then the Interface Trip Stop program is run. The interface trip stop
 program basically updates the inventory,reduces the on hand quantity and also updates
 the order lines status to closed from shipped.
 
42). At what point of time the onhand quantity gets decremented ?
So once the ship confirm completes and if the defer interface is not set, that is when the
 inventory interface happens and the onhand quantity is decremented to reflect the
 correct status in inventory.
 
43). Once the order is shipped, how can we see the delivery lines ?
Once the order is shipped, we can pull up that order in the shipping transactions find form,
 by selecting null from the line status field.
 We can also run the report like “Shipped Delivery Lines report” and provide the order number to
 see the delivery# details etc.
 
        Shipping => Interfaces => Run => Shipped Delivery Lines report    
 
44)  Profile option for seeing the output file ?
The profile option to see the output file and the log file is starting with “Viewer%”
 
45). you can have an item which is not inventory item, but it could be a customer orderable item?
Yes. for ex, service item, which are not inventory items (because they are not stockable/shippable) however a customer can order the service item.
 
46). What are the different scenarios of ordering service from OM ?
Consider these situations :
You can order service from OM for an item
    which the customer has on the same order
            This is a simple case.
    the customer already owns the item,
            Then you should know that order number,line#,shipment#,date of service start. Done on the service tab.
    or the item should be there in Oracle installed base.
            Then you should know the item instance# or item serial number,called reference number in the form. And if the item does
             not exist in the Installedbase,then you should create it manually.
 
47). where do you define a fulfillment flow. ??
 Each order type will have a workflow for header/line attached to it and the order lines
 will flow those steps.
 
48). Does defer interface defer OM/AR interface ?
 No the defer Interface is basically defers the shipping module writing the status
 back to the OM/inventory interface. However only after this writeback(interface trip stop
 program completion), the line status at the order level changes from shipped to closed and
 at the shipping line status changes from closed to Interfaced.
  And only after the Orderline status is closed, it can be interfaced to AR(if it is an invoicable
 item).
 
49). How do you fulfill a service item order  ???
 Lets us say there is a consulting service order. Usually these kinds of orders
 are fulfilled after the serviced is delivered. the regular orders as fulfilled
 once the item is shipped.while these orders are fulfilled once the service is
 performed and the timesheet is filled,approved the appropriate authority and sent over.
 
50).  Why is that in OM, once a sales order is created for a customer, a credit hold is
 automatically applied?
 It may or may not be. It is decided by the workflow process.
 
51).   I understand that BOM’s should be defined if the warranty has to be automatically
  created upon purchase of a product. What if the customer does not implement BOM?
 When you purchase OM, the basic functionality of BOM is provided by default.
 
52). Does the workflow background process need to be run with deferred processes yes?
 Yes to clear the waiting processes,if any.
 
53).  Can the delivery lines in Shipping module be sourced from Other modules than OM?
 The sources for the delivery lines are Order Management,Project Contracts and Shipping.
 
54). What is credit managment module and what is its functionality ?
 Credit Management is a separate module which basically checks whether the customer
 credit is in good holding and if not,it will put the customer order on hold.
 Credit management can be hooked up to the OM/AR/Collections as different touch points. 
 (just like ipayments module).
 
 
55). Is a move order created for a non-reservable items ?
 No, when you created a non-reservable item and pick release a sales order for that item,
 then there will not be a move order and hence there will not be a reservation or
 the item movement from the current subinventory to the staging inventory.So the item
 stays in the place where it is currently. This is said to be looser inventory control.
 
55 a).What is the difference between pick releasing a Reservable Item versus
      Non-reservable Item?
   Usually the inventory items are by default reservable and when an order with
   a reservable item is pick released , then during the allocation and transaction
   process, the material reservation is made and move order is transacted.
  
   However when a order with a non-reservable item is pick released, then during
   during the pick release process,then there is no allocation required.
  
56) What are the conditions under which the inventory quantity can be driven
   negative(for non-reservable items)?
   Usually when the items are non-reservable, then the pick release process will
   not check for the item quantity and there is no reservation involved. Hence
   when you shipconfirm ,there is a chance that sufficient quantity might not be
   there to ship.
   So if there is insufficient quantity in an inventory organization ,&
     if negative quantities are allowed in that organization , &
   if the item and subinventory both are reservable (if an item is reservable
   but a subinventory is not, the item quantity in that subinventory is not
   reservable),
 Then if the above conditions are satisifed, the inventory quantity can be
 driven negative.
 
 
57). What are the consequences of allowing /disallowing negative balances in inventory?
 If you do not allow negative balances in your inventory it will block any shipment
 (delivery) where a line is shipping more than the quantity available in inventory.
 The error is generally human. You accidentally enter a larger Ship Quantity than you picked.
 The whole delivery will be stuck in the Inventory Open Interface.
 To solve the problem either go through the entire delivery and find out which line
 was overshipped. Then move the required quantity to the staging area and resubmit
 all the lines in the Inventory Open Interface. Now run the Interface Trip Stop – SRS
 in Order Management. This should do the trick.
 
 Otherwise, allow negative balances in your inventory. And resubmit etc. When the
 delivery has been processed there will be a negative balance in the staging area.
 
Research onthis. if the shipped quantity is more than the requested quantity for the reservable vs non reservable items
do a copmlete flow on this. ??
 
 
58). How to create a Manual Delivery in OM ?
 Navigate to Shipping Transaction Form
 Ensure that radio button is on deliveries in the top right corner (ie in “Search For” region)
 Click On find button (You can enter a few criteria to make the search faster)
 Once the results screen opens, click on the general create button green “+” icon at
  the top left menu.
 It will create a new record. Enter all required details and save.
 Now you can come to the shipping trx form ,find delivery lines for a sales order and
  assign the manually created delivery above to these delivery lines.
 
 This can be understood in the way that when we create a customer, the first thing
 that comes up is the customer search screen,so that we can find existing customers,so
 that there are no duplicate customer entries.
 
59). what is the difference betweeen manual delivery vs automatic delivery ?
 
 Actually the difference is when you are creating Automatically, the system will
 create one delivery for the lines involved but if you want to do it your way i.e.
 either club deliveries or may be have a delivery for each line seperately then it’s of use.
 
 To my knowledge if you don’t have a seperate Trip Planning or Delivery Planning department
 it should be left to create aumoatically as you won’t be getting benefited much by that.
 
 
59).  How do you fulfil an RMA order?
  Standard tangible orders(with tangible items) are fulfilled by physically shipping those
items. However return orders(like return only, rma only, rma with credit etc) are fulfilled
after we receive that item into the inventory. So the steps would be
 – First book the rma order and note that order #.
 – then go to purchasing/receipts and in the customer tab, receive that item
  into inventory. check to see if the onhand has increased,ensure that the
  receving transaction processor is running.
 
 
60). What are the steps involved in shipping of an ATO Item  ?
 
  For ATO model you cannot ship the item immediately after booking. Please
  find the following steps.
 
 Click the actions button and select progress order. This will run a concurrent
   program called autocreate final assembly. If you see the output of the
   request you will get the job no.
 
 Query the job in discrete job window and check whether it is released.
   If not release it.
 
 Transact the job in move transaction form.
 Complete the job
 
 Now query your sale order and check the line status. It will be Awaiting
   Shipping.
 
 Now you can ship the order.
61). What is lead time ?
 The generic lead time definition suggests it is the amount of time between the
 placing of an order and the receipt of the goods ordered.
 Usually we can see it as the time difference. So we can have different kinds of
 lead times like Transit lead time & Delivery Lead Time etc.
 
62).  What is the difference between Operating Unit Id and Inventory Org id?
 
 As mentioned before, usually whenever we are dealing with org id’s in the
 Purchasing,OM, we are referring to the operating unit id, while in the
 inventory we are referring to the inventory org id.Now when we enter lines
 in OM, we choose an inventory item id. Now this inventory item is corresponding
 to the inventory organization id that is specified in the Warehouse id.
 Actually the warehouse id corresponds to the Inventory Organization Id.
 Incidentally the warehouse id is present both at the header level as well
 as the line level.  Also we can even mention what is the subinventory from
 which this item should come at the order line level.
 So what this effectively means is that we can place sales orders having
 two lines corresponding to the two different inventory organization ids as the
 warehouse id is present also at the line level.
 
63). What are defaulting rules in Order Management ?
 
  Generally while we are creating an order online/offline, certain information
  defaults based on the defaulting rules. these defaulting rules can be defined from the
   setup => rules => defaulting.
  One important point to note here is that when we create a default rule for each
  attribute, we mention what is called the default sourcing rules. Here we specify
  the sequence in which this attribute will be sourcing. An an ex, consider
  a bill to attribute, we specify the sequence as
           shipto. billto
        customer.billto
        blanketheader.billto
        agreement.billto.
 which means if the shipto entity does not have the billto info,then it goes
 to the customer and gets the billto, and if it does not find there to
 it goes to blanketheader and gets it etc.     
 
64). Explain the terms, Manufacturer, distributor,reseller, retailer?
    A Manufacturer manufactures or produces the goods etc.
    A Distributor buys the goods from the Manufacturer, stocks them and sells them
 to the resellers or retailers(although he may not stock them sometimes).
    Reseller(also called Value Added Resellers,VAR’s) will get the goods from a distributor
 and sells it to the consumers. Remember they add value,rather than just selling like
 that. For ex; they buy a computer and they can add a one year ext warranty for that
 for a price and then sell it.
    Retailer is also a reseller,however they usually dont add value,they just sell like that.
 
64a). What is the difference in buy-stock-sell vs sell-source-ship model?
    The traditional model of buy-stock-sell is distributors will buy goods, stock and sell
 them; in this model the lead time for the order fulfilment is very less.
    The new model is sell-source-ship ,where we take the order and source those orders
 from an external supplier (at that point of time) and then ship, here the lead time
 is more,however it results in cost savings. This is typically the drop ship model.
 
65). How does the receiving system recognize the difference between receipt of a regular PO
 versus drop ship PO???? i.e what is that specific flag that recognizes the difference ?
   I believe when an order line is marked as with source type “External”, then it make
   an entry into a drop ship sources store(i.e oe_drop ship sources which stores the
   order header and line id info).
   And when the receiving system looks for a PO, it looks in this table if it is a drop
   ship PO, and if it is then it does a logical receipt of the goods.
 
66). What is the logical receipt of goods in the system?
  The logical receipt means the onhand quantity does not go up in the inventory. Basically
  the system increments and decrement in one transaction and onhand remains same. This happens
  in the case of drop ship PO receipt of goods.
 
67).How do you do a drop ship order across operating units i.e you create an drop ship
   order in US to ship a product from an australia supplier to your australia customer?
 
  Basically cross OU/ledger functionality is available only in R12 and not in 11i.
  The only difference is a couple of steps
 First, set the receiving or in the sales order line as cross OU,receiving org.
 second, receive the PO in the desitination OU/ledger and follow the same stepsfrom thereon.
 Third, intercompany transactions for this transfer.
1.Explain about Accounts Payable. 
Ans)The Accounts Payable application component records and manages accounting data for all
vendors. It is also an integral part of the purchasing system: Deliveries and invoices are
managed according to vendors. The system automatically triggers postings in response to the
operative transactions. In the same way, the system supplies the Cash Management application
component with figures from invoices in order to optimize liquidity planning. 

2.What is the meaning of invoice?
Ans)An invoice or bill is a commercial document issued by a seller to the buyer, indicating the products, quantities, and agreed prices for products or services the seller has provided the buyer. An invoice indicates the buyer must pay the seller, according to the payment terms.

In the rental industry, an invoice must include a specific reference to the duration of the time being billed, so rather than quantity, price and discount the invoicing amount is based on quantity, price, discount and duration. Generally speaking each line of a rental invoice will refer to the actual hours, days, weeks, months etc being billed.

3Can you give a sample Process Flow for Procure to Pay Cycle?

Ans) Process flow for Procure to pay will go through two departments
(Commercial & Finance)
Procure – Commercial Department The following steps involve to procure any item
1. Received Requisition from concern Department
2. Request for Quotation from Suppliers at least three
3. Finalize the best Quotation by keeping in mind about our companies standard
4. Check the Budget for the same
5. Negotiate with supplier for more economic pricing and finalize the payment terms
6. Process the PO and forward to the supplier to supply the goods and services 

Pay Cycle – Finance Department 
The following steps need to be fulfill
1. Invoice should be match with PO
2. Invoice should has all the supporting documents such as PO copy,Delivery note duly signed by receiver (our staff who authorized to received goods / store keeper)
3. If the invoice is for services then it should be forwarded to the concern department head or project manager for his confirmation of work done and his approval 
4. Even if it not the services invoice, it should forwarded to the concern person’s approval who request the PO for the same
5. Finance can reject the invoice if it is not budgeted and ask for the reasons.
6. After receiving all the confirmation and approvals from the concern department heads the invoice will be update in to the accounting system first in order to avoid any duplication of Invoice and PO (it shown on accounting package if the invoice is duplicate if not, altelast it tells you if the PO already used or cancel)
7. Finance approved the invoice and process the payment base on payment terms with the supplier.
 

4)What are the journals entries in Procure to Pay Cycle.
Ans) 

Description                                                                             DR                                  CR

A) Po creation                                                                    No Entry                          No Entry

B)  While Receiving the goods                                       Material Receiving            Ap Accurval 

C) While Inspection                                                        No Entry                            No Entry 

D) While Trans ford the good to Inventory               Inv Org Material              Material Receiving
                                                                                     Purchase price Varience

F) While Po Is Matching to Invoices                         Ap Accurval                        Liability


G) While Making the Payment                                 Liability                               Cash Clearing 


 H) Ofter Reconciliation                                           Cash Clearing                     Cash



 I) Final Entry                                                            Inv Org Material                Cash

5)What is the difference between EFT & Wire?
Ans)EFT and WIRE are the most popular form of electronic payment method. EFT stands for electronic fund transfer and it is one of the fastest mode of electronic payment after WIRE. EFT is a batch oriented mechanism for transfering funds from one bank to another because of which clearing & settlement takes around 2 to 4 days. On the other hand, WIRE is a RTGS i.e. real time gross settlement system of making the fund transfer on real time and gross basis. Clearing and settlement happens on the same day. WIRE is more expensive and faster than EFT.  

6) What is meant by Distribution Sets:

Ans)You can use a Distribution Set to automatically enter distributions for an invoice when you are not matching it to a purchase order. For example, you can create for an advertising supplier a Distribution Set that allocates advertising expense on an invoice to four advertising departments.
You can assign a default Distribution Set to a supplier site so Payables will use it for every invoice you enter for that supplier site. If you do not assign a default Distribution Set to a supplier site, you can always assign a Distribution Set to an invoice when you enter it.

Use Full Distribution Sets to create distributions with set percentage amounts, or use Skeleton Distribution Sets to create distributions with no set distribution amounts. For example, a Full Distribution Set for a rent invoice assigns 70% of the invoice amount to the Sales facility expense account and 30% to the Administration facility expense account. A Skeleton Distribution Set for the same invoice would create one distribution for the Sales facility expense account and one distribution for the Administration facility expense account, leaving the amounts zero. You could then enter amounts during invoice entry depending on variables such as that month’s headcount for each group.

7)What is the meaning of GRN? 
Ans) GOODS RECEIPT NOTE MEANS IT PROVES THAT MATERIAL IS DELIVERED AT STORES DEPARTMENT. GRN IS THE BASE DOCUMENT AND IMPORTANT DOCUMENTS FOR PROOF OF RECEIPT OF MATERIAL AT WARE HOUSE.THIS CAN BE PREPARED BY STORES DEPARTMENT AND APPROVED BY PLANT HEAD. GRN CONTAINS ORDERED QTY,RECEIVED QTY AND ACCEPTED QTY. BILL WILL BE PASSED BASED THE GRN NOTE. ONCE THE GRN IS PREPARED AUTOMATICALLY INVENTORY WILL BE UPDATED AND ACCORDINGLY PAYMENT WILL BE RELEASED TO THE VENDOR.

GRN contains the following details.

1.Ordered quantity .
2.Received Quantity.
3.Defective quantity in received quantity .
4.Quality standards details.


8) How does the payment mechanism work?

Ans) The open items of an account can only be cleared once you post an identical offsetting amount to the account. In other words, the balance of the items assigned to each other must equal zero.During clearing, the system enters a clearing document number and the clearing date in these items. In this way, invoices in a vendor account are indicated as paid, and items in abank clearing account are indicated as cleared.

You generally use the payment program to clear invoices. Manual clearing of open items is therefore not usually necessary. However, you will sometimes have to clear items manually if, for example, you receive a refund from your vendor or you have set up a direct debit procedure.


9) Difference between interface tables and base tables?
Ans)   The difference between the interface and base tables is as below

Interface table: is the table where the data gets validated before data get posted to the base tables. There are many interfaces which are seeded with Oracle. You can consider as the entry point of the data, and the interface checks the sanity of data.

Base tables: As told earlier once the data is validated will get updated in the base tables, and is considered as the data which is in the base table is accurate and used in many ways. (Reporting..etc..)


The base tables in AP are as follows:

1) ap_invoices_all
 

2) ap_invoice_payments_all
 

3) ap_invoice_distibutions_All
 

4) ap_payment_schdules
 

5) ap_payment_dustributions_all
 

6) ap_checks_all
 

7) ap_accounting_events_all 


8) ap_bank_accounts_all
 

9) ap_bank_accounts_uses_all

   

10) What is the process of creating an Invoices and transferring it to GL?
Ans)

 1. create batch
2. create invoice
3. create distribution
4. validate the invoice
5. actions -à approve
6. if individual create accounting click ok
7. If batch go to batch create accounting.
8. Create accounting hits Payable Accounting(Transfer) ??Program which will create accounting.
9. Run Transfer to GL Concurrent Program
10. Journal Import
11. Post journals
12. Hits balances.


11) How do u Transfer from AP to GL? 
Ans)“Payables transfer to GL program” is used to transfer from AP to GL.

12) How many types of invoices are there in AP.
Ans) 
1. Standarad invoice 
2. Debit Memo
3. Credit Memo
4. Mixed Invoice
5. Retain age Invoice
6. Transportation invoice
7. Prepayment invoice
8. Expenses Report Invoice
9. Payment Request Invoice
10. Po default
13) How many types of purchase order types/agreements are there?
 

A) Standard Purchase Order: You generally create standard purchase orders for one-time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions. If you use encumbrance accounting, the purchase order may be encumbered since the required information is known

B) Planned PO : A planned purchase order is a long-term agreement committing to buy it
items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities and estimated cost.
EX: Buying goods for Christmas from a specific dealer.


C) Contract PO : You create contract purchase agreement with your supplier to agree on specific terms and conditions without indicating the goods and services that you will be purchasing i.e. for $ amount you must supply this much quantity. You can later issue standard PO referencing your contracts and you can encumber these purchase orders if you use encumbrance accounting.


D) Blanket PO : You create blanket purchase agreements when you know the detail of goods or services you plan to buy from a specific supplier in a period , but you do not yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.
A Blanket Purchase Agreement is a sort of contract between the you and ur supplier about the price at which you will purchase the items from the supplier in future. Here you enter the price of the item not the quantity of the items. When you create the release you enter the quantity of the items. The price is not updatable in the release. The quantity * price makes the Released Amount. Now suppose your contract with your supplier is such that you can only purchase the items worth a fixed amount against the contract.
 



14.Payment Method:
A funds disbursement payment method is a medium by which the first party payer, or deploying company, makes a payment to a third party payee, such as a supplier. You can use a payment method to pay one or more suppliers. Oracle Payments supports several payment methods for funds disbursement, including the following:

  • Check
  • Electronic
  • wire
  • Clearing

Check:
You can pay with a manual payment, a Quick payment, or in a payment batch.

Electornic:
Electronic An electronic funds transfer to the bank of a supplier.You create electronic payments either through the e- Commerce Gateway, or by delivering a payment batch file to your bank. For both methods, Payables creates a file during payment batch creation. If you are using the e-Commerce Gateway to create the file of payments, an EDI translator is required to create the EDI Formatted file prior to delivering it to your bank.For electronic funds transfers, the file is formatted and delivered to your ap.out directory for delivery to your bank.

Wire:
Wire Funds transfer initiated be contacting the bank and requesting wire payment to the bank of a suplier.A payment method where you pay invoices outside of Payables by notifying your bank that you want to debit your account and credit your supplier’s account with appropriate funds. You provide your bank with your supplier’s bank information, and your bank sends you confirmation of your transaction. Your supplier’s bank sends your supplier confirmation of the payment. You then record the transaction manually.

Clearing:

Clearing Payment for invoices transferred from another entity within the company without creating a payment document.Payment method you use to account for intercompany expenses when you do not actually disburse funds through banks. You do not generate a payment document with the Clearing payment method. When you enter the invoice, you enter Clearing for the payment method.You can record a Clearing payment using a Manual type payment only. 

15.What id recurring invoices? What are AP setup steps? 
  
Ans) some times suppliers would not be sending any invoices. but still the payment have to made to home: rent, lease rentals. in this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices is called template. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.

 SET UP:
 1)we have to create one special calendar 
2)we have to create one full distribution set 
3)we have to enter payment terms in the recurring invoice window 
4)enter the template no, first invoice amount, special invoice amounts