Defaulting Rule Not Working Based On Dependency Of Source Type
Last updated on MARCH 09, 2017
Applies to:Oracle Order Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
Schedule Ship Date
On : 220.127.116.11 version, Transaction Entry
Defaulting Rule not working based on dependency of Source Type
We wanted to default schedule ship date based on lead time of the inventory item when item is drop shipped.
In our business, the item is both internally and externally sourced.
When the sales order line is drop shipped, user modifies the source type of the sales order line to external.
At this point, user wants the schedule ship date to be defaulted based on the lead time of item.
To achieve this functionality we create a defaulting condition which evaluates to TRUE when source type is external.
Then we assigned the defaulting condition to schedule ship date and called a PL/SQL package to return schedule ship date based on the item lead time.
We then modified the extension package "OE_Dependencies_Extn" to create dependency of schedule ship date on inventory item, ship from org and source type.
The defaulting rule gets triggered when we modify item or ship from warehouse and returns the schedule ship date based on item lead time if source type is external,
but the defaulting rule does not triggers when user changes the source type from internal to external.
Expect that after updating the Default Dependency package that the defaulting would work for Source Type.
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Update the OE_Dependencies_Extn" to create dependency of schedule ship date on inventory item, ship from org and source type.
3. Defaulting is not working as expected
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