Access Values in mapping set for reporting
I'm working on a BI publisher report that is a crosswalk from a legacy system to their new values in Oracle Fusion. The report is around deliver-to locations and in Fusion I can see the mapping for each Deliver-To location followed by a manually entered field that is a concatenation of multiple fields. The value set attached to the mapping did not contain the values and the mapping underneath is CompanyName USD: Mappings and the entries within are Deliver-To Location, CompanyName USD (Field I'm trying to find and use in BI Publisher), Effective Start Date, Effective End Date.
Are these manually entered fields available in tables to be used in a BI Publisher data model and report? If so, what would be best practice in searching for them?
Tagged:
1