-
OTBI Fetches Different Results when compared to UI
Hello , I have a requirement to fetch the Requisition Numbers & Recruiter Full Name in the Analysis and for that I have used both 1. Recruiting - Recruiting Real Time 2. Recruiting - Recruiting Events Real Time The results are not matching the UI .
-
Union (merge) 2 columns into one
I am building an analysis in the Recruiting – Recruiting Real Time subject area to report on Candidate Interactions. Interactions can be recorded in 2 different places: in the candidate profile (the data is located in "Candidate – Interactions" folder) and in the job application (the data is located in "Job Application –…
-
How would a new column be generated in the analysis result
How would a new column be generated in the analysis result that would be based on two other existing columns/prompted input (i.e calculating number of days between effective start date and effective end date and then recording the difference as number of days in the new column)?
-
Hi I am creating an Otbi and the data coming in Otbi is different from the UI in the oracle fusion.
Hi I am creating an Otbi and the data coming in Otbi is different from the UI in the oracle fusion. The subject area i am using is Project Costing - Actual cost real time
-
API Run report NO DISPONIBLE
Hola, estoy tratando de hacer una conexion mediante una API para envía una solicitud al servidor de Oracle BI Publisher para ejecutar un informe específico. pero me marca el error 404, sin importar los cambios que realice me sigue marcando el mismo error , estoy usando oracle fudion cloud.…
-
Unable to retrieve Department and Office Location for Affected Person from Case Management subject a
Description: The customer is unable to retrieve the Department and Office Location attributes for the Affected Person within Oracle Analytics reporting. We attempted to join the Case Management subject area (Table A) with the Workforce Management subject area (Table B) using the available common dimensions. The join…
-
Finding DFF field in HCM OTBI Subject Area
Good afternoon. We have added values to this HCM table/field, HRT_PROFILE_ITEMS.ATTRIBUTE1 as a DFF that we need to add to our OTBI reports. We have followed the required steps of checking the BI enabled box, deploying the DFF and running the "Import Oracle Fusion Data Extensions For Transactional Business Intelligence"…
-
Training Suppliers Details OTBI report not providing all the data in the UI
Hi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through the OTBI report is less when compared to the UI export report. Navigation for UI: My Client Groups > Learning > Training Suppliers OTBI Report Criteria…
-
FDI attributes without Start & End date included
When creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other required attributes) are not included. This makes these attributes unusable as we cannot determine which row is accurate for each employee. What is the…
-
Access run history & older report outputs of OTBI scheduled reports
Hi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output of each run for a scheduled OTBI report? In our older HCM Peoplesoft system, there used to be 'Process Monitor' which used to let us access run history &…
-
Employee Address Historical Data
Hi! How can I create an OTBI analysis that displays an employee’s full home address history, rather than only their current home address?
-
OTBI Dashboard : How to enable Export to Excel for seeded L1 reports?
We built a new OTBI dashboard by copying a seeded OTBI dashboard and added an L0 KPI graph. Business requirement: when a user clicks the L0 KPI and navigates (drills) to the L1 report, they need to export the L1 data to Excel for further analysis. Issue: the Export option is not available on the seeded L1 report page. Has…
-
Drill down from OTBI adhoc report to Expense Report
I am trying to create an action link in an otbi report related to expense report info. Currently the action link is attached to the report number field- but apparently there's a known problem with doing that and I've been advised to use expense report id instead of report number. I'm also following directions from oracle…
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real Time
I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their last salary information. I can get the terminated employees to pull, but as soon as I start adding columns related to salary (salary facts), it is not consistently…
-
Email Update and Add Email
Hi Expert, Looking an HDL where we can add and update the work email through HDL. Thank you!
-
How to extract and update fusion approval groups via get API request or any other web services
I am building a web application to be integrated with Oracle Fusion. One of the key data I need is the approval groups that are defined in the BPM worklist. Is there a way to pull and post this data directly from the fusion?
-
What is the maximum number of rows that an OTBI report can fetch correctly
I am trying to write an OTBI report from Fusiuon on Payables and I am seeing some incorrect values on invoice amount and few other fields. I am not sure if it is because the total number of records is higher. Is there an Oracle specified limitation on OTBI report data vloumes.
-
How to extract the information of fusion approval groups via report or web-service
Summary read approval groups information and extract to be used outside SaaS Content We have managed to develop approval groups in SaaS like the attached document, And since we are developing a PaaS extension We need to check the do-ability of reading such information and extract it in PaaS, reading the approval groups in…
-
setup printer with oracle fusion cloud
hi we need to setup zebra Industrial Label Printer which is configured in our on-prem network, we need to setup it in oracle fusion application to print label and barcode. we need to know how to configure it with oracle fusion cloud. Regards Mohamed
-
OTBI Analysis, Join Project Number to Contract Agreement Amount
Hello, New Reporting analyst here. I'm trying to build a report to group together the agreements and contracts by project. I would like to know if I can join the following without going to BIP. Project Number to Contract Agreement Amount and Release Amount I believe Project number is from "Procurement - Purchasing Real…
-
Generate QR code along with logo at the center in rtf template.
Hi All, There is a requirement to embed the image(logo) at the center in QR code. How we can generate QR code along with logo at the center in rtf template. I have attached the sample qr code.
-
View and Layout in OTBI
Hi, Is there any document / video which shows how to make changes in a view and in a layout and the relationship between the two. Also, is there a way to make changes to the view, without the query running in the backround ?
-
Trail Balance Dashboard – Scenario LOV Issue
The client has highlighted that in the DEV2 instance, the Scenario prompt in the Trail Balance dashboard is not returning any values. On review, the General Ledger subject area in DEV2 does not expose the Scenario column, which explains why the LOV remains empty. In the TEST instance, however, the Scenario column is…
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI Reports
Summary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM UI i.e.(Person Management) but when the same user accesses OTBI and choose any subject areas and creates an Analysis i.e.(Report), He gets all the data in…
-
Is BI Administrator role alone sufficient to access all reporting data in OTBI ?
If a user already has the BI Administrator role in SaaS Fusion, do they still need additional data roles along with AP Manager or GL Manager to view data in OTBI reports? Or is the BI Administrator role alone sufficient to access all reporting data?
-
Is there any way to put the OTBI Dashboard in the analytic area?
Is there any way to put the OTBI Dashboard in the analytic area? or any place to avoid user to go to the Tools>Reports and Analytic? Something that a user can select from the main page.
-
How to view an OOTB report in OTBI?
Hi experts, i am trying to open/view the report from OTBI, but the open field is greyed out and when i try to edit and click on view report to open it - nothing is happening. i have all the roles. Please help me out Thanks, Srikar
-
Business requirement to convert PST time to UTC time in collaboration messaging
one of the vender using collaboration messaging to post the ASN IN messages. They have special requirement to convert date time from PST to UTC time zone. They suggested to use this in collaboration messaging <xsl:variable name="UTC-date"…
-
Hiring manager and recruiter's full names not displayed in anaylsis
Hello experts, we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear front end in the system, but not in the analysis, theire field are empty for all the job requisitions. Does anyone know why and how can we fix this issue?…
-
Analysis Workshop
Information or courses on AW OLAP
