Oracle P2P tables

 P2P tables in Oracle EBS



Req header - PO_REQUISITION_HEADERS_ALL

Req Line - PO_REQUISITION_LINES_ALL

PO Header - PO_HEADERS_ALL

PO Line - PO_LINES_ALL

PO Distribution - PO_DISTRIBUTIONS_ALL

Line Location - PO_LINE_LOCATIONS_ALL

Receipt -RCV_SHIPMENT_HEADERS

Receipt line - RCV_SHIPMENT_LINES

Transaction - RCV_TRANSACTIONS

Lot - rcv_lots_supply


Comments

Post a Comment

Popular posts from this blog

Invoice with RCM Taxes in Oracle R12

Image
  1.        Create AP invoices                                                                 2.  Enter Line details. 1                                                                                                      3. Enter Distribution account. 1                                                         4.    Go to India Tax Detail form.                                               5 .        A) Enter Organisation & location details.                                                      b) Enter the Tax category as RCM taxes.                                                      c) Use the intended code & save taxes.                                                   d) check recoverable flag enable & recoverable amount                                     e) Check Self Assessed/Reverse charge flag enable.                                                           f) Apply the taxes                                          
Read more

OSP Process in OPM

Image
 1. Create a Document 2. Release Batch  3. Release Step 4. Requisition Import 5. View Requisition  6. Auto Create Purchase Order & Approve 7, Create OSP Challan Oracle Financial of India > Transactions > Outside Processing  View Tax & Approve the OSP Transaction. 8. Print Challan  Oracle Financial of India > Transactions > Print Challan 9.  Run India - Outside Processing Challan View Output  10. Create Material Slip Click on Picking & find Select the Pick rule & transact Move Slip generated 11. Transact Move Order Material at the OSP location  12. Receive Material  Confirm Taxes & Save. 13. Approve Receipt in OSP transaction 14. Run Request Resource Transactions Manager 15. View Steps in Batch  16. Transact Material ( WIP issue & Completion) in batch  17. Complete Batch  18. View Cost
Read more

Position Hierarchy in Oracle EBS R12

Image
 Position Hierarchy Define Job à Define KFF à Job flex field Key flexfield is non-mandatory to define Job & Positions KFF Define Position à Position Flexfield KFF Attach Flexfield at BU Define Approval Group Assign Approval Group           Define Position Hierarchy      Navigation à Purchasing Super user à Setup                  
Read more