-
Can You Create a Report of Time Card Statuses and Approvers in OTBI?
Summary: Need a report for workers with multiple supervisors to see which supervisors still need to approve a worker's time card and which ones have already done so. Content (please ensure you mask any confidential information): Has there been any updates on the KM document, "Fusion Time and Labor: Need Report on current…
-
BI Publisher Excel Template
Content Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how to workaround this isse when nesting multiple groups in Excel? Thanks,
-
For OBTI reports with excel template getting " rowMark="2 in fields when creating nested loops
When trying to create a excel output OBTI report with a data model (sample xml attached) the fields in the parent group is showing " rowMark="2 after each field value. How do we remove this? The xml sample data, the excel template and the output is attached.
-
What is the OTBI Subject Area for State Wise Minimum Wage?
Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. Please find below the UI screenshot for reference. Thanks, Ramya
-
Example of operation "uploadReportDataChunk" for SOAP service ReportService
Hello we are trying to call "uploadReportDataChunk" operation in order to load an XML to OTBI server, then call operation "runReport" with paramerter fileDataSource/dynamicDataSourcePath populated with the reference to the file. I cannot understand the correct value to use: Upload Data Chunk payload request…
-
How to cancel schedule of OTBI Agent of users who scheduled under their personal folders?
Few OTBI reports have been scheduled by users under their folders and now they are no longer a part of the organization but the reports still seem to be running with their user. How can be disable the schedule of these OTBI agents?
-
Formula Expression values are processed differently when selecting different system language NL-ENG
Currently, our report transforms column A to Column B by using a Case - when - then setup. For example, Case when column A = 'Value_1' then 'Value X' when Column A = 'Value_2' then 'Value Y' Interestingly, when we change the system (user) language from NL to ENG there is a different behaviour by the system. Namely, the…
-
Does OTBI run on live transactional database
Hi, Would like to know if OTBI subject areas run on live transactional database? sometimes I have observed, there is some delay in results after performing transactions. Thanks.
-
Issue with Configuring LOV Source for Validation Status in Scheduled Process - JBO-27120 Error
I'm encountering difficulties while configuring a List of Values (LOV) source for the 'Validation Status' parameter in a scheduled process within Oracle Fusion Payables. Despite following the guidelines provided in Oracle documentation and trying various SQL query formats, I am consistently receiving a 'JBO-27120' error…
-
Secured BI Publisher with asignment based AoR Security
Hi, I created a BI Publisher report that are based on the secured view PER_ASSIGNMENT_SECURED_LIST_V and assigned the privilege "Report Assignment" to the user's custom role. The data security should be based on the User AoR that is applied to the assignment level. But for workers with multi-assignments, all the…
-
Current Year Promotion Report
I want to get the promotions of current year in OTBI report, I am getting it but the if there is any action after promotion then system is not picking that employee record. For example: If this year there are 3 employees who got promoted on 1st of Feb 2025. The report is picking 3 employees records. which is correct. If…
-
How to restrict OTBI reports data not to send to external mail ids
Users are able to access and schedule OTBI reports. We want to restrict not to send users to external email domains other than organization domains.
-
Global Transfers New form is not populating in Workforce Performance - Performance Rating Real Time
We recently had a employee transfer from one county to another in our organization, which is treated similar to a termination and re-hire when you look at the data. On the employees Performance page in the HCM I can see that they have two performance forms, one tied to the inactive business title and a new one tied to the…
-
Which Table Stores Parent-Child Relationship of Account Hierarchy in Oracle Fusion?
Hi, I have created an account hierarchy in Oracle Fusion GL to define parent and child accounts. I’m using FND_FLEX_VALUES_VL for account segment details, but where does Fusion store the parent-child relationship data that defines which child belongs under which parent in this hierarchy? Could you please tell me the exact…
-
Embed BIP Report with URL on page (HTML) and have parameters
Summary Embed BIP Report with URL on page (HTML) and have parameters Content Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe and URL. <iframe…
-
Error Code MDNKPKP5
What is Error Code MDNKPKP5? We have a dashboard with tiles, tables, and charts. The default dashboard prompt is Year = 2026. The view with tiles at the top runs successfully as do all other reports/views. Change the prompt to Year = 2025 and we get Error Code MDNKPKP5 for the tiles but not the other reports. Change the…
-
Reporting on goal plan details within a the Setup of Goals Mass Process
Is there a reporting subject area available that will provide me with the details of the goals entered within the Setup of Goals Mass Processes? We are needing to audit these without opening each one.
-
OTBI Usage and Performance Dashboard Sample
Real Time OTBI Usage & Performance Two subject areas are available to monitor OTBI usage and performance: OTBI Usage Real Time: Monitors OTBI usage, including user, analysis and dashboard, and subject area usage trends. OTBI Performance Real Time: Monitors usage trends and OTBI analysis execution time, execution errors,…
-
requirement to change the time zone dynamically in the OTBI analysis filters based on daylight savin
I have a requirement to change the time zone dynamically in the OTBI analysis filters based on daylight saving times. Can someone please help me with a solution. Thank you
-
Error running OTBI report - The user request exceeded the maximum query governing execution time.
There is an OTBI report which gives results when I run using my ID but the same report is giving error - "The user request exceeded the maximum query governing execution time" when we try to run via another user ID. We have also added all the respective subject area duty roles. Please suggest why are we receiving this…
-
In OTBI How to set TIMEZONE using Data format setting properties?
When we change the column properties in the Data Format tab regarding the TIMEZONE, it always reverts to the default setting. We cannot set the timezone as required. The requirement is to remove the 'time' from the "Invoice Creation Date" column and display only the date. To achieve this, I opened the column properties of…
-
Need report that shows all Pending Life events
Hi Team, We are looking for report, wherein pending life events for employees can be listed. Please share inputs to achieve this. Thanks, Pranay
-
Need help on why my data has mutiple rows and how to work around it
I am a supplier registration request analysis and have created a measure colomn for the number of pending approval request. However, there a mutiple rows for the mesaure for a single request number. can you guie how to change this so there is one row for each request number
-
Export of entire dashboard not giving entire data in Oracle Fusion
When we run the entire dashboard in Oracle Fusion with multiple business unit names as parameter value then we're getting the correct output and now after we added one more business unit name in existing parameter and run the same OTBI dashboard then it's showing the correct data in dashboard but when trying to exported…
-
Oracle BI EE
Dear Expert, Could you please confirm how to get the access for Oracle BI EE access. for it's not coming in Drop down. Thank you!
-
Is it possible to create a prompt with description and code to be used for filtering in OTBI Prompts
It is possible to have a prompt for Dashboard where the prompt will display the description (say for example: Payperiod Name) and while user selecting the pay period name from the prompt, the OTBI result should be displayed based on the Payperiod end date(code for the description). Is this possible or is there any way to…
-
Assistance Needed for Implementing Custom CSS in OTBI Reports
I am working on Fusion Application and I want to create a CSS file that I can use for custom styling in my analyses. Specifically, I want to utilize classes from this CSS file in the "Use Custom CSS Class" field of my OTBI reports. I have reviewed the post on the Oracle forums…
-
Add requisitioner email address to purchase order rtf template
We got a requirement to add 'Requesitioner email id to purchase order document. At the moment buyers email id is included in the RTF template
-
Conditionally display text in Narrative View on an Analysis
Hi all, We're using the Narrative View to display the prompts used in the report (Prompt Name and entered Value) on an Analysis, using the standard approach of "Prompt Name: @{value}{All}" we're displaying "Prompt Name: All" if a prompt isn't populated, however is there a way of conditionally not showing the entire line if…
-
How can we remove the gear icon and other access options from a BIP report
Hi, We were able to remove the highlighted details (Refer snippet) from a OTBI report by adjusting the URL but how can we remove the gear icon and other access options from a BIP report.…
