Fixed Assets - Asset Transactions Real Time

Md Mujtaba Alam

In fixed Asset Subject Area (Fixed Assets - Asset Transactions Real Time), When I am pulling the data from two folders , it is showing the error as

The specified criteria didn't result in any data.

Attaching the screenshot for reference.

Kindly help me to resolve this issue.

Regards,

Mujtaba

Fixed Asset Subject Area Issue.jpg

Shankar-Oracle

There are no measure columns selected as per the attached screenshot.

Could you please add any one of the measure columns, and see if you get the results or not?

Md Mujtaba Alam

Hi @Shankar-Oracle ,

I have tried with that also but still I am not getting the data.

Screenshot 2024-11-04 115112.png

Shankar-Oracle

Please get the log generated for this analysis as below and see if you finda "1=2" without quotations in the log.

Please click on "Advanced" tab of the respective OTBI analysis and copy the SQL query there.
Please go through Support Document: 1469168.1 - Fusion Applications: How to set up and access the nqquery.log to troubleshoot a single OTBI or OBIA query (Doc ID 1469168.1).
For the step 6, please use the SQL copied above. For step 7 set the log level "Oracle BI Server Logging Level" to 7. Once you are done, please share the log to this SR.

Md Mujtaba Alam

Hi @Shankar-Oracle ,

I have generated the log file but not able to find 1=2 condition.

Could you help me where I can get it?

Attaching the logfile.

Regards,

Mujtaba

OTBI Log File.txt

Shankar-Oracle

Please go ahead and create an SR for this issue. Please mention this CCC URL in the SR and inform that this was already reviewed by Appstech-BI analyst. Please share the SR number (in this forum), once you create the same

Nalsoft Pvt Ltd

Hi @Md Mujtaba Alam

We are facing the same issue, like

In fixed Asset Subject Area (Fixed Assets - Asset Transactions Real Time), When I am pulling the data from two folders , it is showing the error as
The specified criteria didn't result in any data.

Could you please let us know how to resolve this issue?

Riyaz Ali-Oracle

@Nalsoft Pvt Ltd

Check the below KM note:

Fusion OTBI - Fixed Assets - Assets Transactions Real Time Subject Area is Not Returning Data (Doc ID 2352443.1)

Review the below doc and make sure to have proper Job/Duty roles assigned to the user:

https://docs.oracle.com/en/cloud/saas/financials/24b/faofb/Fixed-Assets--Asset-Transactions-Real-Time-SA-11.html

Job Roles:

Asset Accountant
Asset Accounting Manager

Duty Roles:

Fixed Asset Transaction Analysis Duty