r12.2

[Sri]

Hi erman,

we have a custom report which used to complete sometimes and throwing error sometimes.output file size 40mb and excel is 90MB.we have raised an SEV-1 SR and  it was going for almost 15days but not permanently fixed.

we have enabled the scalable feature at template and data definition level as recommended by oracle.After doing that it has completed once and again started erroring out in next runs.

Below is the error and we currenly have 3GB heap space and have 3 processes defined for OPP,I suspect we have to reduce the size to 2 GB but need your expert suggestion

ERROR: oracle.apps.xdo.XDOException: GC overhead limit exceeded

Thanks,
sri

[ErmanArslansOracleBlog]

You will need to apply a workaround by simplfying your layout and gathering the data in peaces.
This is what I can say to you.. Because these things in EBS have limits.
For big sized reports, Oracle suggests installating a seperated 64 bit XML Publisher envirponment.
(one should use BI Publisher Enterprise 11g product is 64-bit as it will use the 64-bit JVM which is exponentially larger.)

what about setting Xmx to  "4000m? "
EBS 12.2 concurrent tier is 32 bit, but let's try..
Can you try?  I m wondering if it will permit you..

[Sri]

Thanks Erman,

Any reference doc for installing BI Publisher Enterprise 11g product is 64-bit in EBS.
I will try setting it to Xmx to  "4000m" and let you know

[ErmanArslansOracleBlog]

http://www.oracle.com/technetwork/middleware/bi-foundation/documentation/bi-pub-096318.html