My Oracle Support Banner

How to get Payment Term to not redefault (Doc ID 579027.1)

Last updated on JANUARY 23, 2023

Applies to:

Oracle Order Management - Version 11.5.10.0 to 12.2.7 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Disabled the dependency between ship_to_org and payment_term using
the oe_dependencies_extn api. However, even after disableing the dependency, upon changing ship_to_org, payment term is getting redefaulted.



1. Make a backup of the existing file OE_Dependencies_Extn (OEXEDEPB.pls).
2. Modify the package OE_Dependencies_Extn (OEXEDEPB.pls).

The details about modifying this package are given in the file OEXEDEPB.pls.
Below are the basic steps needed to resolve this issue.

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_PAYMENT_TERM;
x_extn_dep_tbl(l_index).enabled_flag := 'N';
l_index := l_index + 1;
end if;

3.Load the new package into the data base and compile

4.Retest issue

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.