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

Create Data Model for Retrieving Custom FCL Field Values for Opportunity History

in Sales 2 comments

Hello,
I’m working on building a data model/SQL query in Oracle Sales Cloud OTBI to retrieve historical records for Opportunities, and I’ve run into a question regarding custom fields.

According to the Customization Report, the custom Opportunity fields (FCL fields) appear in MOO_OPTY in the expected columns.
However, when I query MOO_OPTY_ (the underscore table), as recommended in previous threads in this community, several of those custom fields are returning NULL when I use the same column names.

My questions are:

  1. Do the custom field columns in MOO_OPTY_ map 1:1 to the fields in MOO_OPTY
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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