Posts

Query to check Concurrent Status

 Query to check Concurrent Status SELECT distinct ft.user_concurrent_program_name "Conc Program Name", fr.REQUEST_ID "Request ID", fp.CONCURRENT_PROGRAM_ID, to_char(fr.REQUEST_DATE, 'dd-MON-yy hh24:mi:ss') "Submit at", to_char(fr.ACTUAL_START_DATE,'dd-MON-yy hh24:mi:ss') "Started at", to_char(fr.ACTUAL_COMPLETION_DATE,'dd-MON-yy hh24:mi:ss') "Completed at", decode(fr.PHASE_CODE,'C','Completed','I','Inactive','P','Pending','R','Running','NA') "Phasecode", decode(fr.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M', 'No Manager', 'Q','Standby', 'R','

Oracle Purschasing Setups

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

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

Query to Delete orphan transaction records from pending transaction form

  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 Orphan Reservation Transactions in oracle inventory

 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

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

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