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.

Symptoms

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.

Steps:
-----------
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms