-
ToDate() function fails.
I am trying to use the ToDate() function in an FDI workbook to get: TODATE(Gross Sales, year). I am getting this error while trying to create the calculation: Internal Assertion: Condition levelExprPtr.get(). file server/Query/Optimizer/ServiceInterfaceMgr/Utility/SQOIUMetadataConverter.cpp. line 6568. I am also having…
-
Segmantic Model
I am confused about the difference between creating a Dataset/Dataflow and building a Semantic Model. Since both can be used to create reports and dashboards, what is the critical difference between them? Could you please provide specific real-world use cases illustrating when I should use a Semantic Model instead of a…
-
Which Table Stores Parent-Child Relationship of Account Hierarchy in Oracle Fusion?
Hi, I have created an account hierarchy in Oracle Fusion GL to define parent and child accounts. I’m using FND_FLEX_VALUES_VL for account segment details, but where does Fusion store the parent-child relationship data that defines which child belongs under which parent in this hierarchy? Could you please tell me the exact…
-
how to burst a email with multiple attachments attached
-
extract substring into new column FDI
Hi! I have this FDI subject area and was trying different types of SQL functions with not much success. Can you please help with this issue? I would like to extract from Location table only the Country name (AUSTRALIA, CHINA, FRANCE etc) into new column only the City Names (Beijing, Paris etc) into 2nd new column How can I…
-
Clarification regarding UI discrepancies in Oracle AI Data Platform: Workbench vs. Updated Interface
Hi Oracle Community, I am currently researching the Oracle AI Data Platform solution. While reviewing recent materials released between December 2025 and January 2026, I noticed some inconsistencies in the user interface (UI) and labeling across different demonstration videos. Specifically, there appear to be two distinct…
-
Moved: FDI Payables and Receivables Tax Information
This discussion has been moved.
-
Impact on Last extract date for Errored PVO's in a BICC Job
I have a BICC JOb with 12 PVO and for some reason , some PVO has ended in error. Below is the error we have received for certain PVO's Caused by: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 60009] The user request…
-
Table or view not exists when we join multiple Subject Areas
Hi Team - We created a Dashboard and report using four subject areas. Procurement - Spend Financial - AP Payments PPM - Project Revenue PPM - Project Invoices When we try to get the customer name from PPM - Project Revenue as a filter, it's giving the following error where as if we use in results in table format, it's…
-
Impact on BICC Extract Prefrenences Configuration on FDI Data Augumentation
We have updated the Prune Time settings to 120 instead of the default setting of 1440 in our BICC console. We also have some data augmentations on certain PVO's. Does the BICC Extract Preference setting have any impact on the PVO defined in FDI. Appreciate any inputs on this.
-
AP Business Unit Data Security Not Populating
We have users setup in ERP with explicit access to our AP Business Unit. When those uses come over to FDI, they are not being granted any AP data access. All other data access like Asset Books and Procurement BU is coming over properly. Is there a specific privilege or data security setting that is required for this to…
-
Facts columns are missing in local subject area 'HCM - Diversity Analysis'
I am not able to see fact values under HCM - Diversity Analysis . when I try to add the annualized full time salary, then data is not visible We have activated the FDI Subject Area called HCM Diversity Analysis, ran the HCM – Diversity Analysis Prerequisites first and are almost certain that we have all the correct roles,…
-
Required value to print attachments
Hi legends, I'm trying to print WOs using a deeplink to manually launch the WO report, which I almost have going. I just dont know what value is required in "Include Attachments" to actually include the attachments. I have tried Yes, Y, True, 1, 100, ON, -1 in uppers and lowers, but I'm just not getting the attachments. Be…
-
Why Time Year shows only current year (2026)?
I need the history of time in order to make this matric affordable while filtering different years: Metric logic is about counting people if they were hired in the past or during current year based on their User Person Type
-
Expression Filter Assistance for CaseIf/IfNull Statement
I am having trouble creating a valid expression filter and need some assistance. My scenario is the following: We have a field, VP Name that is typically populated, but if it is null, I want the expression filter to check Senior Director Name. If Senior Director Name is also null, I want the expression filter to finally…
-
Using Company Logo as a Parameter in Oracle DV Dashboard
Dear Experts, Good day. I would like to know if there is any way to use a company logo as a parameter in an Oracle DV dashboard. Requirement: Display around 10 company logos in the header of the dashboard. When a user selects (clicks) a specific logo, the dashboard data should update and display information related only to…
-
Conection FDI with WMS
Hello team, someone will have a manual or instructive to be able to make the connection of FDI with WMS, since the connector was released, however in my demo instance I can't find this one.
-
Table or view not exists when we join multiple Subject Areas
Hi Team - We created a Dashboard and report using four subject areas. Procurement - Spend Financial - AP Payments PPM - Project Revenue PPM - Project Invoices When we try to get the customer name from PPM - Project Revenue as a filter, it's giving the following error where as if we use in results in table format, it's…
-
OTBI Subject Areas in FDI
Do we have more information on the timing for the OTBI subject areas to be in FDI? I believe it is called, FDI Operational Reporting (LA). This was mentioned on a roadmap call (link below), but we are unable to find any additional documentation or information about this. Knowing the timing, and how this will work is…
-
IPM Cluster is not visible for EPM Enterprise
Hi Team, Does any one face this issue as you could not see IPM option in your IPM Instance for Enterprise subscription with Hybrid mode? I can see for FCCS but not EPBCS, Let me know your advice on this issue. Thanks
-
FDI OACS Classic: dynamically passing parameter for drill
Hello Experts, We are working on a use case in Oracle Analytics Cloud – Classic (Answers) and looking for guidance on the following scenario. Use Case Summary: A single master financial report built in OACS Classic (not DV). The report displays multiple Actual KPIs side-by-side for different periods, for example: Current…
-
Need to fetch the ExtraWithholding column which is located in the FederalTax form in Calculationcard
There is a requirement to fetch Federal Tax form details from My Workforce > Payroll > Calculation Card > Tax Withholding. In this section, there is a specific column named “Extra Withholding.” The value for Extra Withholding is correctly displayed on the frontend UI; however, when checking the backend payroll and…
-
Analytics: Fusion AI Data Platform Office Hours January 8 - Topic: Supply Chain Command Center
Join us tomorrow Thursday, January 8, at 9:00 am Pacific for the first CEAL FAIDP (formerly, FDI) Office Hours of 2026! Guest speaker Kausik Misra, Oracle Analytics Product Management, will provide an overview of Supply Chain Command Center. After the presentation, we’ll open the session for live Q&A, where you can ask…
-
How to exclude a specific value from an expression filter
Currently working on a report and coming across an instance in which I do not want NULLS included in my filter. One Assignment Number can have multiple Last Update Dates. The expression filter that I created (see below) is pulling the last updated LastUpdateDate. Currently, this filter is also removing NULLS from the…
-
Ago Function not displaying data for Prior Year Periods
Ago Function not displaying data for Prior Year Periods in OAC FDI DV.If user select Jan 26 , previous month data for Dec 26 is showing blank column .
-
how to create a new enhancement request
-
FDI HCM Workforce core History data requirement
Hello Team, Client has a requirement to see historical data about person such as BU, Department, Legal Employer, Grade etc at time when he was hired and also another requirement is to see historical data of Person at DFF at Assignment level . However, HCM core subject area is always giving the latest effective dated row…
-
In FDI how to execute detail calculations before aggregation of data
In FDI how to execute detail level calculations before aggregation of data. Using a custom subject area I am trying to execute detail level calculations on data before the data can be summed up. We have detailed shipment records - one line per item shipped - with a status of either 'shipped' or 'returned' and positive…
-
oracle recruiting hiring event, need sql for Interviewer Responses
-
How to display the 12 month data based on the selected month in the dashboard filter
Hi, I need to show 12 month data based on users selected Period in the filter. There is no date column used in the filter. Please advise how it can be achieved. Regards
