FND_LOOKUP_VALUES.DESCRIPTION Changes Where Lookup Type = 'SHIP_METHOD'
(Doc ID 2708170.1)
Last updated on SEPTEMBER 16, 2020
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Setup Issues
When trying to update "Additional Carrier Services Information" DFF, the Applsys.fnd_lookup_values.Description is changed to the value present in SHIP METHOD field.
Expect DFF update does not change the value in fnd_lookup_values table.
The issue can be reproduced at will with the following steps:
1. Order Management Super User responsibility
2. Shipping -> Set up -> Freight Carriers, Cost Types ->Freight Carriers
3. Search for Name ABC and find Ship Method XXX.
4. Open "Additional Carrier Services Information" DFF. Change attribute2 value and save.
5. Run below query:
LOOKUP_TYPE, LANGUAGE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG,
START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
and lookup_code = 'XXX'
and enabled_flag = 'Y'
and lookup_type = 'SHIP_METHOD'
and language = 'US';
Description value was updated from 'YYY' to 'XXX'
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