Is There A Way To Default Print_price_ind From The Blkrqwzd?
(Doc ID 851083.1)
Last updated on MAY 02, 2024
Applies to:
Oracle Utilities Work and Asset Management - Version 1.7.15.3.2 and laterInformation 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.
Changes
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 |
| Changes |
| Cause |
| Solution |