My Oracle Support Banner

AP Payment History By Supplier Report Ran To No Success (Doc ID 2452156.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Reporting

Payment History by Supplier report ran to No Success

APX2000 BI Publisher Report can only generate report for BANK_ACCOUNT_NUM (Table:PAYMENT_TBL) field length greater than 4. For ACH transactions field value is 'ACH' which is less than required length of 4 for report generation.

Error generating report output:  (235,2309)
PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute  Name:ProcessRe port  PCPC:86632
Statement:1712 Called
from:APX2000.MAIN.GBL.default.1900-01-01.Step02.OnExecute  Statement:29

The issue can be reproduced at will with the following steps:

1: Update the Account number value for USBNK/CHCK to 123

2: Create a Voucher and pay manually with USBNK/CHCK/MAN

3: Run the report: Accounts Payable >> Reports >> Supplier >> Payment History by Supplier

4: Process went to No Success and Error occurred in Message Log


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.