@Muzaffaruddin This looks like a screen grab from Fusion OTBI ? If thats the case you should be reaching out to the Fusion OTBI forum below

Hello @Jeetesh Singh Since the query is related to BIPublisher, please ask the question in the BIP forum.

@User_YBLLE Fusion Data Intelligence provides a list of PVO's which can be leveraged for Data extraction using Data augmentation feature as "System Provided" and those are listed below:- You can still go ahead and use these PVO's in Data Augmentation using the "Customer Provided" option. So, until the source Fusion…

@Liaqat Hussain Can you please try using the below metrics? SCM - Inventory Turns->Onhand Quantity Last Period SCM - Inventory Balances->Onhand Quantity

@JDCal In cases when upgrades are scheduled for the day the incremental for the day might be skipped and run as a part of the upgrade completion. Please check on the part if upgrade was scheduled for the day.

@User_L2TQS Do you have Financial analytics→AR accounted Transactions functional area activated? If not, can you kindly activate the same and then check if the Unaccounted fields still show this error? If yes, then I suspect this is something that would need our internal teams review over a Service Request.

@User_L2TQS I can see "Facts-Ledger Currency (unaccounted) being listed in "Financials- Assets Transactions" as part of the data lineage for 24R2. Which subject area are you checking and not finding this table?

@Binu S The FDI sales agreement table is DW_AGREEMENT_CF. Can you please check the same and confirm if this is the table you are looking for?

@Binu S This is a duplicate of the below community post. Please mark this current post as Closed

@Rav Singh You have posted the query in the right forum ie. Oracle Analytics Cloud and Server Coming to your issue, you are requested to raise a SR with the "Oracle Analytics Server" product team and provide the diagnostic dump along with the official document you followed for further review. Based on the review we will be…

@User_8NMCW My update is based on the understanding that the Pipeline loads are run to load the Warehouse tables where as the Report data is picked up from BI Server cache. Can you provide the documentation reference provided in this SR confirming your last statement?

Hello @Madhuri Brammadevara, Your question is related to OTBI. Please go ahead and ask the question in the below forum

@User_8NMCW Clearing BI cache operation is always performed on the OAC side, irrespective of the OAC being standalone or integrated with FDI. And since there are no automatic cache clearing mechanism from FDI side related to OAC, Customers are suggested to plan their BI cache purge in any way feasible for them. Above…

@JDCal You can use the Semantic Model Extension Feature to add the Objects in the Data model, which have already been brought to the ADW using Data Augmentation. In case you find there are additional attributes which you want to add to the Prebuilt dimensions, you can Extend prebuilt dimensions with additional attributes…

@Nidhi Chhajed It seems like you are attempting this connection on the Fusion/OTBI side and not FDI side, If that is the case, then please ask this question in the Fusion Cloud Customer Connect Below.

@User_8NMCW BI Report cache is not cleared automatically post the pipeline loads. You may need to plan to purge your cache regularly in order to avoid stale data on reports. Please refer the below KM note which talks about one of such ways to do it, How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using…

@Pooja K-Oracle There is no official documentation to perform this kind of a data fix. You may have to come up with a Custom Solution based on your requirement here.

@Dhaval Parikh Stantec Please download and apply patch 36394196. In case you are still observing a similar error, it most probably means one of the openssl rpm packages are missing in the environment where OAS has been installed and needs to be there to make this error to go away. As a solution, Add package…

@Amanda Hope You will need to create the Data Pipeline for the functional areas and then activate the same. Click on Data Configuration->Application->HCM Click on Create Select Offering as ‘Human Capital Management Analytics’ Select Functional area as “ Goals and Career Development” Click Next and Finish Once the pipeline…

@Victor H It appears you are looking for the logic of the pipeline on how data is loaded from Fusion Application to FDI Data Warehouse which is currently not exposed. The lineage details covered in the provided guide is the only source of information we have currently.