OTBI
Discussion List
-
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 51 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod…Pam Koertshuis 406 views 3 comments 2 points Most recent by Manju Chugani Reporting and Analytics for ERP -
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp… -
How to create Budget vs Actual and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI)Summary: Sub Analysis & Activity Hierarchy Info not available in General Ledger Subject area (OTBI) Content (required): We are working on OTBI Customization reports on G…Sreedhar Reddy palle 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Can we create OTBI report using multiple subject areas ?Summary: Can we create OTBI report using multiple subject areas ? Content (required): Is there any confirmed dimension in below given GL subject areas in OTBI, can you p…Sreedhar Reddy palle 41 views 3 comments 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Need to pass real time binding parameter dynamically to OTBI Reports.Summary: I have created OTBI Analysis report based on the Compensation -Workforce Compensation Real Time subject area. I have attached my OTBI report to View report sect…
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Count number of employees submitted response in PERSON EFF (OTBI Count)Hi All, We have developed a Person EFF, and we require an OTBI report that can count the number of employees who submitted their response in the Person EFF (Self Identif…Ashok Kumar Sharma 101 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Prompts are not currently supported for analysis that combine criteria.Summary: Combined two SA i.e Projects Billing - Revenue Real Time + Project Performance Reporting Real time and want to have 'Project name' as Prompt Value and it is not… -
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
Candidate Report with Sensitive DataSummary: Can we get a Candidate Report (Recruiting - Recruiting Real Time) that provides the DOB & last 4 of the National Identifier/Social Security Number for those tha…SUSAN SANDIFER 71 views 4 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
Field names in several subject areas are changed. Where to find this in documentsSummary: Field names in several subject areas seem to have been changed as a result of 23B release. We've reviewed the documents and can see no mention of this in any of…Sudhan-Oracle 11 views 2 comments 1 point Most recent by Catherine Raes Reporting and Analytics for SCM
-
OTBI Data.Summary: Hi Team, We are not getting any data in worker assignments realtime. Do we need to run any process? In front-end I can see all employees. and this happens our i…
-
how to purge data files from ucm server for Import Payables programSummary: We have around 2000 datafiles appearing in datafiles Lov while submitting Load Interface File for Import program. Attaching the screenshot where the datafiles c…Sachin Kr Singh 31 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 192 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily Robinson 185 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
OTBI AgentsWe have OTBI reports with more than 25000 rows (Approx 250000). To transfer data, we need to split them up into 10 to 15 agents by employee's name character or Person nu…Ashok Kumar Sharma 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI…Jeff Hare CPA CISA CIA 84 views 6 comments 0 points Most recent by Bianca Lei Villareal Reporting and Analytics for ERP