Checked for Relevance 12-Aug-2013

ORACLE Work In Process
------------------------------


(OSP) OUTSIDE PROCESSING - FREQUENTLY ASKED QUESTIONS.
-------------------------------------------------------


CONTENTS
--------
1. Error Message states that the Quantity, must not be greater than    the Quantity available on the works order.  

2. How WIP and PO are integrated? 

3. Outside Processing Operations in Alternate routings. When the Outside    Processing item included in the Bill, we are Not able to tie it, to its operation sequence as the Bill shows only the operation sequences which refer to the primary routing.  

   Is there any other way of doing it, other than defining alternate bills or by making the operation sequence of alternate routing similar to the op. seq. in primary routing.?

4. What are the tables involved in OSP?

5. Which Reports to check for OSP accuracy?



QUESTIONS & ANSWERS
-------------------
1. Error Message states that the Quantity must not be greater than the Quantity available on the works order.  

Answer:
---------
There are two scenarios here.  First, The works order is awaiting a receipt, but a receipt is made for a Quantity greater than the WO Quantity.  In this case reduce the Transaction Quantity so that it equals the WO Quantity, and resubmit the Transaction.

In the second case, The work order has been completed or cancelled and in these circumstances it will be impossible to post the WIP Transaction. The Move Transaction would normally have caused WIP to be debited with the value of the Receipt, and the OP resource account (which is the same as the Receiving Inspection/Accrual account) gets the credit.
  
This Transaction will NOT take place and the Job will Close with a favorable Variance.  Want to find out the Value of the Receipt using the Receiving Transactions Distribution Report or the Receipts Summary (Special Menu).
 
Delete the Transaction a manual Journal Entry will need to be put through in GL to debit WIP variances and credit the receiving accrual account. 

This Type of error normally arises because the person that does the Receipt immediately goes on to complete the works order, Before the Receiving Transaction has been processed by the Receiving Transactions Processor.  
This can happen even where the Receiving Transactions Processor is running "online", because this may in fact have to queue behind other processes in order to run.


2. How WIP and PO are  integrated? 

Answer
------
Few Important Notes Here..

-  PO Created will have DESTINATION as SHOPFLOOR, LINE TYPE as OSP Line Type. 

-  PO RECEIPT of an OSP Item populates 
   WIP_MOVE_TXN_INTERFACE and WIP_COST_TXN_INTERFACE tables independently. 
   Hence, if the cost manager alone is running and MOVE manager is 
   Inactive,  The JOB can be charged for the OSP receipt but MOVE might 
   not happen. 

- PO Receipt of Item bbk_osp_item02 - Does NOT charge the MATERIAL Element 
  of JOB. 
   
  PO Receipt of Item bbk_osp_item02 - Does charge the OSP Element of JOB
  at the Resource Rate. 

3. Outside processing operations in Alternate Routings. When the outside 
   processing item included in the Bill, are NOT able to tied to its 
   operation sequence as the Bill shows only the operation sequences which 
   refer to the primary Routing. 
 
   Is there any other way of doing it other than defining Alternate Bills or 
   by making the operation sequence of Alternate Routing similar to the 
   op.seq. in Primary Routing.?
 

Answer
------
Verify whether the OSP operation is the last operation in the Routing. 
If it is, then the deliver to location in the requisition will be the location
assigned to the department for that outside processing operation. However, if
the outside processing operation is not the last step in the Routing, then the
deliver to location will be the location assigned to the department for the 
operation immediately following in the Routing.

When outside processing items are returned to the shop floor they are returned 
to the queue step of the operation immediately following the outside processing
operation, However if the outside processing operation is the last step in the 
Routing then the items are returned to the last step of the outside processing
operation. Therefore, the deliver to location that gets populated in the 
requisition depends on where the outside processing operation exists in the 
Routing.

4. What are the Tables involved in (OSP) OUTSIDE PROCESSING.

Answer: 
------
PO_REQUISITIONS_INTERFACE - It contains requisition information from other 
applications.  Each row includes the information needed to create approved or 
unapproved requisitions in Oracle Purchasing.  Oracle Work in Process populates
this interface when a User performs a Move into the Queue of an Outside
Processing Operation.

CST_COST_ELEMENTS - It stores the cost element information.  It is seeded with
five cost elements: Material, Material Overhead, Resource, Outside Processing,
and Overhead.

CST_RESOURCE_COSTS - It stores Resource and Outside Processing Resource unit
costs (RESOURCE_RATE) by cost type.


5. Which Reports to check for OSP accuracy ?

Answer:
-------
Please look at anyone of the following Reports:

- Receiving Txn Register Report
- WIP Discrete Job Value Report (Detail)
- Purchase Price Variance Report
- WIP Account Distribution Report

You will also need to know:

OSP Item UOM (Define Item)
Purchase Order UOM 
Setup Resource UOM and Frozen Cost (BOM)
Usage_rate_or_amount from the Routing (BOM)