E1: 04: Cannot View Records in P0411Z1 (A/P Batch Voucher Entry) if EDSP (Successfully Processed) Value is Blank in F0411Z1 (Voucher Transactions - Batch Upload) (Doc ID 2932659.1)

Last updated on MARCH 03, 2023

Applies to:

Symptoms

When performing an inquiry on batch number in the P0411Z1 (A/P Batch Voucher Entry), no records are being retrieved if the EDSP (EDI - Successfully Processed) is set to blank in the F0411Z1 (Voucher Transactions - Batch Upload).

STEPS
-----------------------

1. Create data in the F0411Z1 and F0911Z1 tables. This can be done with the P0411Z1 (A/P Batch Voucher Entry) or with a 3rd party software.
2. Set the EDSP (Successfully Processed) flag to blank. This would have to be done by a db utility tool or with the 3rd party software, as the EDSP defaults to a 0 if entered by the P0411Z1.
3. Go into the P0411Z1 and attempt to find the records by inputting the batch number. No data is found.

Cause

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