OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real Time

Rich Merkel

Summary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and dimension for a particular month. Filtered for posting status code = P, accounting period (Jul-25), JE source = projects, accounts 4-9 (P&L), calendar set (RU Calendar [main calendar] and year 2025. Fund type is one of our GL dimension (secondary balancing segment)

When adding accounting class code, performance goes from about 5 seconds to over 5 minutes.

How can good performance be achieved from this subject area after adding accounting class code? OTBI analysis does not perform well after adding this, is there any other indexed field I can add to increase performance?

Balance formula is: IFNULL("Journals"."Journal Line Accounted Amount DR",0)-IFNULL("Journals"."Journal Line Accounted Amount CR",0)

I've tried adding in batch, and other indexed fields (from attached excel), and nothing performs as expected.

How to get SL JE data by accounting class code that performs similiar to same without accounting class code?

How to achieve reporting on secondary balancing segment/accounting class code/accounting period/P&L natural accounts (begins with 4;5;6;7;8;9)/debits and credits/accounting class code/actual and posted using OTBI?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

R13_23C_FIN_OTBI_database_mapping_with ViewObjects.xlsx

24C

Code Snippet (add any code snippets that support your topic, if applicable):

John Hung-Oracle

Hi Rich, To better serve you, I have coped your post to the Reporting and Analytics for ERP forum to get more eyes on it. Thank you.

Copied to: https://community.oracle.com/customerconnect/discussion/822644/otbi-bad-performance-after-adding-accounting-class-code-subledger-accounting-journals-real-time

Rich Merkel

Thanks so much, it is greatly appreciated as I'm still struggling with performance especially from projects subledger and specifically looking RAW_COST, RAW_COST_CLEARING, BURDEN_COST, BURDEN_COST_CLEARING accounting classes.