EAP: Invoice Data Column is Blank When the APX2000 Report is Executed to Generate XLS (Excel) Output
Last updated on APRIL 13, 2017
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".
The invoice date column should have values.
The invoice date column is blank.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms