Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Joining Party Name from AP to GL Detail Transactions in FAW
Hi Experts. I am trying to put together a report that combines primarily data from 'Financials - GL Detail Transactions' such as account code combination, journal creation date, batch name, balances etc, but I need to also incorporate Party name for here the posting originated from AP.
Looking at the AP Data sets (such as Financials - AP Invoices), the only thing I can find to join the data sets is account code combination, but this results in duplicate records where there is more than one vendor against a single code combination. I would have liked to have used something such as 'Journal Batch Identifier' which is in GL, but not in AP. Any suggestions for the best way for me to achieve what I am trying to?
Thanks in advance
Answers
-
We need to see the underlying physical query for these kind of report to troubleshoot further.
Can you please raise an SR with FDIP support and provide screenshots and session logs to debug further.
Thanks.0 -
Hi @RajeshPolavarapu-Oracle . Thanks for youre reply. Just to confirm, I should raise this to MyOracle Support? Also, please note I'm not saying this is a bug , or issue, more I'm trying to understand the best way to go about trying to achive this.
0 -
Hello @Richard Akomaning,
Have you tried using the Configurable Account Analysis subject area and see if it helps your case?
Configurable Account Analysis (CAA) is a cross finance self-service advanced capability in Oracle Fusion Analytics Warehouse that enables functional administrators to define the comprehensive account analysis template combining data across general ledger and multiple subledger sources right from the initial extract date.
0 -
@Ashish-Oracle - Thanks. No I did not know about this, so I'll look into it and give it a try
0 -
@Richard Akomaning Sure please give it a try and let us know if it helps answer your question.
Thanks and Regards
Ashish
0 -
@Richard Akomaning Did you give it a try and see if the CAA subject Area helps achieve your requirement?
0 -
@Ashish-S-Oracle I was not able to see this subject area in our system. Is this something that comes as standard with FAW? Do you know how we go about getting this in? I may need to speak with our environment Mgr incase it's something I cannot see with my access. Thanks
0 -
Hi @Richard Akomaning You will need to Enable the CAA feature. Below document has all the details you need to enable CAA and setup the same.
1 -
Hi Team,
I am trying to pull Supplier Name from Financials AP Expense or Invoices in to GL Detail Transactions Subject area but I couldn't find the relevant join condition to bring in.So I am trying with CAA Subject area as well but it is throwing error as
Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. (HY000)
Can you help me with the appropriate key column to pull in Supplier Name column in to GL Detail transaction SA.
0
