My Oracle Support Banner

EAP: Invoice Data Column is Blank When the APX2000 Report is Executed to Generate XLS (Excel) Output (Doc ID 2251956.1)

Last updated on FEBRUARY 08, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Invoice Data column is blank when the APX2000 report is ran to generate XLS (excel) output. The column is present when the output is PDF file.

1) Navigate to Accounts Payable > Reports > Supplier > Payment History by Supplier.
2) Give parameters to run the Detail report fora Supplier - ensure that the Format is XLS.
3) Open the APX2000.xlsx.

Following message appears:

"Excel found unreadable content in 'APX2000.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes".

4) Click Yes. Following message appears:

Repairs to 'APX2000xlsx'
"Removed Records: Merge cells from /xl/worksheets/sheet1.xml part".

Expected result:
The invoice date column should have values.

Actual result:
The invoice date column is blank.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.