-
Previously Held Manager Role (Not Active)
I am trying to build an analysis that would give me a list of employees who were managers in any time in the past but are not managers now. I am using Workforce Management - Worker Assignment Event Real Time, but I cant find the field that that would answer "Working as a Manager" question. And how to limit it to only those…
-
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses Availability
Hello, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration page (/fscmUI/redwood/cx-analytics/application/container/dvconfig), I can see the "Create Configuration" screen, but the analysis search dropdown is empty.…
-
Event based trigger to capture change on any transaction
Can we extract oracle data based on an event. Is it available only against few PVO or expose for all kinds of event - Like invoice creation, invoice update, invoice cancellation, GL creation, Intercompany etc. We would like to keep our data warehouse in sync as soon as an update is made in Fusion. Do we have any event…
-
Consume external REST API in Fusion BIP
Is there a solution to consume external REST API in BIP Report and use the response as data source?
-
I am using OAS and I added embedded content to my dashboard, but it shows blocked content
I am using OAS and I added embedded content to my dashboard, but it shows blocked content check with admin. the link I put is reading from corporate portal
-
Request for Guidance on Users, Roles, and Privileges Reporting
Currently, we are using the standard subject area "Security - Roles and Privileges Real Time"; however, it does not support retrieving all three combinations together. At present, we are only able to fetch: Users and Roles, or Roles and Privileges but not a complete mapping of Users, Roles, and Privileges in a single…
-
Avoid fetching Active employee got Terminated when fetching Inactive Employee Data
How to avoid fetching employee currently active but this employee got terminated multiple times having different assignments number when fetching inactive employee's data currently using Workforce Management - Worker Assignment Real Time Subject area
-
Enterprise Scheduler Job Application Identity for HCM-FUSION_APPS_HCM_ESS_APPID RoleMembershipRemove
How does FUSION_APPS_HCM_ESS_APPID being triggered and execute RoleMembershipRemove. We found in audit report that it removes multiple roles in 1 user.
-
How to send analysis results by email when analysis is included in a dashboard
When you open an OTBI analysis based on subject area, email feature is available at the of the results page. If you include the same analysis in a simple dashboard, email feature is not available anymore. You can unable 'Report Links' as 'Analyze, Edit, Copy, Add to Briefing Book, Refresh and Print' but email is not…
-
Can we get the consistent snapshot across PVO
We are performing PVO extractions every two hours; however, we are encountering reconciliation discrepancies during our quality checks due to the high frequency of data updates as system is constantly being used by users. To resolve this, we intend to utilize Oracle Flashback Technology to query data as of a specific…
-
Extracting specific data set from BICC PVO's
Do we have any SOAP/Rest API which we can use to fetch selective data against a PVO by passing in specific primary key as parameter. Currently, the documentation states only a incremental job can be triggered using SOAP. Can you please confirm.
-
how to fetch active BIP scheduled job list using BI/OTBI report
Hello everyone, We have lot of reports which are scheduled to SFTP or Email. In few of them bursting is enabled and few of them are not bursted. We want to fetch all the scheduled job list and other details for schedule such are delivery mode, frequency, start date etc. We want to fetch list of Active Jobs in Oracle using…
-
Is it possible to enable "Save Search" functionality for end-users on OTBI Dashboards?
Hi everyone, I'm looking for a way to allow users to save their selected filters/criteria on an OTBI Dashboard, similar to the "Saved Search" feature found in the standard Oracle Cloud ERP transaction pages. Please let me know. Regards, Warunyu.N
-
Workforce Management – Documents of Record Real Time
I am attempting to create an analysis that shows the status of a specific document submission for each Worker; each worker is required to submit a Document of Record with a Document Type of “NDA” each year. From the “Workforce Management – Worker Assignment Real Time” SA I am returning basis Worker details, and from the…
-
OTBI Analysis for AP Invoice Lifecycle
is there any OTBI analysis available which can provide AP invoice lifecycle summary
-
How to create ess job that will directly use the parameter of the data model?
Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to recreate the analysis on a data model by taking the SQL from the Advanced tab. In the data model, we made the Data Source as Oracle BI EE. The problem is, we…
-
Redwood Purchasing Landing Page - OTBI question
I've consulted these links below and am still unclear from the documentation language how to make the OTBI reports appear in the Create Configuration page. It doesn't seem to open just for any OTBI. What are the steps to make sure I can choose the OTBI report other than it being in the Shared folders? Redwood: View and…
-
ERP Subject Area custom? field missing 26A
Hi! All of a sudden one custom made analysis stopped working in our production system, it still works in our test system. Since it is working in our test system I was able to get the issued SQL from test, as you can see in the sql there are three "custom fields" in the query. It seems as if those three custom fields are…
-
[OTBI] Extract "comment" field in the transaction console
Hello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which we have to insert a comment in the third step of the terminate work relationship page Transaction info : In BI Publisher, I was able to retrieve this field…
-
Linking Two OTBI Analyses' Together With A Deep/Action Link
Hi all, I'm wondering if the following is possible and if so, how I'd go about doing it. Example I've got two reports, Report A and Report B. Report A brings back an employees Name, Sickness Type and Dates of Sickness Report B brings back more detailed information about the employees' absence we do not want to surface in…
-
How to query PVO in Oracle BI Publisher Data Model
I need to query PVO data in BI Publisher, here's the PVO name: HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue Any screenshots, ideas, hints? Thanks.
-
What federal compliance reports such EEO, ADA, and FMLA are provided
-
OAC - How to create "Live" data set that based on OTBI subject area ?
OAC - How to create "Live" data set that based on OTBI subject area ?
-
Is it possible to remove a certain field/column from the output of CSV file in OTBI report?
Hi, Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format. As you can see, these are IDs connecting the DM. In the report's layout the highlighted IDs are not included. But when we are exporting in CSV, the IDs are being…
-
How to make a copy of an analysis under an analysis - Recruit to Hire Dashboard
Hi, The Recruit to Hire Dashboard is a seeded resource in the Oracle release, so users can’t modify it directly unless they create a copy. We were able to copy most of the analyses, but there is one called “Hire KPIs” that drill down into five additional analyses. We haven’t been able to figure out how to copy those…
-
How to connect Power BI with Oracle in OTBI?
Hello everyone, Does anyone know if there is currently a manual with the steps to follow to connect the Power BI application with the Oracle Cloud application to import reports and analysis? Currently I have tried to connect but I am getting the message that it cannot connect due to the error: "Oracle: ORA-12538: TNS:no…
-
Filtering data in Workforce Management – Documents of Record Real Time
I am joining the “Workforce Management – Worker Assignment Real Time” and “Workforce “Management – Documents of Record Real Time” Subject Areas, if I add a filter to identify Workers that do not have any records in “Documents of Record” (either filtering on “Document Count = 0” or “Document Type is null”) it returns no…
-
Is it possible to create an OTBI report that fetches all manager details for an employee?
We’re encountering two issues with an OTBI report designed to fetch manager data. First, certain employees' data isn't appearing in the report despite being present in the system. Second, the report is only capturing one manager when an employee has multiple managers of the same type assigned. Has anyone encountered this…
-
Missing Sections in OTBI for Candidate Details Section in ORC
I am using the Recruiting - Recruiting Real Time subject in OTBI and am searching for the following sections coming from the Candidate Profile within the Oracle Recruiting Cloud: National Identifier (social security numbers), Biographical Info (date of birth), and Candidate Attachments (uploaded candidate documents). I…
-
Human Capital Management - Transaction Administration Real Time Subject area didn't result
Dear Experts, Human Capital Management - Transaction Administration Real Time subject area not retuning any results. I have all roles: Role name: TMEIC Human Capital Management Application Administrator ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB Duty Roles This job role is related to the following duty…
