G-Invoicing: GT&C Import Program Error PO_HEADERS_DRAFT_ALL.SEGMENT1 ORA-01400 When Using Manually Purchase Order Numbering
(Doc ID 2809005.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle Purchasing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
G-Invoicing: GT&C Import Program Error PO_HEADERS_DRAFT_ALL.SEGMENT1
Running the Intragovernmental Agreements (GT&C) Import Program and it completes with error.
The program log shows:
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at "APPS.PO_PDOI_GRP", line 383
ORA-06512: at line 1
The GT&C record is getting to the po_headers_interface table, but then not getting processed from there
The related error from fnd_log_messages is:
ORA-01400: cannot insert NULL into ("PO"."PO_HEADERS_DRAFT_ALL"."SEGMENT1") in Package po.plsql.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT. Procedure insert_po_headers_draft_all.0;SQLERRM = ORA-01400: cannot insert NULL into ("PO"."PO_HEADERS_DRAFT_ALL"."SEGMENT1")
Using the setup for manual numbering, not auto-numbering.
Setup -> Organizations -> Purchase Options
Document Numbering for Purchasing is set to Manual
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |