Sales Order Number Number Missing on Contract Header for Contracts Related to an Order
Last updated on MARCH 08, 2017
Applies to:Oracle Service Contracts - Version 220.127.116.11 and later
Information in this document applies to any platform.
In Service Contracts Authoring, find that the Sales Order number (SO) is not populated in Order field for a contract apparently created from Order Management
The contract appears to be created through one order but the Order filed is blank in contract header. Sales Order number not populated.
How can this be entered?
The following SQL seems to point to a relationship the SO.
FROM okx_order_headers_v Hdr,
WHERE Hdr.Id1 = Rel.Object1_Id1
AND Rel.Jtot_Object1_Code = 'OKX_ORDERHEAD'
AND Rel.chr_id = k_hdr.id
AND k_hdr.contract_number = '&contract_number';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms