OrderLine-PricingDate对应之DefaultingRule-RelatedRecord中Source如何增加Order Header.Request Date

问题：Defaulting Rule中针对于<Order Management -> Order Line -> Pricing Date>，Source Type=Related Record，Default Source/Value显示无值

需求：修改Order Line -> Pricing Date默认值来源于Header中的Request Date。

Order Management -> Order Line -> Pricing Date 值希望像<Request Date>一样能default来源值为<Order Header.Request Date>

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=526331525297391&id=283988.1&_adf.ctrl-state=goz1zsepu_57

 

Cannot Setup Defaulting Rule To Default Pricing Date from Sales Order Header To Sales Order Line (文档 ID 283988.1)

转到底部

---

APPLIES TO: 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 : Foreign Key Column : PRICING_DATE Referenced Key Column : REQUEST_DATE 4. Save the changes. 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 : Foreign Key Column : PRICING_DATE Referenced Key Column : REQUEST_DATE 4. Save the changes. After doing the above setups,  You will be able to set the defaulting Rule for pricing date on the line when you select source Type as "Related Record"