My Oracle Support Banner

E1: 43: Issue When Using Query On P43214 - Header And QBE Filters don't Work (Doc ID 2546957.1)

Last updated on DECEMBER 04, 2019

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

P43214 / Receipts Reversal

When using a Query where POs with vouchered and closed lines, the program P43214 shows both lines, vouchered and closed when the option vouchered is turned on, when it should show only the vouchered line.
It also ignores other filters you try to set on header fields or QBE.

P43214 should display only the PV voucher information when Vouchered option is selected.

Steps:

F43121  2 receipt lines and 1 voucher
MT = 1 - 2 lines
MT = 2 - 1 line

Test 1 - NO Query defined
Click on Closed Lines button - 2 lines displayed - OV information displayed
Click on Vouchered button - 1 line displayed - PV information displayed

Test 2 - WITH Query defined for 5 purchase orders
Click on Closed Lines button - 2 lines displayed - OV information displayed
Click on Vouchered button - 2 lines displayed - OV information displayed
Search for a certain line number - not working

Conclusion:
WITH QUERY - the Vouchered options does not work.
The manual query does not work also when the QUERY is used.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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