Asset Key KFF Shows No Value In OTBI (Doc ID 2756189.1)

Last updated on MARCH 02, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Asset Key KFF shows no value in OTBI

EXPECTED BEHAVIOR
-----------------------
The values available in OTBI subject areas Key->Asset->Key-> Project and Key->Asset->Key->Pledge/Unpledged

STEPS
-----------------------
1. In the Setup and Maintenance work area, go to the Manage Key Flexfields task.
2. On the Manage Key Flexfields page, enter your search value in Key Flexfield Code.
3. On the Manage Key Flexfields page, enter your search value in Key Flexfield Code.
4. Click Manage Structure Instances.
5. Enter your search value in Structure Instance Code.
6. Click Edit to display the Edit Key Flexfield Structure Instance dialog box.
7. Select the BI Enabled option, then click OK.
8. For each flexfield segment instance, repeat steps 5 through 6.
9. Click Save.
10. Populate the BI Object Name for each of the segment labels:
  a.Query the Key Flexfield Code in the Manage Key Flexfields window.
  b.From the Actions menu, select Manage Segment Labels.
  c.Populate the BI Object Name for each segment label to be mapped.
  d.Before you deploy a flexfield, you must access the Chart of Accounts Instance and assign the newly created segment label to the appropriate segment in the Chart of Accounts.
  e.Click Deploy Flexfield.
  f. Click Save and Close.
11.Run Import Oracle Fusion Data Extensions for Transactional Business Intelligence
12.Check the values in OTBI

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.