Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Performance issue in the query for getting the XAL level details of payroll Journals

Received Response
1
Views
1
Comments
User_FW2BG
User_FW2BG Rank 1 - Community Starter
in Oracle Analytics Publisher
NON_IC_Accounting_HUB.zip

Hi,

We are building the oracle Bi publisher report to get the details of Payroll journals such as GCC details, batch details, debit credit details, subledger level details.


when we are running this query is turning into timeout/ data size issue.


can someone is looking into this query in help us in tuning it.


I'm attaching this query here.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_FW2BG

    Welcome to BI Publisher Community.

    Below is my suggestions,Refer below MOS doc -

    How to Increase SQL Query Timeout for BI Publisher for Scheduled Reports (Doc ID 2797848.1)

    Better to change your logic to DB level by creating an procedure or functions and then call using triggers to minimize the time of running query If you are unable to tune the SQL Query.

    Regards,

    Arjun