poxukpol.sql error - cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES"."ORG_ID") during upgrade
(Doc ID 2447197.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Purchasing - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2 version, Patch Application Issues
When attempting to run script poxukpol.sql during upgrade to 12.2 from 11i
the following error occurs.
ERROR
-----------------------
SQL> @poxukpol.sql PO 1000 4 32
DECLARE
*
ERROR at line 1:
ORA-20000: poxukpol.sql 120.6: ORA-20000:
po.plsql.PO_R12_CAT_UPG_EXISTING_DOCS.process_new_po_lines,100,ORA-20000:
po.plsql.PO_R12_CAT_UPG_EXISTING_DOCS.create_line_attributes,010,ORA-01400:
cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES"."ORG_ID")
ORA-06512: at line 183
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run script poxukpol.sql
2. See error in adworker log, or if run standalone, error in sqlplus session
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 |
Cause |
Solution |