Global DFF not showing in Receivables - Transactions Real Time

John Wigston

I have created a Global DFF against flexfield RA_CUSTOMER_TRX. The BI Enabled checkbox is ticked.

I have populated transactions with data in the flexfield and have run the following ESS jobs:

- Create Rules XML File for BI Extender Automation

- Import Oracle Fusion Data Extensions for Transactional Business Intelligence

When I navigate to the OTBI subject Area "Receivables - Transactions Real Time" I cannot locate the created field.

The documentation suggests this should be in General Information > Transaction Details.

It appears I can see Context specific flexfields, but not this Global one.

Is anyone aware of differences between using GLOBAL and CONTEXT specific DFFs in OTBI?

RanaAshutosh-Oracle

Descriptive flexfields have two different types of segments, global and context-sensitive, that you can decide to use in a descriptive flexfield structure.

A global segment is a segment that always appears in the descriptive flexfield pop-up window, regardless of context (any other information in your form). A context-sensitive segment is a segment that may or may not appear depending upon what other information is present in your form.

If you have context-sensitive segments, your descriptive flexfield needs context information (a context value) to determine which context-sensitive segments to show. A descriptive flexfield can get context information from either a field somewhere on the form, or from a special field (a context field) inside the descriptive flexfield pop-up window. If the descriptive flexfield derives the context information from a form field (either displayed or hidden from users), that field is called a reference field for the descriptive flexfield.

Please Refer : https://docs.oracle.com/cd/A60725_05/html/comnls/us/fnd/ogendff.htm

How to implement context sensitive segments in Descriptive Flexfield (DFF) ? (Doc ID 1943211.1)

Menno_NL

@John Wigston

Have you been able to resolve this issue? We are facing the same problem for both global and context sensitive DFFs. Do you actually see your context sensitive DFFs appear in the Receivables - Transactions Real Time subject area?

Shashidhar AM

I have same issue… i cannot see the AR Transaction header Global DFFs in 'Receivables - Transactions Real Time'

is there is any solution? please let me know.

Menno_NL

https://community.oracle.com/products/oracleanalytics/discussion/comment/61261#Comment_61261

I have seen it working correctly in 2 Fusion instances but could not get it to work on a different instance.

Steps taken in the working instances:

1. Create your (global) DFFs on RA_CUSTOMER_TRX and make sure that you enable the BI Enabled checkbox for each DFF.
2. Deploy the flexfield.
3. Run the scheduled process ‘Import Oracle Fusion Data Extensions for Transactional Business Intelligence’ with parameters ‘ERP’ and ‘Financial Reporting’ checked.
4. In the Receivables – Transactions Real Time subject area, you should now be able to find the DFF segments under their assigned names in the folder: Transaction Details > General Information.

Shashidhar AM

Hi Menno_NL,

i did all 4 steps as you mentioned but the global DFFs are not avaibale still in Prod under Transaction Details > General Information.

did it dint work for you in some instance ?

Menno_NL

Hi @Shashidhar AM,

Yes, you are looking in the right place. The flexfield should appear there with the segment names that you have chosen. For me it is working on 2 instances and not working on 1 other instance, which Oracle support has been investigating for a long time.

One thing you can try is click on the refresh-icon on the very right side of 'Subjects Areas' and then choose Reload Service Metadata.

Shashidhar AM

I did  'Subjects Areas' and then choose Reload Service Metadata. still no luck ….

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61273#Comment_61273

Have you checked the log file for Import Oracle Fusion Data Extensions for Transactional Business Intelligence? Does it show any errors or warnings?

Can you quickly confirm if you can see the DFF in Revenue Real time?

Thanks.

Shashidhar AM

Yes, the proce3ss 'Import Oracle Fusion Data Extensions for Transactional Business Intelligence' went to Warning. but log file is big and do not show any clue.

and can you please be more specific regarding subject area 'Revenue Real time'. i dint find any like that..

Shashidhar AM

I was able to resolve this issue finally and now Global DFF are coming in Analysis 🙂. Please check below.

Before running the "Import Oracle Fusion Data Extensions for Transactional Business Intelligence " make sure all the DFFs/EFFs are deployed.
Run the SQL in a data model; if any DFF or EFF are coming in this SQL then you will have to deploye it.

select flexfield_type, descriptive_flexfield_code, bi_enabled_flag, deployment_date, deployment_status, SEED_DATA_SOURCE from FND_DF_FLEXFIELDS_B where deployment_status != 'DEPLOYED' and deployment_status = 'EDITED'
order by flexfield_type desc, descriptive_flexfield_code;

Reference:
https://support.oracle.com/support/?anchorId=&kmContentId=2729746&page=sptemplate&sptemplate=km-article