Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
EBS 122 Receibavles
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
-
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
0 -
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?
0 -
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
0