Order Management - EBS (MOSC)

MOSC Banner

Freight terms are changed when ship to address is updated in Sales Order header

edited Jan 9, 2020 10:45AM in Order Management - EBS (MOSC) 3 commentsAnswered ✓

Hello,

We need Freight Terms to be defaulted as per Oracle seeded rule during order creation. But we need the freight terms not to be modified if user changes ship-to or bill-to addreses after order has been created (saved for first time). So we added in package OE_Dependencies_Extn (OEXEDEPB.pls) follow code:

oe_debug_pub.add('Enter OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);

l_index := 1;

IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

x_extn_dep_tbl(l_index).source_attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;

x_extn_dep_tbl(l_index).dependent_attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center