Hi Allen, You would probably need to log a SR to determine the "why" as it could take some digging. To start, We would need to know the invoices in DW_AP_SLA_INVOICE_SCHEDULE_CF where INVOICE_ACCOUNTING_STATUS_CODE is 'UNACCOUNTED' and the data from AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL for the same invoices.

Thank you for logging this Enhancement Request. Internally, I have also documented the issue in a new KM Article:FAW:FDI:FDIP: Data Export To CSV Format Is Not Working (Doc ID 3021612.1) and a separate internal Enhancement Request: 36591542

Hello, It does not look like there is any problem with your logic but little tweeks may be required depending on the results. To troubleshoot this, include the calculated column with at least 1 fact and 1 measure from each Subject Area you use in the calculation in a Tabular (Table) Workbook. Change the aggregation method…

Hi Mohan, BIACM is a part of OBIA. The UI does not allow all jobs to be deleted all at once but if you have a unique situation, you could delete the source(s) from _BIACOMP.C_DATA_SERVER and that would work. You should log a SR with OBIA before doing that to discuss the root problem and see if there are alternatives. BICC…

Hi Allen, Regarding you question on whether we may be able to see this capability of having payments which are unaccounted in the fact table in 24R2. I do not see any Enhancement Request that has been accepted for this so the answer is 'No'. I don't think this will ever be a part of the OOTB content since this is a Data…

Hi Vasanthakumar, The beginning of your Report path should look more like: "reportPath": /"Custom/Link-To-FAW/PersonDetails/EMR_Person_Assignment_Report.xdo",,"runInChunkMode": true Regards, John

Hi Scott, I don't see the Headcount in your tabular workbook so it is a little hard to compare the two. I create a Visualization similar to yours with a Case statement. This matches what I see in the Tabular Workbook if I include the 2 columns.

Anecdotally, the recommended order to activate is as follows: --------------------------------------------------------------- Active First: * Employee Expense * Purchase Receipt * General Ledger * Accounts Payable * Assets * Project Commitment * Purchase Agreement * Procurement Spend * Project Billing * Purchase Order *…

Hello, Just a FYI .. This community is for OBIA and BICC extract questions should be posted to the OTBI community. Regards, John

Hi Derek, Just a FYI .. This community is for OBIA and PVO questions should be posted to the OTBI community. Regards, John

Hi Nagesh, Just a FYI .. This community is for OBIA and BICC extract questions should be posted to the OTBI community. Based on what I see in this KM Article, this cannot be changed: Can BICCC Extracts File Name be Customized or Prefixed When Extracting To UCM (Doc ID 2910794.1) Regards, John Whitaker

Hi Cesar, This is not directly related to FAW but the product 'Oracle Fusion CX Sales Cloud Service' and 'Oracle Fusion General Ledger Cloud Service' have confirmed the fields CHILD_COUNT and DEPTH are are currently not available for extract using BICC for table FND_TREE_NODE. This KM Article may help How To Find The…

Hi Anirban, It looks like its been a while since you asked this question and not sure if you got your answer. This issue could be JDBC driver specific and OAS / OAC comes with there own specific JDBC driver as documented here:…

In FAW's Oracle Analytics Tool, you can use 'Actions' and 'Action Links' to call other reports. The same is true for BI Publisher. The documentation on that starts here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/use-data-actions.html#GUID-7AACD0C9-9CC1-430D-BB0F-66513BD138CE Regards, John Whitaker

Hi Ryan, The Parquet file format is not currently an option for BIP, OTBI or OAC. However, based on your explanation, it seems like an idea that be supported by others. You may want to log this idea, in the Ideas Lab here:…

Hi Ankur, This message indicates it cannot access the path. The path examples are here: https://docs.oracle.com/en/cloud/saas/analytics/23r3/fawag/managing-data-connections.html#GUID-5D394FD0-F9D6-48D0-B9F0-0F8861530CEA

Hi Amrita, I don't see that exact Subject Area but FAW would not have a Real Time Subject Area. The current list of Subject Areas are include in the zip file here: https://docs.oracle.com/en/cloud/saas/analytics/23r3/fahia/chapter-subject-areas.html#GUID-2DBDBA24-7046-4D53-B46F-F911128A0601

Hi Pradeep, FAW does not have a limitation. The limitation likely comes from OAC or BI Publisher if you are using that. You should check OAC documentation for limitations based on the number of OCPUs. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/create-services.html#GUID-7D6DB4EE-8DD5-44C5-9B6E-9FA847463A5F

If you have a 'user entity' on the transactional side that can fetch all the payroll balance details, the same should be possible on the FAW side. To get started with FAW and configure users see:…

If you have a 'user entity' on the transactional side that can fetch all the payroll balance details, the same should be possible on the FAW side. To get started with FAW and configure users see:…