Oracle Order Management - Version 11.5.9 to 12.2.4Cloud [Release 11.5 to 12.2Cloud] Information in this document applies to any platform.
SYMPTOMS
x
CHANGES
x
CAUSE
x
SOLUTION
In order the Pricing Date of Header should come to the line following 2 setups needs to be done in Application Developer
Setup 1 -----------
1. Log to the in as AK Developer Responsibility and go to Objects Workbench. Query Order Line in the Objects window and click on the Foreign Keys button.
2. In the Foreign Keys block create a new record with the following values
Foreign Key : OE_ORDER_LINE_PRICING_DATE Parent Object : Request Date Referenced Key : REQUEST_DATE_UK Relationship : Give some meaningful value like "Pricing Date To Order Line"
3. Navigate to the Foregin Key Columns window and create a record with the following values :
Setup :2 --------------- 1. Log in as AK Developer Responsibility and go to Objects Workbench. Query Order Header in the Objects window and click on the Foreign Keys button.
2. In the Foreign Keys block create a new record with the following values
Foreign Key : OE_ORDER_PRICING_DATE_FK Parent Object : Request Date Referenced Key : REQUEST_DATE_UK Descrption : Some meaningful value like Pricing Date To Order Header
3. Navigate to the Foregin Key Columns window and create a record with the following values :