Are you able to see any difference for this attribute from other attributes in the DFF setup? if possible, can you share a screen shot for this DFF setup? Thanks.

It could be due to the volume of data. The user running the OTBI may have access to much more data compared to your user and that's why this issue? Can you add some filters and then ask the user to test? Also, to improve performance, you can add a hint as explained in below MOS note OTBI Performance Issue on Payables…

Can you copy the report and data model in my folders and try there? Also, I would suggest you to raise an Oracle SR in the meantime. Thanks.

can you share the sample XML as well? Thanks.

Upvoted. It will help enhancing user experience. Thanks.

Hi Mark, Is this in OTBI Usage Track subject area or FDI? If it is OTBI, then I don;t think you can hide the attribute from a user having access to create analysis from this SA. Hi @Raghavendra Raghunath-Oracle , Hope you are doing well. Can you please advise? Thanks.

There is no way to get this information unfortunately. If you are having only financials , you can try looking on GL_FRC_REPORTS_B table but again it won't give you exactly what you are looking for. GL_FRC_REPORTS_B and Custom Folder and Report List — Cloud Customer Connect Thanks.

Hi, For a standalone HCM application, no need to run - Create Rules XML File for BI Extender Automation job. Only the second ESS job should be run. Have you tried running that after checking HCM parameter checkbox? Thanks.

Can you please share some more details on the subject area name, DFF name , attribute name and type of value set attached? Is the attached value set of type table? Thanks.

You should see two attributes one with Description. Try to use the description column. Thanks.

Isn't this for UK Statutory plans? Hi @BFell , Looks like these details are calculated in UI and are not stored in DB to be auto reported: Absence OTBI or query to fetch qualification plan use details with entitlements — Cloud Customer Connect Thanks.

This forum is dedicated to Oracle analytics. Please post your query on customer connect for better response: Human Capital Management — Cloud Customer Connect Thanks.

In which product what you are trying to do? What is the exact requirement? Thanks.

Did you check the query on the link? It shows links to RA_CUSTOMER_TRX_LINES_ALL/ra_cust_trx_types_all tables which are finance tables. Thanks.

Check if below helps: Link between DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERS — Cloud Customer Connect

So, basically you are looking for a customer PO number and the invoice against that? Can you share your complete requirement? Thanks.

Is Customer_po_number same as Invoice_num ? If yes, you can create two data sets - one with SCM data source and one with FIN data source and join them using the mentioned columns. Thanks.

Hi Vrinda, The issue lies in the underlined: The 'E' is end for loop which is ending before your newly added column. Please cut the 'E' part and paste it under Type, next to Transaction_type tag and it should work. Thanks.

Hi, Were you able to achieve this requirement? If no, can you try below approach: RTF file Configuration for Eliminating Null Value Column — Oracle Analytics Thanks.

There is no straightforward way of achieving it. However, you can try below approach: Create an RTF template with 4 different tables. First table will have only the 3 columns which are always displayed. Second table shall have 3 mandatory + one optional column and so on. Create 4 temporary variable at RTF level. Initialize…