Field CLM_DOCUMENT_NUMBER In PO_HEADERS_ALL Table is Null For Purchase Orders In 12.1.3 And Populated In 12.2.x
(Doc ID 2719627.1)
Last updated on MARCH 16, 2022
Applies to:Oracle Purchasing - Version 12.2.8 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
Customer is facing issues with CLM_DOCUMENT_NUMBER in PO_HEADERS_ALL is blank for newly created Purchase Orders.
(CLM=Contract Lifecycle Management EBS Application)
STEPS TO REPRODUCE
- Navigate to PO Entry form and create a new PO
- Query the PO in sql*plus and notice CLM_DOCUMENT_NUMBER in TABLE PO_HEADERS_ALL for the new PO is null
Starting 12.2.9 release, as per standard functionality for instances 12.2.9 and above, the CLM_DOCUMENT_NUMBER field has the same value as SEGMENT1 and is populated automatically with the PO number, whether it is a non-CLM environment or CLM enabled environment.
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