My Oracle Support Banner

Is There A Way To Default Print_price_ind From The Blkrqwzd? (Doc ID 851083.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.15.3.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

The SA_REQUISITION_ITEM table was altered as follows to default the PRINT_PRICE_IND to 'Y':

ALTER TABLE SA_REQUISITION_ITEM
MODIFY (PRINT_PRICE_IND DEFAULT 'Y');


When a Requisition is created from a Blanket Contract ( BLKRQWZD),the Wizard sets the indicator
explicitly to NULL ,which overrides the database default.

Steps to Reproduce:

Alter the SA_REQUISITION_ITEM table:

ALTER TABLE SA_REQUISITION_ITEM
MODIFY (PRINT_PRICE_IND DEFAULT 'Y');

Pull up an Active Blanket Contract
Select the 'Create Requisition from Blanket Contract' action
Go through the Wizard and fill in the required fields.
Pull up the requisition that is created. The Print_Price_Ind on the line item is Null.





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.