EBS 122 Receibavles

Question

Team

Our internal EBS team mentioned that table ra_customer_trx_all and  ra_customer_trx_lines_all is where the AR module tracks the items. Does any one on the forum have background to whether these details are extracted to BI reporting in the BIAPPS as part of the AR ?

regards

ra_customer_trx_lines_all

Charles M · Answer

Certainly possible. We did quite a few customizations during our implementation, mostly Category 1, including many attribute columns. I was a technical-hand for those tasks (we had some functional folks who helped with the analysis part), so I cannot say which columns you may need. Maybe others here can speak more towards that end of it.

If you do end up going the customization route, you can use this as a guide: https://docs.oracle.com/cd/E63231_01/doc/BIAET/GUID-C9E7D7FD-3C17-4247-962B-56DD9E8A2B6B.htm#BIASA24484. -- 11.1.1.10.1 version

Regards,

Charles

3439799 · Answer

Thanks Charles. The  ra_customer_trx_all is the one thats feeding the Aging_invoice and Aging_Invoce_Ent facts. However on EBS ra_customer_trx_lines_all is bahaving like an extension table (flex field) with columns like attrib 1 to attrib 15. may be these need to be Coded as a customization?

Charles M · Answer

Hi,

Which version of OBIA are you using?

You could take a look at OBIA 11g: BI Applications 11.1.1.10.x Data Lineage Guides (Doc ID 2058613.1), specifically: Financial Analytics EBS2.xlsx (contains 12.2.x tables). I can see that ra_customer_trx_all is in there, but I didn't see ra_customer_trx_lines_all.

Regards,

Charles