Receivables - EBS (MOSC)

MOSC Banner

Join between RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL

in Receivables - EBS (MOSC) 2 commentsAnswered ✓

When we join RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL do we join only by cust_Trx_type_id or the right way is to join by cust_trx_type_id and org_id?


For one the clients, Im seeing same cust_trx_type_id across different org_ids.

Im seeing some strange data in the second client database - for a given cust_trx_type_id the org_id is different in RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL. Can we have cust_trx_type_id in RA_CUSTOMER_TRX_ALL that is associated to different org_id in RA_CUST_TRX_TYPES_ALL? As per my understanding. this should not be possible based on the EBS org_id security design. Pls confirm.

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