You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Supplier Balance Aging Report oracle standard report customization

in Payables, Payments & Cash Management

Summary: We are experiencing issues while exporting the report in excel format when there is huge volume of invoice data and output xml file size is exceeding 1gb. We are selecting Include Invoice details parameter as No still we are facing the same issue. When we checked the logic it appears that even though the include invoice details parameter is selected as No, in backend it is fetching all the invoice details and populating the summary details in the output.

To address this issue of output xml size exceeding 1 gb, when include invoice details parameter is set to No we have customized the the standard report as seeded report customization. We are modifying the main query to summarize the invoice details at supplier and supplier site level when Include Invoice Details parameter is set to No. With this the output xml size is reduced to a greater extent thereby allowing to export the report in excel.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!