My Oracle Support Banner

Invoiced Amount Is Blank When Querying Purchase Order Distributions in the Buyer Work Center (BWC) Using a User-Defined View (Doc ID 2803409.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, HTML Orders

When querying  a user view in the Buyer Work Center at distribution level the field Invoice Amount shows no value when it should have a proper amount. The PO distributions do have invoices matched so there should be a value visible in this field.


Steps To Reproduce
-----------------------

1. Navigate to Buyer Work Center - Orders page

2. Select Distributions tab

3. Query distribution data using a new user-defined view or a pre-existing user-defined view

4. See that invoiced amount is 0 for PO distribution

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
Cause
Solution
References


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