My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version, Setup Issues

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

EXPECTED BEHAVIOR
-----------------------
Expect DFF update does not change the value in fnd_lookup_values table.

STEPS
-----------------------
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:
SELECT
  LOOKUP_TYPE, LANGUAGE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG,
  START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
  LAST_UPDATE_DATE, SOURCE_LANG
FROM APPLSYS.FND_LOOKUP_VALUES
WHERE 1=1
and lookup_code = 'XXX'
and enabled_flag = 'Y'
and lookup_type = 'SHIP_METHOD'
and language = 'US';
Description value was updated from 'YYY' to 'XXX'

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.