OTBI
Discussion List
-
How to create an OTBI report to show SO to AR flow?Summary: How to create an OTBI report to show SO to AR flow? I need SO Line info like Status and AR transactions details. Content (required): Version (include the versio… -
How to identify when a person no longer sits within a person criteria for a Learning InitiativeSummary: We have a requirement to identify when a person no longer sits within a person criteria for a Learning Initiative (although they have completed the training) an…
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows SCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …Ibrar Hussain 41 views 1 comment 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Expense Line DFF specific to BU or Expense TemplateContent Hi, We are looking for an option to capture additional information using a DFF, however, we need the DFF to be only available for a certain Business Unit and/or … -
OTBI Report in Workforce Goals - Goal Status Overview Real Time, Unable to add Organization LevelsI am building an OTBI report in a single subject area (Workforce Goals - Goal Status Overview Real Time). I am able to add Development Goals details from the "Developmen…rd17 141 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 61 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI - Pivot with multiple information types (Email Type, Phone Type)Content Hi, We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and P…User_KOLMZ 99 views 3 comments 2 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
when i try to schedule the report through agent in condtion section when test its show false why?Summary: Hi Team, when i try to schedule theOTB report through agent in condtion section when test the condtion its show false why? Please help me on ? Thanks, Ajay Cont…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What subject area to use to return result for requisition "use" fieldSummary: Trying to report on the requisition "use" field; see screenshot below, but unsure of which subject area this may be housed in? Content (required): Trying to rep…Cheryl Calsetta 31 views 1 comment 0 points Most recent by Cheryl Calsetta Reporting and Analytics for HCM -
Why can't I see DFF's in OTBI?Summary: Content (required): I have run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence schedule process and it succeeded, but I am stil…
-
Asset Changes Last Update DateSummary: Is there a specific table that shows a last update date for any asset changes? Content (required): We are trying to pull data for an integration for any changes… -
Need help connecting Transaction Data to Workforce Management DataSummary: I need to create a report connecting the following subject areas: Human Capital Management - Approval Notification Archive Real Time to Workforce Management - W…Jose Guerra 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mail notification sending and limitHi, Can a special mail extension be used in notifications prepared as bursting and sent via email? For example, it should only go to people whose e-mail is @aaa.com.tr ?…Cansel Karasoy 31 views 2 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM -
Getting Worker details in LearnSummary: Learner worker details not available in Learning Records real time SA Content (required): Hello , We want to know assignment details of Learner which is not ava…
-
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…
-
Reporting on Holiday Entitlement and Remaining BalanceHi all, Is it possible to report on total holiday entitlement as one combined field (factoring in employees carry over, annual accrual and other adjustments) within OTBI…
-
Can we show OTM data in OTBISummary: Dear all, We were asked to evaluate the connectivity between OTM and OTBI. I.e., can we create a report in OTM FTI and call that in OTBI Content (required): NA …
-
Audit ability for OTBI fields and BIPSummary: Is there any ability to audit on who has created and run a BIP report or OTBI analysis that include specific folders/fields such as from Workforce Management - … -
'Seniority Day' field is having incorrect data in new V3 subject area.Summary: Steps to replicate the issue - We created the OTBI report to fetch 'Seniority dates' and 'Seniority days' from V3 subject area ‘Workforce Management - Person Se…User_2025-07-18-06-45-42-477 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 312 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
Assigned the offering to new learner and the status changed to not started to In progressSummary: Content (required): Hi Expert, We have assigned an offering to the learner, the it should show not started, but for some learners it is showing not started and …
-
Not Able pull the Latest Location from "Workforce Management - Worker Assignment Real Time" subjectSummary: Hi, We created the new location and running the OTBI to get the data from subject area "Workforce Management - Worker Assignment Real Time" and has employee det…Kiran Kollamsetti 11 views 2 comments 0 points Most recent by Kiran Kollamsetti Reporting and Analytics for HCM
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…Noelle Bartlam-Oracle 91 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 71 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 61 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM