-
Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?
Ran the Supplier Balance Aging Report and encountered this error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ORA-06512: at line 4 Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?
-
Audit table name for Customer Contacts
Dear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts. We have tried exploring multiple tables such as HZ_PARTIES_, HZ_ORG_CONTACTS_, and HZ_CONTACT_POINTS_. However, we have not been able to retrieve the necessary…
-
Logout timer
Is there a way to extend the time before logout? Too often I lose my work because the system kick me off
-
Can My Calculations folder be shared with other users?
I created some calculation by my own but colleagues cannot see them
-
How to custom aggregate rows of a table?
I have a list of companies, let's say A, B, C, D, E, F. I want to aggregate them in a custom way, let's say 1, 2, 3 where 1 = {A,B}, 2 = {C,D}, 3 = {E, F}. How can I do it?
-
Key Metric to count years from Enterprise Hire Date to now
I'm trying this but for the same Enterprise Hire Date I got different results. Why? I also tried the following but I got similar results: SUM(TIMESTAMPDIFF(SQL_TSI_YEAR, "HCM - Workforce Core"."Employment Information"."Enterprise Hire Date", CURRENT_DATE))
-
Reset and Reload the Data Source - option not showing
We have enabled the "Reset and Reload the Data Source" feature but the option is not appearing on pipeline setting: Feature enabled under Generally Available Features: This should add an option under Data Configuration/Pipeline Settings The only available option is "Reset Data Warehouse" Reference:…
-
How to restrict prompt values in Dashboard Prompt
Hi Experts, Could you help me restrict the prompt values in the dashboard prompt? I'm using this dashboard & column, "Recruiting - Recruiting Real Time"."Job Requisition - Progression"."Current Phase" and wants to show only five values in the dropdown list, like, Thanks
-
Row level data security for Local Subject area with auto caching or dataflow based saved dataset
Can you please tell me how Row level data security works when Local Subject area with automatic caching or data flow based saved dataset is used in visualization. When we do it on live data or from a subject area directly in Fusion Data Intelligence, fusion application-based access group security is taken care in FDI so…
-
Is the GL Account Combination from projects before it’s pushed to GL or is it based on GL details?
Is the GL Account Combination from projects before it is pushed to the GL or is GL Account Combination based on the summary of the details posted to GL?
-
What's wrong with this Key Metric?
I tried both versions
-
How to fetch data of the past?
In subject area "HCM - Workforce Core" I need data to be with effective date 1st Jun 2024. How can I do this?
-
How to Add user to FDI Enviroment.
Hi Team, When we create an instance with "No-fee Trial" subscription, how can we add new users to this environment. We were able to see an IDCS associated with this instance, but was trying to identify where this IDCS resides and how to access the same. Please help
-
Unable to add DFF PVO.
We see that PVO is not available in BICC and unable to add DFF as mentioned in Oracle support page. Attaching screenshot for reference PVO: FscmTopModelAM.ReceiptRateAdjustmentFLEXBIAM.FLEX_BI_ReceiptRateAdjustmentFLEX_VI Please suggest solution to this. Thanks in advance.
-
Where can I validate the available space in FDI?
Where can I check the space I contracted with Oracle? For example, I think I have 50 GB of storage available, I have been building some reports and even connecting to some data sources, I would like to validate where I can control the space I have available.
-
Month in column on top of the report
Hi, I have an issue with the month column display : In the 1st screenshot below, I have been able to add the month as a column including all the main other columns (which are all VALUES) - except for POLES which is not a value. In this 2nd screenshot (since only the last column is a value I guess), the month column is only…
-
Change currency format
Hi, I want to change the format to Colombian pesos, in the list is available the currency, but in the column the system adds the label “COP” instead of the peso symbol “$”. How do I replace the "COP" with the “$” symbol?
-
Organization Chart
Summary Provides a sample organization chart by top manager Content This .dva document provides a sample visualization and an associated dataset that powers the organization chart. The data set is based on a logical sql attached here. The organization chart is based on the managers that are available for reporting in the…
-
Ability to delete a subject area without using the Semantic Model Extension
Hi, I have created fact and dimension extracts using data augmentation for AP Invoice Distributions, and named a new Subject Area called "AP Invoice Distributions Ext". Since the subject area did not exist, it got created once the augmentation was activated. However, I am not able to delete the subject area once created -…
-
How can I reuse SQL code generated in OTBI in a Data Model (DM)
Here’s the translation to English: I have a question regarding the execution of SQL generated via OTBI. I would like to reuse this report but include some additional elements. I want to execute it through a Data Model report. I saw that we can run this report through a data model using the ORACLE OBI EE method. Given this,…
-
What is the cause of this error: ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ?
Ran the Supplier Balance Aging Report and encountered this error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ORA-06512: at line 4 What does this error mean? How do we check the package named FUSION.AP_APINVAGE_XMLP_PKG?
-
Hii, I have a requirement to enable the absence dashboards in oracle fusion HCM.
Hii, I have a requirement to enable the absence dashboards in oracle fusion HCM. please suggest how to enable this?
-
Fusion Data Intelligence - Hyperlinks in table (upon click)
Hi team, I have a Table created in visual section within Fusion Data Intelligence, it has customer number, transaction number and job number as some of attributes in the table. Is there a way to create dynamic hyperlinks (which opens a new tab upon click) on all 3 of these attributes, please advise. Thanks in advance.
-
How do we view the ERP ML Subject Areas? Unable to see them after activating and loading data
We are not able to search for the Customer Collections Risk Prediction Functional Area, even though we have activated it and loaded the data into the pipeline. Are we missing a step to activate it? We are attempting to add the data to a report, but we cannot search for it. Is this accomplished in a different area in FDI?
-
Where I can find transaction account
Hello everyone, I am working in the bi report and the costumer request to add transaction account number and description. I tried to find the table that contain those data but not luck. this is what exactly I am looking for in the following picture. Thank you in advance
-
HCM Deep link details (object keys and corresponding FDI columns)
We have followed the guidelines to create deeplink navigation from FDI to Fusion: https://blogs.oracle.com/analytics/post/oracle-fusion-analytics-use-of-deep-links-to-navigate-to-fusion-applications-from-data-visualizations However it is not clear to us how to identify the object keys in Fusion and the corresponding…
-
How do we enable the Prediction Statistics (Supplier) folder within Financials - AP Aging?
The Supplier Risk Analysis delivered dashboard shows Query error for all the visuals because it is using 'Supplier Risk Decile'. Per SR# 4-0000037587, the following ML modules need to be activated, we which we have done, but the issues till remains. Customer Collections Risk Prediction Customer Collections Date Prediction…
-
BI Publisher XPT='template' ERROR
We have installed a publisher 12c version, but after registering on a publisher, we receive an error when we make changes or share it with other users. Anyone experiencing this problem? How should we solve it?
-
Shared Folders > Oracle Fusion ERP> General Ledger reports show no data found
When trying to view data in any of the General Ledger reports, no data is found. The ERP Fusion data sets are set for the user and can be seen in the security assignments area for the user. What am i missing not to view the data? I can view the AR and the AP data - only the GL is not visible. Any help is appreciated.…
-
How to avoid ask reference when I validate a request
Hello, Sorry, I'm not sure I'm in the right place. I have a problem with editing reports. I duplicated a data model and want to add fields in the query but parts of the query are dynamic. And when validating the changes, it asks me to value these parts. How can I validate without doing this valuation? Thank you
