What's new in Customer Journeys?

Connect and learn more! ×
BIP SQL to Retrieve Meaning Instead of Lookup Codes for Multi-Select FCLs — 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

BIP SQL to Retrieve Meaning Instead of Lookup Codes for Multi-Select FCLs

Received Response
13
Views
1
Comments
edited Jan 30, 2024 6:16PM in Reporting & Analytics for Sales 1 comment

Our organization has a requirement to depict the meaning of a multi-select FCL in a BIP report. The attribute currently pulls the lookup codes properly, but when applying SQL to retrieve the meaning from the FND_LOOKUP table, no results are returned in the column. Is this possible to accomplish via BIP or OTBI?

Please see below for SQL that was used to attempt to acquired the Meaning. This SQL works fine for existing single select FCLs we currently have.

SELECT f.meaning

    FROM  fnd_lookup_values f

    WHERE f.lookup_code = opty.EXTN_ATTRIBUTE_CHAR080 

        AND f.lookup_type = 'ABT_SOLUTIONS'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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