EAP: Invoice Data Column is Blank When the APX2000 Report is Executed to Generate XLS (Excel) Output
(Doc ID 2251956.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!