-
How do I add a new value for a table prompt in OTBI?
In OTBI, I have a table prompt that only displays individual options and not an "All" option. I added an "All" option by manually selecting all the Journeys available. I want to be able to do this with a formula so that it dynamically adds all the values in case in the future there are new values. How can I do this?
-
How to translate the data in a BIP Report to another language?
We have created a BIP Report where English(en-US) is the default language. We want the data as well of the BIP Report to be translated to another language(Specifically SPANISH). One method that we have tried is by Exporting Translation from the Properties(XLIFF File) and importing it back. But the thing that we have…
-
How to Access OTBI report using Groovy within Oracle Fusion
How to Access OTBI report using Groovy within Oracle Fusion
-
Need translated names in the otbi report.
we have developed otbi report for Workforce Structure for one of the UAE client, in that customer requires translated names to be reflected along with the English names. Please find the screenshot attached for your reference. Can this be achievable through otbi or not? Please confirm
-
Merging 2 PVOs for 1 BICC Extract
Hello Team, Can we merge 2 PVO to create a single extract for BICC. Currenly we tried and it is giving 2 extracts. Any guidance would be helpful. Regards,
-
Projects - Performance Reporting Real Time
Here In above report I am trying to print class category column values as a separate column like GP Budget,GP Plan Year and GP Project Category. also want to print the value of column class code in it. Is It possible in OTBI, please comfirm.
-
How to navigate to fusion Sales Order page from otbi analysis aggregated field
We are trying to develop an OTBI report showing past due orders as a bar graph with range of days and count of orders in that range. Requirement is to click on 'count of orders' bar for a range and it should take to fusion page listing all those orders so user can open any of those orders and take action on it.
-
Dashboard For Procurement & Inventory
Do You Have Any Ideas of Dashboard For Procurement & Inventory aside from Standard Ones ? Like questions need to be answered by Dashboard what kind of operations can be monitored Thanks
-
Can i create custom heading in OTBI report?
This is an example of what i want to achieve the first image is created in excel, the second is in OTBI can we have Custom Header like in excel. Regards, Omran
-
OTBI Expression not working
Hello, We're creating an OTBI report that fetch employees time card details. Please see below requirements If employee did not work on a holiday, it should return 'PH' If employee worked on a holiday, it should return the number of reported hours. We already completed the number one requirement. However, we can't still…
-
Translated balances should be excluded from the OTBI report using GL-Balances real time subject area
Translated balances are getting summed up in the OTBI report generated using "General Ledger- Balances Real Time" Subject area when using the Period Net Activity column as measure. The column which is needed to filter the translated balances and excluded from the report is available in "General Ledger- Transactional…
-
UK PAYE Scheme Reference Number Location
I am attempting to output the PAYE Scheme Reference from the Payroll - Calculation Cards Real Time Subject Area but am unable to locate the column header. Can anyone advise please?
-
Time Series Calculations - Using a Count Measure for YTD
Hello all, I'm attempting to create a measure using the time series calculation of TODATE to achieve YTD numbers. For example, if I need to achieve YTD invoice amounts the function of TODATE("- Invoice Amounts"."Invoice Amount","Fiscal Calendar"."Date - Fiscal Calendar"."Fiscal Year" ) works great. However, if I'm using a…
-
Setup IBAN for EMEA population in Oracle
Summary: We need to setup Banking Info within Oracle and unsure how to set this up for the EMEA population using “IBAN”. Can anyone guide me the process do the same? Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…
-
Copying multiple OTBI Reports
Summary: Copying multiple OTBI Reports Content (please ensure you mask any confidential information): Hi All, Please suggest if this is feasible i.e. to copy multiple (200+) OTBI Reports in the same environment - as there is a need to rename the copied reports and the n use the modified version of the same by making the…
-
OBTI report for Maintenance program
For a Maintenance Program forecast i want to make a OTBI report that anyone can easily understand the activities. The built-in Program Gannt chart is very difficult to understand as seen below. can anyone help me with making customized OTBI report for maintenance program.
-
Simplest programmatic way of scheduling BI Publisher jobs in Fusion Financials
Summary: Any light touch report scripted report submission tools that can be used with Fusion Financials for BI Publisher scheduled job submission Content (please ensure you mask any confidential information): I'm looking for the simplest means of batch scripting a number of BI Publisher jobs, is SOAP still the only…
-
Language Report
I had created a roster report for employees to run which will generate a list of employees and the language that they speak in case they need a translator. However, I am unable to run the report when testing as an employee. Oracle suggest that the role Human Resources Analyst is required for the Workforce Profiles - Person…
-
Generate report for Transactional tables in AP
I want to create a data extract for transactional tables (AP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALL etc). I cannot find the Views for these tables in Financials to select all columns. Is there any alternative way to write the SQL query without having to manually write each column?
-
I am trying to build an OTBI report that shows PRS with the status
I am trying to build an OTBI report that shows PRS with the status, if it's pending approval i need the name of the current assignee Is it applicable by OTBI ?
-
Where to find Postgraduate Loan Information
I am attempting to extract Postgraduate Loan information in OTBI and have gone through every header (and some contents) in the Subject Area Payroll - Calculation Cards Real Time - . I only found the following: - Do you have a postgraduate loan Finished postgraduate studies before last 6 April Repaying postgraduate loan…
-
Creating Custom PVO's on oracle fusion custom tables for BICC jobs
Is there any process to create Custom PVO's on oracle fusion custom tables to export data using BICC connector. If yes, what are permission roles required to develop.
-
OTBI General Ledger Transactional Balances Real Time Missing Transactions
I created an analysis from General Ledger Transactional Balances Real Time and the current FY is missing amounts. Prior years show the correct info, and if I recreate the analysis in General Ledger Balances Real Time and it shows all the data I expect. Does anyone know why the current FY is missing info but the prior years…
-
OTBI Analysis for history records
Hi Team, Is it possible to create a dashboard in OTBI analysis where I need to check the transfers, promoations, location changes happened in the last 12 months every month count. Is it possible to get the history records in OTBI records ? Regards, Hari
-
Is there a way to report on all salary simple components on one line of an OTBI report?
I need to be able to have a report with one line per employee with different columns for each salary simple component amount. Is this possible? I've searched the community and looked at many sample reports but they all have the components on separate lines
-
How to add a new columns in OTBI subject area?
Hi Team, How do we add a new column in the OTBI subject area not present in the existing model?
-
Date format parameter on excel report
Hi I have an OTBI report with excel template; on the template there are 2 parameters that contain date inserted from user. The date format of the parameter is : dd-MM-yyyy but when it is printed on the excel it comes out with the format (iso 1860): ie. 2023-12-25T00:00:00.000+00:00 Is there a way to change this forma…
-
Can we restrict an OTBI Analysis report so that only users with a specific role can run it?
Is there a way to set permissions on an OTBI Analysis report so that only users with a specific role. Example We have used the Subject Area Project Costing - Unprocessed Transactions Real Time, and we want to restrict access so that only users with the Project Finance Role can run this.
-
I need to make a report in OTBI that only shows information for its AOR
I have a report that shows the salary history of the employees, which should work for a custom role that we have in the company, which works through the areas of responsibility, but when the client executes said report, it It shows information about all the company's collaborators, the role already has a security profile,…
-
Seeded Report to track User's last login in Oracle Fusion 24C
Hi Team, Is there any Seeded Report to track User's last login in Oracle Fusion 24C? Appreciate your responses.
