-
Combining Project cost (Subject area) with General Ledger - Journals Real Time
Has anyone ever successfully created an OTBI report with Project - Costing Real Time and General Ledger - Journals Real time? Having some issues with the values. Thanks
-
how to get marital status change date field in OTBI analysis
how to get marital status change date field in OTBI analysis
-
Unable to deliver an email with HTML content as attachment via OTBI agent
Hi all, I created an analysis and want to set up an agent to send out the output via scheduled email. Under delivery content, I select the format as csv and deliver as attachment (since I want to send the report out as attachment), I cannot send the email body with html format. All the email contents are presented as plain…
-
I wish to store files created in BIPublisher within WCC.
Store the CSV file output from BIPublisher in WCC. When doing so, I wish to specify an account, but how should I specify it? ※ I understand it is possible to specify accounts such as ‘prc/supplier/import’, but when setting parameter4 to ‘prc/supplier/import’ in the BIPublisher bursting definition, a phenomenon occurs where…
-
Is Multiple Data Sets Creation supported for BI Bursting
Summary Multiple Data Sets in BI Bursting Content This is with reference to Oracle Fusion HCM Applications Say we want to have a report which would hold Person Details as one Data Set (Parent) and Email Address (Child Data Set). We then need to burst the Data to a SFTP Folder Can we do this , if so please help with a…
-
How to change the print template for OTBI - Analysis ?
Here is the step about this quesiton Open OTBI Analysis , click Print -(Printable PDF / Printable HTML) , the page will display the table data and additional title (Like company logo and company name) My question is how to change the company name in print page, We try to find the "Print Option" in here Analysis - Result…
-
Requisition DFF not appearing
we have BI enabled DFF at requisition distribution level for capturing project information which has been using for several years but it was not BI enabled recently we have Bi enabled it and run ESS job as well , but cannot find in requisition real time subject area , at setup and maintenance deployment status showing…
-
HCM - OTBI report no results when joining Goals with Checklists SA
Hello, We have an OTBI report to display employment data, Performance goals data and answers to a questionnaire used in check-in. We are using following subject areas: Workforce Management - Worker Assignment Real Time Workforce Goals - Goal Status Overview Real Time "Workforce Management - Checklist Real Time —> Checklist…
-
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…
-
How can a senior manager see information on people who have left the organisation?
We have come across an interesting problem; a difference between what a line manager can see versus what an HR Professional can see. If an analytic (based on assignments) is run by a Line Manager to see information about people who have left in the preceding 6 months (or other previous period) the analytic returns little…
-
Need 'UOM Conversion details' in Subject area
OTBI dashboard is being developed for CSRs to view the availability of items in different UOMs with their conversion factors UOM conversions exist in the application, however unable to view inter/intraclass conversion details in OTBI Subject area. Need to know is there any subject area available to view UOM Conversion…
-
Need 'PO First Approved Date' in the OTBI Subject Area
Please guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved date” but showing in header report "Approved date" without mentioning it is the ‘PO last approved date’.Since it is not clear hence confusing everyone and…
-
How can I give the subject area access in OTBI to a user from fusion ?
I'm doing data validation in FDI , and found that I'm getting SOAP server error for HCM - Talent Acquisition related metrics. and I'm getting SRC value null for HCM - Workforce Absence Management related metrics (instead of soap error) What does it mean , how Can i give access to these 2 subject areas to my user in Fusion ?
-
Fixed Assets - Columns: "Net Book Value" vs "NBV Before Impairment"
We are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: The 23B Data Lineage spreadsheet for Financials indicates that Net Book Value should exist in Fixed Assets - Transactions Real Time > Impairment Details, but we do not…
-
Filter with an OR condition
I have two fields: Field A and Field B I want to pull all records, which may have value 'SPLTAG' in either of the two columns. How do I create a combination filter across two columns ?
-
Create custom app tile for OTBI Dashboard
We created a dashboard that is used by Recruiters. They access this by going to Tools → My Reports → and navigating to the appropriate tab. I was wondering if it is possible to create a custom app tile for an OTBI dashboard where the Recruiters can click on that takes them to this dashboard. If so, where would I find…
-
Need 'PO First Approved Date' in the OTBI Subject Area
Please guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved date” but showing in header report "Approved date" without mentioning it is the ‘PO last approved date’.Since it is not clear hence confusing everyone and…
-
Sick absence duration sum issue
Hello, I'm trying to produce an analysis showing total days lost to sickness per quarter for each department. I'm working in the Workforce Management - Absence Real Time subject area, I have filtered by department and have added time.calendar quarter end date as a column, and assignment absences details.duartion. When I…
-
How can I improve report performance?
-
Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?
Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Receive Expected Shipments page?
-
Issue on exporting entire dashboard
I’m currently experiencing an issue when trying to export the entire dashboard to Excel. The export function only allows a maximum of 500 records to be displayed and exported, but I need to extract all the results from the dashboard. Can anyone please advise if there’s a workaround or configuration setting that would allow…
-
FDI People Leaders Dashboard issue
In the FDI People Leaders dashboards, on the Hires and Terminations pages, the graphs for Hiring Trend by Gender and Termination Trend by Gender, as well as the Hiring Predictions for the Next Three Months and Termination Predictions for the Next Three Months, are not displaying the correct hiring or termination…
-
Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing Page
Summary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited suppliers, awarded amounts, savings)? Content (please ensure you mask any confidential information): In 25C, the Redwood Sourcing Landing Page allows…
-
Time Card Status
Hi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying to add the BEFORE CHANGE and AFTER CHANGE status. However, I cannot find any table which has the columns I need. I am currently using the…
-
report dates parameters not incremented
Hi, I defined a Data Model, with DATE FROM/DATE TO as parameters, in the following way: p_date_from: {$SYSDATE() - 7$} p_date_to: {$SYSDATE()$} Then I created a report using above Data Model and scheduled it daily, but above dates are not incremented and output is always referring to the original dates. Please suggest how…
-
Retrieve records for Supplier Audit reports in Oracle
Hi I am trying to find below attributes from the Tools- Audit reports from UI but not able to find the table and attributes for Supplier Audit report. Please advise!
-
How to Automatically Refresh Dashboard in OTBI?
Hi Gurus, We have an operational dashboard build which is displayed on the Production Floor. Is there a way to make it auto-refresh. We have observed that user need to always click Refresh hyperlink to get the realtime data.
-
ESS Job, Including the there future run time, Analytics and Pre-build Subject area required
Hi, I need to have details about the ESS process name, and there schedule time interval and next run analytics report. Need to monitor the schedule process. Thanks and regards Sandeep
-
Headcount filter by quarter end date too low and jumps around
I want to report on headcount and FTE (also by age, grade etc.) for each department over the past 10 or so reporting/fiscal quarters. I am running an Analysis in OTBI, using the subject area: Workforce Management - Worker Assignment Event Real Time I have the variables: "Department"."Department Name" (filtered to a single…
-
Function WITH clause is not working in BI Publisher report. ORA-32034: Unsupported Use Of WITH Cla
Hello Expert , In the TEST instance only, we encounter a problem with some BIP reports. The same report works as expected in the PROD instance. According to my analysis, this problem only occurs when we use WITH FUNCTION in the data model. the Data model works , issue with report only
