E1: 04: Supplier Ledger Inquiry: QBE Query - Purchase Order Number (Doc ID 1957302.1)

Last updated on MAY 31, 2016

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

If a user attempts to do a QBE query on purchase order number, the actual purchase order number is stored in the Accounts Payable Table (F0411.RPPO) as an eight position number. Zeros may pad the number. A user must be entered the purchase order as an eight position number in order for the application to fetch the record. For example:

Purchase Order 1873 is stored in the Accounts Payable Table (F0411) field RPPO as 00001873. In order to fetch the record, the user has to be certain that the purchase order number be padded with zeros. If the purchase order is entered as 1873, there is no message and no record is returned.

A user should be able to enter the purchase order number without padding the number with zero so that it is exactly 8 positions long.

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