-
“FUSION_APPS_Enterprise Scheduler Job Application Identity for HCM.” user is not coming while search
Recently, we observed that this user account now appears to be renamed to “FUSION_APPS_Enterprise Scheduler Job Application Identity for HCM.” This change was not made by our team. Additionally, when attempting to assign this user account—using either the old name or the new name—to another BI Publisher folder, we are…
-
OTBI Report Automation - Upload .catalog file
This might be repetition of the question - Is it possible to upload a BIP report .catalog object using the SOAP web services? - Oracle In order to enforce change control and git actions, we are automating the BIP Report upload process. To keep things consistent for FRS, BIP, OTBI reports, we are going to ask developer to…
-
Restrict OAC report bursting for some users
I have a report in which bursting is defined. I want to make this option unchecked by default when any user is scheduling a job. How to achieve that? If it's not possible to make that unchecked by default, then how to restrict bursting for some users?
-
Tenure calculation in OTBI
Summary: Used Current_Date function & Enterprise Seniority Date field to calculate Tenure (in a separate field) however the result is not accurate (its showing value zero for some colleagues). Can someone help me understand what additional criteria do I need to use to calculate it correctly please Content (required):…
-
access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID."
Having this error when trying to access report i have tried adding roles to BI publisher but still persists
-
How Can I create a Reporting only Recruiting role?
Hi Folks! I want to create a custom role that provides access to all BIP reports and OTBI Analyses under a specific folder — Shared Folders/Custom/Custom Reports/Recruitment — while ensuring that users with this role do not have access to any recruitment-related options in the UI. For this, I created a Job Role with the…
-
Costing: Receipt Accounting Real Time subject area missing Intercompany lines, concatenated segments
Hi all — hitting two issues on the Costing – Receipt Accounting Real Time subject area (Fusion Cloud SCM, OTBI). Has anyone seen these or found a workaround? Issue 1 — Concatenated Segments blank for Draft entries. The subject area doesn't return Concatenated Segments for accounting lines that haven't been transferred to…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time
I need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) <= 5 THEN '1-5 'WHEN…
-
Learning records real time : Inactive employees learning data
Summary: It is observed that the learning records real time subject area only pulls in active employees data. Is there any way to override this exclusion to be able to see data for terminated employees ? We require the ability to report on all courses completed during a time period, and for audits.
-
OTBI report for absence with Accrual, Adjustment and carryover details of an employee.
I would like to create an OTBI report to display Accrual, Adjustment and carryover details of an employee. We have updated the carryover and adjustments through data load templates with type as ADJOTH and COVR.
-
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…
-
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.
-
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…
