Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
FND_LOOKUP_VALUES on Cloud? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FND_LOOKUP_VALUES on Cloud?

Received Response
39
Views
1
Comments
edited Apr 21, 2020 3:33PM in Applications Security 1 comment

Content

Hi,

On EBS / R12 I used to find it useful when writing SQL to get at the system meanings behind various fields on the database.

For example, in Payables, I could look at AP_INVOICE_DISTRIBUTIONS_ALL.PA_ADDITION_FLAG and that might contain values like 'A' or 'Z' etc...

Rather than doing a long DECODE statement, I could look up the values in the FND_LOOKUP_VALUES table - e.g.

SELECT meaning, lookup_code
FROM fnd_lookup_values
WHERE lookup_type = 'PA_ADDITION_FLAG'

In Fusion I am finding that often that is no longer an option - for example, there is no longer a PA_ADDITION_FLAG Lookup Type - instead, the meanings have to be found via a Support Note - e.g.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!