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

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.7.15.3.2
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

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