-
For SFTP Connections, do the metadata files need to remain on the server after they are processed?
For an SFTP connection, do the META_DATASTORES.csv and the META_DATASTORES_%%%%_COL.csv files need to remain on the server in order for the connection/data augmentation to continue to work?
-
Where to find employee contract dates?
Hi, We're building KPI dashboards for HR admins and line managers and want to create overviews of new hires and ending contracts. We're unable to find important employee dates like projected start date and contract end date. Can anyone help us locate these dates? Thanks!
-
Migrating a theme from DEV to PROD
Hello, We have our corporate theme built into FDI as the default theme. This was configured in the DEV environment and now we're moving to PROD. Is there a way to copy the theme from DEV to PROD? This would help ensure all the settings carry between environments. Hopefully you have some insight. Kind Regards Rob
-
Need Access to Canada Entry Point in Pipeline One View
Hi everyone, I’m currently using Pipeline One View with LAD as my entry point. However, I started working with Canada as of October 1st, and I now need access to the Canada entry point as well. I work in CDD, and we use the sales forecast in Pipeline One View to identify which opportunities will require a contract, so…
-
Data Validation - Best Practices
Hello Everyone, For those who have implemented Oracle FDI, I’m looking to understand best practices around detailed data validation to ensure data quality. Specifically: How did you approach validating metrics across Subject Areas? Did you validate all metrics, or focus on a select set of key metrics within each pillar…
-
Options to Add Overrides for Forecasting Only (Without Affecting Billing)
In Oracle Fusion ERP, the standard override functions in Contract Billing Schedules and Overrides are designed to impact both forecasting and billing, since contract billing and project revenue recognition are tightly integrated. Is there any other way to adjust project forecast (override function) without impacting…
-
Security of FDI reports embedded in Fusion
We want to embed some reports from the ERP we built in FDI into the Fusion Cloud application. We have identified that we can do this through Visual Builder, but we have the following question: If we embed an FDI report in Fusion, can any Fusion user (who does not have an FDI license) view the report data?
-
Is there a REST or SOAP API to post receipts to the ledger in Oracle Cloud Financials?
Hello everyone, I'm currently working with Oracle Cloud Financials and looking to automate the process of posting cash receipts to the general ledger. In the user interface, this is done using the "Post to Ledger" button within the "Manage Receipts" screen. I would like to know if there is a documented way to perform this…
-
ERP Analytics - Projects Ending Balances
Hi Team - Good Afternoon! Is there a way or subject area to get the project beginning balances and ending balances for a given month ? Thanks in advance.
-
Can we restore access to the Oracle BICC Logs?
As of the 25C update, Oracle has removed the ability to access BICC (BI Cloud Connector) logs. This change represents a significant limitation for developers and data engineers, as these logs were instrumental in troubleshooting and understanding the data extraction process. In particular, they provided valuable visibility…
-
the function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words() is not return the words in spanish for Peru
the function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words() only return the words in spanish for select countries/currencies like Spanish Mexico/MXN but for Peru/PEN is returning only in english. something ismilar happen for other latam countries. and we cannot find the way to translate correctly. we are trying to generate an…
-
Customer FBDI Import (19 tables)
Hi everyone, I have a question regarding the Customer FBDI Import (19 tables) for Customer Profile. If I want to import both the Profile at the Account level and the Site level, is this possible? I populated the following four fields in RA_CUSTOMER_PROFILES_INT_ALL, but only the Site-level profile was created. I need both…
-
Generate multiple Excel sheets based on parameter value
Hi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel output where the number of sheets depends on parameter value dynamically. If parameter X is A, all three sheets (A, B, C) are generated in Excel, if parameter X…
-
How to hide a custom data set from users who have access to the data
As part of our transition to CAA, we want to hide old custom data sets containing Financials - GL Account Analysis columns. We no longer want users to be able to select this data set to create a report. How can we hide it so only admins see it? When I go to Inspect action on the custom data set, it already is restricted to…
-
ER -To add user defined member list in ERP fusion web studio.
Hello, We were using user defined member list in ERP fusion financial Reporting Studio(Desktop). After upgrad to ERP fusion financial Web Reporting Studio this feature is unavailable to use. I have raised SR(4-0001061262:-We want to create User defined member list) and technician confirmed this feature is not there in ERP…
-
Where on earth is the Semantic Model Extensions action?
Hi there - As per the subject line, where do I even find the Semantic Data Model Extensions that so many FDI tutorials - like this one - refer to? Here's what I see on my screen, despite having every conceivable administrator right and privilege I can think of. Am I looking in the wrong place, or am I missing something?
-
How can I extract LEGAL_ENTITY_IDENTIFIER?
How can I extract the value of LEGAL_ENTITY_IDENTIFIER from XLE_ENTITY_PROFILES table if in HR_ALL_ORGANIZATION_UNITS_F table it's null the LEGAL_ENTITY_ID field?
-
Retention Analysis
Content A key HR concern today is volatile employee attrition rates as this leads to a significant amount of expenditure towards getting a replacement for a high performant, loyal employee. Hence to curb employee turn over, employee retention rate is a key metric for any organization's HR strategy. OAX enables an…
-
FDI Pipeline Freeze – Need to Keep Talent Acquisition Subject Area Live
Hi, We have a daily FDI pipeline refresh, but during quarterly headcount reporting we freeze the pipeline for 2–3 weeks to maintain a consistent snapshot for multiple headcount reports built directly on subject areas (some with 100+ canvases). The challenge is that our newly live recruitment dashboards also depend on this…
-
HCM Data Security
Hi all We have a requirement where users have both Line Manager and HCM Org Data Security. As far as I am aware, it is only currently possible to secure the security setting at an environment level to either Most restrictive which will only show the Line Manager Hierarchy or Least Restrictive which will show both at the…
-
Is there any Subject Area where we can see AR transaction statuses other than "Complete"?
As we knew that "Financials - AR Transactions" Subject area brings only "Complete" transaction status for Accounted and Unaccounted transactions where our business needs to see all the transactions other than "Complete" (Eg. Incomplete, Voided, Pending Approval or Frozen etc.). We have checked in all other AR Subject Areas…
-
Issue with Supplier-wise GL Balance Data in Custom Subject Area
Hi Team, I have a requirement where I need to display Opening, Debit, Credit, and Closing balances from the GL Balance Sheet along with Supplier-related information from the Supplier subject area. When I try to bring the Supplier dimension directly into the GL Balance Sheet subject area, I receive a query error. As an…
-
How to delete all jobs at once in BIACM/BICC?
How to delete all jobs at once in BIACM/BICC? Thanks in advance.
-
How to store historical data
We need an Overdue POs graph in OAC/FDI: X-axis: Fiscal Date (daily). Y-axis: Total number/quantity of overdue POs as of that date. See image. For example: On 29-Sep → show how many POs were overdue as of 29-Sep. On 30-Sep → show how many POs were overdue as of 30-Sep. On 01-Oct → show how many POs were overdue as of…
-
Need Supplier Products & Services Category Hierarchy levels in FDI
There is a BIP report built on the "Supplier Products and Services Category Hierarchy". The hierarchy data in BIP is sourced from the POR_BROWSE_CATEGORIES_VL, POZ_SUP_PRODUCTS_SERVICES, and POR_BROWSE_TREES tables. Separately, a FDI report is built on "Supplier Category Hierarchy Levels" columns from the Procurement and…
-
What is the limitation on number of rows we can download using OTBI report
Hi, we have created a OTBI report for Item master but when we download using csv it can download only 75000 rows. so want to know if there is any limitation on number of rows that can be downloaded using OTBI report. Rgds, pradeep
-
Custom Subject Area Primary Objects for ERP and SCM Cloud
What are the Primary Objects that we are supposed to have access to? I am looking at creating a Custom SA for Sourcing Responses. I only see the following:
-
BICC Extract PVO Availability for POR and DOO Tables
Hi Community, We are currently working on a data integration setup where we extract Procurement and Order Management-related data into our data warehouse using Oracle Data Integrator (ODI) via BICC. Could you please help confirm if there are any existing ExtractPVOs available that cover the following tables?…
-
Registration URLCode and registrationAccessCode
We are implementing Supplier Registration.We need required tables to get this information for Registration URLCode and registrationAccessCode dynamicallly based on user mail id or token and supplier registration key befor creating the supplier based on email id
-
Looking for PO line quantity column in Purchasing Subject Areas
Hi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real Time. But its showing blank. Then tried to calculate it with Line Amount/Price, but it will return zero if line price is 0. May i know which column has to…
