My Oracle Support Banner

Defaulting Rule Not Working Based On Dependency Of Source Type (Doc ID 1383238.1)

Last updated on MAY 05, 2021

Applies to:

Oracle Order Management - Version and later
Information in this document applies to any platform.
Source Type
Promise Date
Schedule Ship Date
Drop Ship
Inventory Item
Defaulting Rule


On : 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


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.