Enterprise Command Center Framework - EBS (MOSC)

MOSC Banner

How to extend ar-trx to show additional fields?

edited Aug 15, 2022 7:12PM in Enterprise Command Center Framework - EBS (MOSC) 1 commentAnswered

Example: Need to show hz_parties.party_type for bill_to_customer_id to ar-trx dataset.

I am following steps in Advanced Extensibility> Extend an Existing Data Set (Oracle E-Business Suite Extending Enterprise Command Centers)

What I have done:

  • backed up existing application
  • created xxx_ari_ecc_trx_v view based on ari_ecc_trx_v
  • updated xxx_ari_ecc_trx_v to show hz_parties.party_type

Not sure about the next step. Do I,

  • Create XXX_AR_ECC_UTIL_PVT (copy of AR_ECC_UTIL_PVT) plsql package and body, replace ari_ecc_trx_v with xxx_ari_ecc_trx_v and display party_type in l_ar_installments and li_ar_installments in get_ecc_data_load_info procedure

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