-
In Sales CRM, Custom Fields from Custom object are not visible in OTBI Subject Area.
Hi, In Sales Opportunities, we have created fields in Custom child objects, but those fields are not getting captured in any Sales CRM Related subject areas. We have used Sales - CRM Opportunities and Products Real Time subject area, but unable to find the custom fields created. I have attached the screenshot of the Custom…
-
Need to Group by the Column based on data from 2 different Subject areas in OTBI
Hi Team, I am creating a OTBI report, and it is basically a Payroll Reconcillation Dashboard, it is having lots of details, one potion is having the details about the salary elements and their pay value. Below is the snip, this is what I want to create. This sample I created with Excel. I want to create the same in the…
-
Scheduled Report does not show all values
Hi We have been experiencing issues. A scheduled report does not include calculated column values which show in OTBI directly or when the report is exported, or scheduler is run manually. They dissapear when the agent is left to run automatically. Screenshot of the export with the values Screenshot of the report with…
-
Can I run the OTBI thru ESS jobs
-
Guidance on Fixed Assets and how to get YTD depreciation figures
Hi, I am trying to recreate the date from the Asset Inquiry screen (screenshot below) but am struggling where to start. I can see three subject areas related to Fixed Assets and would assume that the data below would be held in the Asset Depreciation Real Time subject area. The other two subject areas are Asset…
-
data is sometimes not actual. I have to delete the browser chache. how can I prevent this
-
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…
-
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…
-
New to Oracle Fusion and not sure how to grant users to OTBI
-
Purpose of the report parameter _linkToReport
In a report you can choose to share a report link. This will bring up a link which you can copy. This provides a link with a parameter at the end _linkToReport=true. I would like understand what this parameter does? Changing it to false, I do not see any changes and thus would like to drop it in particular as it sometimes…
-
Migration of FR reports
Hi, I want to use How To Move FR Reports Between Environments (Doc ID 2024010.1) process to migrate FRS reports between environments but I have two doubts I need confirmation on from anyome who has used this. the report details how to migrate reports under /shared folders/custom/financials - my question is if you had a…
-
Generate SQL query using Oracle tables when the OTBI subject area is part of the BI Publisher DM
We have a BI Publisher report. The current report data model includes: one dataset based on an OTBI subject area other datasets based on Oracle standard tables We need Oracle’s help to obtain the complete query from Administration > Manage Sessions and identify the equivalent query using only Oracle standard tables. Our…
-
Deep Links (23B) the complete overview (all of them)
We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactional Business Intelligence There's a kind of (a not very informative) overview in the 'Deep links' page in Fusion Apps (under Tools) I composed attached…
-
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.…
-
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?
