OTBI
Discussion List
-
OTBI Agent generating report errorSummary: I built a new agent and it is set up to run as another user with full permissions. For some reason, every time it processes at its scheduled time, it appears to… -
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …Barile Alberto 21 views 3 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Restrict search of labor costs by person in OTBISummary: Southern Company has a need to restrict most employees with access to project costing labor costs details. A user can search through OTBI subject areas project … -
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…OsborneT 21 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Adding external learning approvers nameSummary: I need to add external learning approvers and status in OTBI. We are unable to find the correct columns for this. If anyone has worked on it, kindly help or pro…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 81 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…Henry Imgrund 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a…Cansel Karasoy 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Implications for deleting an attachment entity from Attachment CategorySummary What is the downside to deleting an attachment entity from a custom Attachment CategoryContent Hello, We have a custom attachment category with the Item and Item…User_2025-02-04-16-34-29-464 29 views 3 comments 0 points Most recent by Avijit Vidyarthi Product Master Data Management -
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'…Karen Florig 575 views 4 comments 0 points Most recent by Durga Prasad Tavva Reporting and Analytics for HCM -
The specified criteria didn't result in any data for Inventory transaction real timeSummary: receiving result "The specified criteria didn't result in any data" User has a custom role that has been assigned "Inventory Transaction Analysis Duty" and has …Joe B 31 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od…
-
HCM Experience Design Studio ReportSummary HCM Experience Design Studio ReportContent Does anyone know if there is a Subject Area or Table that contains the Rules created in the HCM Experience Design Stud…User_2025-01-23-21-24-21-434 79 views 9 comments 4 points Most recent by HRIS_EC Reporting and Analytics for HCM
-
How to put image as a background and create a birthday report?Summary: How to create a birthday card which need to put image as a background and make it staff name and birth date appear on top of the image?
-
Serial Numbers not picking in the reportWith a series of old transaction IDs. We need the data for each transaction to be extracted and displayed individually in the EBR report because we need this information…
-
DFF in manage Lot page not appearing in subject areaSummary: In OTBI Analysis we want to show lot number with the Descriptive flex fields in additional information. DFFs are deployed successfully and BI Enabled is checked…
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p…Clare Murtagh 1 view 2 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for HCM -
Subject Areas for Employee dataSummary: I am trying to create a report of the employees in Fusion (we don't use HCM), but I can't get the data out of the system. I can see the worker's name and primar…Jeroen VW 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
OTL - Workforce Management - Reported Time Cards Real Time subject area missing entriesSummary: The subject area Workforce Management - Reported Time Cards Real Time does not return accurate time entries when we try to query the custom attributes from the …
-
Multiple Proficiency Level records per Competency HCMSummary: We have multiple Proficiency Level rows per Competency. It is not clear which proficiency level in the report is the correct one. We expect the report to show o…
-
Workforce Management - Worker Assignment Realtime, Work Assignment, FTE returns >1 incorrectlySummary: The attached analysis returns an FTE value greater than 1 for 49 records. We believe the calculation for FTE should be FTE = ((standard hours * headcount) / nor…David Boudreau 41 views 5 comments 0 points Most recent by Dan_Hinsley Reporting and Analytics for HCM
-
Natural Account (SEGMENT2) Description on a custom reportSummary: Hello, We have built a custom report to compare the FA SLA balances to GL which contains an account column but which GL table do we use to include the account d… -
Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to …