Pages

Transaction Date Cannot be Future Date (Stuck in Transaction Open Interface)

Step 1: Query the record which needs to be updated

SELECT 
TRANSACTION_DATE,  MTI.*  
FROM  MTL_TRANSACTIONS_INTERFACE MTI
WHERE 
TRANSACTION_HEADER_ID='';     ---(From Transaction Open Interface)

How to Create Display Only DFF (Using Special Value Set)

 Step 1: Value Set Creation

Validation Type : Special



Click on 'Edit Information'

Event : Edit
Function : FND SQL "BEGIN NULL; END;"

Event : Validate
Function : FND SQL "BEGIN NULL; END;"