Oracle EBS Application

Oracle Purschasing Setups Purchasing setups 1.       Creating Users 2.       Creating Purchasing Responsibility 3.       Set Profile Option 4.       Adding Responsibility to the users 5.       Defining Job & Position Structure 6.       Create Employee 7.       Define Buyers 8.       Define Financials Option 9.       Define Purchasing option 10.    Define Receiving Option 11.    Define Approval Hierarchies 12.    Define Approval Group & Assignments 13.    Controlling Purchasing Periods 14.    Define UOM’s & conversion 15.    Define Items 16.    Define Multi-org Acess

 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

  Select * from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787); Delete from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787); select * from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787); Delete from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787); Commit;

 delete from    mtl_reservations mr  where   lot_number is not null and     exists (             select  1             from    oe_order_lines_all oola             where oola.line_id = mr.demand_source_line_id             and     shipped_quantity = ordered_quantity         ) ;     Commit;

 OPM OSP batch Accounting Receipt Accounting At Receiving   At Delivery Batch Accounting – WIP Issue   WIP Completion

 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

  1.        Create Invoices           2 .        Go to Payments Manager  Navigation           Create Template or Submit a new request                Submit a Payment Process Request Enter Payment Attributes .   Submit then status show – Invoice Pending Review Click on the Start Action to review the selected invoices Select the invoices for payment then submit Status after review invoices calculating Special Amounts Status changed to Pending Proposed Payment Review then Formatting After Formatting – Formatted- Ready For Printing      Submit for Printing       Confirmed Payments