-
Issue to create an analysis from General Ledger subject area
When I am trying to create an analysis in OTBI from General Ledger subject area it is not giving the proper output. I just added salary codes, and when I am trying to add CPR number , then result is showing null . Not only CPR number , when I tried to add any other components together , its showing no values Regards,
-
Person Costing Details Export Using OTBI Subject Area
Hi Experts, We have a requirement to extract employment and costing details for a person. We have used the following subject areas: Worker Assignment Real Time and Payroll Costing Setup Details Real Time, but they are not returning the correct data. Are these the correct subject areas to extract costing information for a…
-
Latest data changes are not reflecting in the OTBI Dashboard immediately
Hi All, We are currently experiencing an issue with a Performance Goal OTBI Dashboard that has an embedded BIP report. Specifically, updates to goal data, such as changes to an employee's goal weight, are not reflecting immediately. It often takes over an hour or requires a manual clearing of the BI Publisher Object Cache…
-
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.…
-
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…
-
Apply Button not working for BI Report after adding to Dashboard
Created a BIP Report which is having parameters and added the BIP Report to a Dashboard Page and also created Dashboard Parameters page. After selecting the value in the Dashboard Parameter clicking on Apply button not able to see the output, after clicking on Refresh button able to see the output. Is this the expected…
-
is it possible to create a report that counts when a report output is exported by user?
-
Error when adding a DFF attribute(Journal Line Level) to the OTBI Analysis
Hi, We have built and OTBI report using both Subject areas i.e., (Subledger Accounting - Journals Real Time and General Ledger - Journals Real Time). It is working fine but once we add an new column which a DFF at Journal Line Level, then it is ending into Error. The Error Message is as Follows:- Error occurs while calling…
-
Parent Manager not displaying for Positions without incumbents
I have created this report to track all active positions and the holders but I can't seem to get the name of the Parent Managers to display in some scenarios. I suspect if the Position is vacant even while the Parent Position has an incumbent I am not able to get than name displayed. Can someone please assist on how best…
-
OTBI "Is Prompted" filter with "Or" for NULL value for same field not working
We have an OTBI report with a prompted calendar filter. The "operator" for this prompt is greater than, so rows will be included where the date is greater than what the user enters. We need it also to return rows where this field is null. The criteria for the report includes the filter conditions below, which we thought…
-
Error joining subledger and general ledger
Hello, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real Time and General Ledger: Journals Real Time. It works fine up to the point I add the a supplier DFF from the Journals Real Time subject area. The error message is as follows — Details: ADFException-3007: The View Object…
-
Payroll Flow - Child Action Person Number
I am trying to write a BI report to get the details of the employee related to this Person Number in the Payroll Flow - Child Action section. I found the value in the column PARAM_NAME_VALS with the value PERSON_PROCESS in the table PAY_REQUESTS. However, we don't have person numbers with that many digits and I don't know…
-
Pending worker report
I am new to reporting, and I have to make a report using BI Publisher data modeler in SQL. When I put effective start date later than today and DATE_START later than today, I get back both pending workers and employee records for the same person. Both records have start dates in the future. Why is this the case and how do…
-
How to build an Oracle Transactional Console dashboard using OTBI with approval workflow and role ?
Hello Experts, I am looking to build a Transactional Console-style dashboard using OTBI subject areas in Oracle Fusion Applications. Specifically, I need guidance on the following: How to extract approval workflow information (e.g., approval status, approvers, workflow stages) from OTBI How to include user roles or job…
-
vets reporting
-
Update “Contact Us” Section Contact Details in Journeys Checklist Template
Hi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currently, we can only control whether this section is hidden or displayed. However, we would like to update it to display different contact details instead. Where…
-
Element entry name filter removing employees without element entry in OTBI
Hi All, Trying to have a single OTBI report including subject areas Worker real time and element entries real time. When we add filter for element name, it will remove employees without element entries. Tried adding an Or condition to include employees with element name is null. Still not picking employees without element…
-
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?
-
“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…
-
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.
