My Oracle Support Banner

Error 'Field Secondary Quantity must be entered' When Querying a PO With Dual UOM Created By PDOI in Purchase Order Form (Doc ID 2540648.1)

Last updated on JANUARY 19, 2024

Applies to:

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


When trying to query a PO with dual UOM item created by PDOI in Purchase Order form, get the error.
No error occurs when querying a PO with same dual UOM items created in PO core form manually.

This issue is occurring for all POs with dual UOM items created by PDOI.

Checked PO data created by PDOI and found out the cause of the issue.

SECONDARY_UOM/SECONDARY_QTY values are not populated in PO line table when creating a PO by PDOI.
However SECONDARY_UOM/SECONDARY_QTY values are populated in PO line table when creating a PO in core form manually so no error occurs.

Field secondary quantity must be entered.

The issue can be reproduced at will with the following steps:
1. Populate required information in the PO interface tables
2. Run the Import Purchase Order program and creates a PO successfully
3. Navigate to Purchasing responsibility: Purchase Orders> Purchase Orders
4. Query a PO created by PDOI, get the error


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.