nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Joining Party Name from AP to GL Detail Transactions in FAW

Richard Akomaning

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

Find more posts tagged with

FDI

Accepted answers

All comments

RajeshPolavarapu-Oracle

Hi @Richard Akomaning

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.

Richard Akomaning

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.

Ashish-Oracle

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.

https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/advanced-configurations.html#GUID-FCAF1C34-F3FA-4622-86ED-453BF230EE1E

Screenshot 2024-06-27 at 11.51.20 AM.png

Richard Akomaning

@Ashish-Oracle - Thanks. No I did not know about this, so I'll look into it and give it a try

Ashish-Oracle

@Richard Akomaning Sure please give it a try and let us know if it helps answer your question.

Thanks and Regards

Ashish

Ashish-Oracle

@Richard Akomaning Did you give it a try and see if the CAA subject Area helps achieve your requirement?

Richard Akomaning

@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

Ashish-Oracle

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.

https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/advanced-configurations.html#GUID-FCAF1C34-F3FA-4622-86ED-453BF230EE1E

User_41Z9Y

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.