-
Need to check the feasibility to enable or add these DFF attributes in all procurement subject area
Those DFF attributes are at PO header level and they are BI enabled but only visible in procurement real time not in other procurement subject area like procurement procure to pay.
-
OTBI: Replace Line Feed characters from CLOB column
CLOB column contains line breaks in html. We tried following function which works only if CLOB column character length is less than 4000. REPLACE(REPLACE(REPLACE(CAST("Performance Goals"."Success Criteria" AS VARCHAR2(4000)) ,'<br/>',''),'<p>',''),'</p>','') Does OTBI support TRANSALTE or EVALUATE? if not, do we have any…
-
Format Excel > Goal Success Criteria splits into multiple lines
Hello All, We are experiencing the issue on report exported to show goal’s success criteria : The text for success criteria appears on multiple rows instead of one cell. Any idea on how to show the success criteria in one line ? The success criteria contains HTML Tags For the column Success Criteria, Data Format is HTML…
-
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…
-
Workforce Scheduling - Work Pattern Real Time
Hi all, I am trying to report from the Workforce Scheduling - Work Pattern Real Time subject area, I can see data in Fusion apps UI (to confirm there is data there - I have the Workforce Schedule Administrator job role), but I am unable to see any Work Pattern data in OTBI in this subject area, is this an issue that anyone…
-
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
-
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…
