My Oracle Support Banner

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 NOVEMBER 03, 2023

Applies to:

Oracle Purchasing - Version 12.2.8 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.


12.1.3 environment

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)



  1. Navigate to PO Entry form and create a new PO
  2. Query the PO in sql*plus and notice CLM_DOCUMENT_NUMBER in TABLE PO_HEADERS_ALL for the new PO is null


12.2.x environment

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.