Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

EBS 122 Receibavles

Received Response
1
Views
3
Comments
3439799
3439799 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

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

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    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

  • 3439799
    3439799 Rank 1 - Community Starter

    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
    Charles M Rank 6 - Analytics Lead

    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