nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OTBI: Fusion Cloud OTBI standard Report Customization

Donald

Summary

Error customization of standard OTBI report

Content

Hello There,

We are using Oracle Cloud Application 19C (11.13.19.07.0). In one of the standard OTBI reports, we would like to add 2 columns (Last_Update_Date and Last_Updated_By of the Receipts) from the available Subject Area in the report. The details are as below

1. Report Path: Shared Folders -> Financials -> Receivables -> Receivables Balances

2. Report Name: Reversed Receipts Report

I made a copy of the reports under Custom folder (same standard folder path as above). I included the 2 columns in both the Subject areas of the report. On execution it gives an error message.

Please find attach the snapshot of the actions I have performed for your reference:

1. Catalog files:

. a. Reversed Receipts Report.catalog

b. Report Components.catalog

c. Prompts.catalog

2. CustomerConnectExplanation-Print Screens OTBI.docx

My questions:

1. What are the steps you need to do when you have to customize a standard OTBI report?

2. How can I make this report work as per the requirement?

Appreciate your help. Look forward to hearing from you.

Thank you

Regards,

Donald

Version

Oracle Cloud Application 19C (11.13.19.07.0)

CustomerConnectExplanation-Print Screens OTBI.docx

Reversed Receipts Report.catalog

Report Components.catalog

Prompts.catalog

Find more posts tagged with

Reporting

Analysis

Accepted answers

All comments

Shifa Nazumudeen

Hi Eva,

What is the error message?

Thanks

Shifa

Eva Mirzoyan

hi @Shifa Nazumudeen

Error: View Display Error Error generating view. Error getting cursor in GenerateHead

Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 27045. [nQSError: 27045] Nonexistent column: "saw_21". (HY000)

Eva Mirzoyan

I managed to remove the error msg by playing with the column order, but the issue with displaying the random data is still there

Shifa Nazumudeen

Do you have a result column in your union analysis? If that's the case make sure that the order of your columns selected in that result column is correct. Otherwise, remove the result column and recreate that again. Hope it helps.

Best

Shifa