Receivables - EBS (MOSC)

MOSC Banner

AR receipt DEFAULT_WHERE not fired

Hello,

i'm trying to personalize AR receipt, so once opening the AR receipt the query will bring only (AR_CASH_RECEIPTS_V) receipts with the specific where condition.

1-Create condition at trigger event: WHEN-NEW-FORM-INSTANCE

2-Create property action at object type: Block

target object: RGW_FOLDER

property name: DEFAULT_WHERE

Value: XXXXX (search criteria)

3-Create builin action : DO_KEY

:EXECUTE_QUERY

close an opened again the receipt =⇒ i'm getting all data, means the clause where not fired

Please advice how to proceed

Kind Regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center