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 11.13.20.07.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |