OTBI
Discussion List
-
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o… -
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb… -
How to view Logical Ship and Receive transaction for Dropship ordersSummary: How to view Logical Ship and Receive transaction for Dropship orders Content (please ensure you mask any confidential information): We have a requirement to rec… -
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what…User_2025-01-31-00-25-12-234 29 views 5 comments 1 point Most recent by Neysan Mohajer Reporting and Analytics for HCM -
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and… -
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…User_2025-02-05-16-57-43-236 6 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Fusion Open Purchase Order as on Certain Past DateSummary: Is there a report or a way to build report which will show Open Purchase Order as on Certain Past Date. Content (please ensure you mask any confidential informa… -
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
PPM Control Budget Balance Report RequirementHi, We have multiple requirements from users asking for drilldown of balance shown in Award Overview Page under Control Budget Balances view. So we are trying to develop… -
HCM Auditing/ Audit reportSummary: Hi ALL, We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settin…RamkumarKadhiravan 41 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 41 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service -
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report not match count - Absence ModuleSummary: I built a OTBI report using Workforce Management - Absence Real Time Subject Area, but I noticed in front-end there are 3 Absence Plans for my sample employee b…Joanah 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
CNPJ and Inscrição Estadual (Insc. Est.) on PO Print Output for CommunicationHi, The Brazilian National Registry of Legal Entities (Portuguese: Cadastro Nacional de Pessoas Jurídicas, “CNPJ”) is a nationwide registry of corporations, partnerships… -
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…User_2025-02-07-06-48-26-537 55 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Confirm ReceiptsSummary: Confirm Receipts Content (please ensure you mask any confidential information): How to modify the notification send to requestor when confirm receipts is genera… -
Alert and Work relationship dateHello Experts, We are required to provide our casual employees with a copy of the Fair Work Casual Statement every 12 months based on their service date. Can you please … -
Can we change the row sequence in OTBI reportSummary: I have created an OTBI report, but one of the columns is not displaying in the same sequence as it does on the UI screen. On the UI screen, the column is showin…Vikas V. Kamat 34 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Leavers Work ScheduleSummary: Hello, Is there a way to bring historical leavers Work Schedule and Work Schedule End Date? I am currently using the Workforce Management - Person Real Time sub…Dan_Hinsley 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Inconsistent results in my analysisSummary: Inconsistent results in my analysis Content (please ensure you mask any confidential information): I have this dashboard. If I filter for year 2024 my analysis …Stefano_Mazzocca 31 views 10 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Requisition PDFSummary: Is there an ESS process to run the requisition PDF? We see the BIP report and would like to be able to run it without the View PDF button from the requisition s…MBradley1910 11 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?Anj M. 113 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…Pradnya_Pampatwar 21 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Admin tool or (other method) to identify all OTBI Subject Areas that my company can accessSummary: Is there an admin tool (or other method) to identify all OTBI Subject Areas that my company can access? Content (please ensure you mask any confidential informa…