My Oracle Support Banner

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

Last updated on JUNE 20, 2023

Applies to:

Oracle Fusion Assets Cloud Service - Version and later
Information in this document applies to any platform.


Asset Key KFF shows no value in OTBI

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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