Technology Stack - EBS (MOSC)

MOSC Banner

Form personalization(default_where) not working in Oracle Receivables Account Details screen

edited Aug 20, 2021 11:02AM in Technology Stack - EBS (MOSC) 1 commentAnswered

I want to restrict the result to a specific Transaction type , which(transaction type) is hidden in the form .

For that i use DEFAULT_WHERE IN TARGET OBJECT CQIT_PS . 

below is the query .

TYPE_NAME in (SELECT NAME FROM RA_CUST_TRX_TYPES_ALL R WHERE R.ATTRIBUTE2 = 'xxxxxxxx')

Please help . It is not working .

Tagged:

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