Oracle Purchasing - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2] Information in this document applies to any platform. Symptoms When attempting to cancel a PO line with backing requisition, without cancelling the requisition, error occurs. Error: INSERT_PACKET_CREATE_EVENT-020: ORA-01400: c...
Oracle Purchasing - Version 12.1.3 and later: PO / Requisition Approval: APP-PO-14142: WF_Error-000: ORA-0000 normal, successful completion
PO_LINE_LOCATIONS_ARCHIVE_ALL contains archived purchase order shipment information. Oracle Purchasing only archives shipments for the following documents: Standard purchase orders, Planned purchase orders, Planned purchase order releases and Blanket purchase order releases. When you modify a shipment, Oracl...
I was asked to find all "OPEN" requisitions in my company. I noticed in requisition header table PO_REQUISITION_HEADERS_ALL, the CLOSED_CODE column can be NULL, "OPEN" and "FINALLY CLOSED". What does NULL value for CLOSED_CODE mean? Is the requisition considered open if its CLOSED_CODE ...
In Process Incomplete Pre-Approved Rejected and you should note: When we finally close the requisition from Requisition Summary form the authorization_status of the requisition does not change. Instead it’s closed_code becomes ‘FINALLY CLOSED’. ...
I was asked to find all "OPEN" requisitions in my company. I noticed in requisition header table PO_REQUISITION_HEADERS_ALL, the CLOSED_CODE column can be NULL, "OPEN" and "FINALLY CLOSED". What does NULL value for CLOSED_CODE mean? Is the requisition considered open if its CLOSED_CODE...
2. Navigation = Purchase Orders > Purchase Orders, Enter a query, Press Ctl+F11 to execute, F4 to cancel is displayed at the bottom, Press Ctl+F11 - nothing happens 3. Autocreate a purchase order from a requisition, the Purchase Orders form open with the new PO detail, press Approve bu...
oracle.apps.inv.transaction.utilities.InvTrxException INV_TRX_MGR: Ex.. in INTORD.processPostUpdate..:oracle.apps. inv.transaction.utilities.InvTrxException INV_TRX_MGR: Ex.. in INTORD...querying PO_REQUISITION_LINES_ALL..:oracle.apps.inv.transaction. ...
1. Create requisition in iProcurement responsibility 2. Approve requisition 3. Create the Purchase order (PO) with the Autocreate function 4. Approve Purchase order 5. Supplier sends the PO Acknowledgement 6. Error is shown in transaction monitor ...
Oracle Purchasing - Version 12.1.3 and later Information in this document applies to any platform. Symptoms The Accrue on Receipt Flag is defaulting correctly in the Buyer Work Center and when creating a PO from a requisition through Autocreate. ...