Purchasing Options LOV For Internal Order Type - Patch To Fix Issue Of Note 451893.1 (Doc ID 1485365.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Internal Requisition Order Type can not be chosen when define Purchasing Options. Internal Requisition Order Type LOV will not show all the expected values.

Per <Note 451893.1> , this happens due to irregular population of the po_required_flag and agreement_required_flag in oe_transaction_types (TRANSACTION TYPES).
When the form is saved without checking off the boxes.. the associated column value was saving as NULL instead of N.

EXPECTED BEHAVIOR
-----------------------
Expect to see all valid IR Order types

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Purchasing Responsibility > Setup > Organizations > Purchasing Options, click Internal Requisition Order Type LOV, it will not show all expected transactions types.

2. Check the Transaction Type setup via OM Responsibility > Setup > Transaction Types, query one of the affected transaction type , you will find the following:
Agreement Required = unchecked
Purchase Order Required = unchecked
Enforce List Price = unchecked

From back end, it will be null instead of "N".

Changes

Cause

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