Reporting On Dynamic Choice Fields And Object Trigger Issue (Doc ID 1989812.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Fusion CRM Application Composer - Version 11.1.8.0.0 and later
Oracle Fusion CRM Application Composer Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

Issue:
Have several dynamic choice fields within a new custom object; where our customer would like to have these fields made to be displayed within a report.
We created several text fields; and then used an object trigger to copy the value from the field (Before Insert in Database (see screen shot for code used)).
When the new record is created and the dynamic choice field populated before insert into the database then the data shows fine within the report.

But if the field was not populated on creation of the record and updated after the fact then the data is not been updated into the reportable (text) field
and then the report shows no data within the report; where data is seen within the UI record.
 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms