BI Publisher (MOSC)

MOSC Banner

Performance Issue with BI Publisher report

edited Mar 5, 2015 10:01AM in BI Publisher (MOSC) 3 commentsAnswered

Hi,

I am having performance issue with Vendor liability Aging (APX1408) BI Publisher report. We are using the report as delivered, the process is taking 1:30 hours to process 80k rows.

We enabled the peoplecode trace and found that the process is taking most of the time in the below code:

2155     05.08.41     0.000000               23:    &bRet = &oFOPocessor.generateOutput(&sXSLTemplateFile, &sXMLDataFile, &sXliffFile, &sOutputFile, &iOutputFormat);

2156     06.42.57  5655.876000             24:    If Not &bRet Then

I also enabled the xdo debug trace and found that the below message repeatedly in xdo log file.

[022515_071426002][oracle.xdo.template.fo.elements.FormattingEngine][STATEMENT] Continue rendering page [1]


Any inputs on the root cause of this issue ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center