-
How to create deep link for Purchase Order number in FDI
I'm using the standard subject area (Procurement - Purchase Orders) to build reports. One of the report columns is Purchase Order Number. I need to create a deep link to show Purchase Order number as in FAW. Once I click on the number, Purchase Order page opens in fusion.
-
Minimum Privileges required to view sales territories using GET rest api
I created basic user with no roles added to it. I also created custom role with View Sales Territory privilege as Functional security policy and data security policy with read access on sales Territory. I am not getting data from rest API. can I know the exact privileges to access this.
-
Extend Semantic model sandbox framework-Moving to Prod and semantic model refers to dev schema
Hi, We are facing an issue in PROD after importing and deploying semantic model bundle from Non Prod to prod. Steps followed so far- Create custom schema in Prod ADW. Create Custom table, synonym in custom schema. Grant select access to OAX$OAC and OAX_USER. Generate and export bundle for the semantic model in Non Prod…
-
Unable to join Custom fact table to Time dimension in seeded subject area using sandbox framework
I have created a custom table with the following fields: PersonID, PersonNumber, Month, Year, MonthStartDate, MonthEndDate, CountDays (measure), and CountOfficeDays. Using the Sandbox Framework, I created a logical star schema for this fact table and successfully joined it with the existing Worker dimension. After…
-
Including a DW field in the related dimension
Hi everyone, I’m working on Performance Management and I need to include the Document Type field in the subject area. I noticed that in the DW tables the field already exists (DOC_TYPE_ID in DW_PERF_TEMPLATE_DEF_D and the corresponding TL table DW_PERF_DOCUMENT_TYPE_D_TL). However, in the dimension "Dim – HCM – Performance…
-
OTBI report to display three years of historical headcount data within a single report,
We are currently working on an OTBI report requirement to display three years of historical headcount data within a single report, aggregated by Business Unit (BU). The main challenge we are facing is related to the Subject Area's default effective date handling. While we can override the effective date using Advanced…
-
I have a requirement for creation of a new Custom ESS job running SEEDED GL Standard report
Hi, I am trying to analyze the possibilities to perform a POC to acheive below requirement" We have a Seeded ESS Job called as "Average Balances Trial Balance Report" in which there is one parameter called Accounting Date which we need to implement a custom code like SYSDATE-1, we know we can't touch the SEEDED ESS Job but…
-
Create infolets with the use of FDI reports
Hello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle HCM in the same manner that we have been using the infolets for all the important OTBI reports. Nevertheless, i have not been able to retrieve any of…
-
Fetch multiple nationalities/citizenships in a single row on OTBI
I have a requirement where I need all the nationalities of a person in a single row. Ideally when we fetch the citizenship we get multiple rows. We have tried RCOUNT and PIVOTTING Results but no luck. Has anyone achieved this already?
-
OTBI report to display 3 years headcount taking year as input parameter
Hi All, I need to build an OTBI report to display active headcount of company for previous 3 years taking year as input parameter. Please help. Below is the exact requirement: Bar graph for showing the Growth Rate (across all BU) for past 3 years.
-
Fusion Analytics Extensiblity Series: Case study-Semantic Model (Part 3 of 4)
In this series, we will discuss the use case and showcase the steps to bring in the custom object (created in Oracle Fusion Application) into Fusion Analytics and model it for analytical reporting. This is a 4-part series. The current part covers the Semantic Model Part 1- Use-Case Discussion. Part 2- Data Augmentation…
-
How do I setup dependency on Scheduled Refresh FDI Loads?
I have a requirement to load data from FDI Out of the Box Table into a new custom table. I need to set dependency to check whether the FDI Table I am looking for is already refreshed, before I can trigger a load. (I know there is a workaround to leverage PVO's directly and populate custom table)
-
Dataset fails to be found, has no Access option to enable us to check the permissions.
Hiya, hopefully someone can explain this. We have just stood up the FDI environment in production but we cant access one of our spreadsheet data sets. Errors [nQSError: 17010] SQL statement preparation failed. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call…
-
Is it possible not to have repeated values on X axis?
-
Delete record from Custom Table
Hi All, we are using a custom table "MKT_REF_ENTITIES" to store data as a part of journal import and we have came across a occurrence where we need to delete few records from the above table can you suggest us the possible way to achieve that? Thanks
-
Candidate Source Data
Is there an out of the box dashboard that can be used to get candidate source data?
-
Median value
How to calculate the median value of a field?
-
AP Check print Report creates multiple outbound payment groups in Overflow Scenario
HI, Actually , when we have Overflow scenario for a single payment the output is flowing to consecutive pages . For Ex: If we create 60 remittance lines for a single payment , oracle creates 3 different outbound groups and it is evident in XML and it creates as below . 1st outboundPayable group has original check with 6…
-
How to Suppress Rows with Zero Amounts
How do we suppress rows with zero amounts on fields of measure? I can't filter out zeroes because the filter type is "range." I tried using a CaseIf function and the <> operator with no success. Please advise if this is possible.
-
What does "Position Hierarchy" preview feature bring in?
the description under this preview feature mentions "This feature provides the data related to HCM Parent Position Hierarchy in the data model." Does this mean there is no semantic layer on top of the data model for Position hierarchy?
-
Does the writeback capability exist in FDI
If it does then is there any detailed documentation, or blog, or any information available? System settings have a provision for "Writeback Template XML" but I couldn't find any other information beyond that. The traditional method used for Oracle Analytics Cloud can't be used because we don't have access to RPD. I'm…
-
What's the most efficient way to assign Dashboard access to users?
Hi All, We’re currently in the development phase of the FDI rollout and would like to gather feedback on the SCM dashboards. What would be the most efficient way to grant access to all dashboards under the SCM pillar for a small group of users (2–3 people)? Thank you for your guidance!
-
Data Aggregation Issue with GL Data in FDI
We have created a GL subledger report in FDI that retrieves journal information. However, the data appears aggregated, and we cannot view detailed entries. For example: In BIP, a single journal line generates 356 distinct rows, each with a unique aeHeaderId. In FDI, the same journal line shows only one aggregated line. The…
-
AI assistant not available
I have index a subject area (workforce core) and run the crawl which has been a success but when I go to create a workbook using this subject area and verify if AI assistant is working I get the below message: The Assistant feature is currently disabled as no language model has been assigned. Please contact your service…
-
FDI HCM: Employee Help Desk in Fusion Analytics
Employee Help Desk appears in the current column of the Fusion Analytics Roadmap. where can we find more information on this module? Victor
-
HCM - HR Help Desk Requests Overview Subject Area in the Oracle Analytics Workbook not fetching data
Hi, We are trying to build a report based on the "HCM - HR Help Desk Requests Overview" subject area. However when we try and select columns to the workbook, it is not fetching any data and it shows "No Data Found". The HR HelpDesk functional area has been activated and the pipelines are completed successfully. Still there…
-
FAW connection to EPM (PBCS)
Hi Team, need suggestions in data load from FAW into Oracle EPM PBCS - any reference of connections / blogs etc? Inbound integration into Oracle EPM (PBCS - Planning Budgeting and cloud service) from FAW ? any suggestions on direct connection to pull data into EPM from FAW?? Outbound integration from Oracle EPM (PBC -…
-
How to create CS pivot (Suppliers as Columns) in OTBI?
I am working on a Comparative Statement report in Oracle Fusion Cloud. I am using OTBI subject areas: Procurement – Requisitions Real Time Sourcing – Supplier Negotiations Real Time Sourcing – Supplier Responses Real Time I have a requirement where a single Requisition Number is sent to multiple suppliers. The data is…
-
Oracle quote table in fusion 25d
Currently we are using oracle fusion 25C (11.13.25.07.0).in which table we can find quote id,quote number and otehr quote details .How this can be linked to partner or order details. I have done research still not able to find the table. Please help on this
-
Query to find partners channel rebate program
Currently we are using oracle fusion 25C (11.13.25.07.0).What is the query to get partners chrm rebate programs.we need to get it from zpm_ tables .And through accruals table since we need to get partner's chrm rebate program to check eligibility for accruals
