Receivables - EBS (MOSC)

MOSC Banner

AR Invoice print for New Invoice performance in R12.1.3

edited Jul 1, 2017 3:10AM in Receivables - EBS (MOSC) 13 commentsAnswered

Hi All,

I have below query which is using in AR Invoice print for New Invoice print(header select query).

This query is taking long time to complete for US org_id only, but not for other OU's

SELECT a.customer_trx_id CUSTOMER_TRX_ID,
       a.trx_number      TRX_NUMBER
FROM   ar_adjustments COM_ADJ,
       ar_payment_schedules P,
       ra_cust_trx_line_gl_dist REC,
       ra_customer_trx A,
       hz_cust_accounts B,
       ra_terms T,
       ra_terms_lines TL,
       ra_cust_trx_types TYPES,
       ar_lookups L_TYPES,
       hz_parties PARTY,
       hz_cust_acct_sites A_BILL

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