My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2024

Applies to:

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


Symptoms

On : 11.5.10.2 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
Expect that after updating the Default Dependency package that the defaulting would work for Source Type.

STEPS
-----------------------
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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.