OTBI
Discussion List
-
All employees who had an active assignment in a time periodSummary Active Assignment within a PeriodContent I need to list all employees who had an active assignment within the last year regardless of there assignment status now…User_2025-01-28-09-44-42-254 49 views 15 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Link Report PagesContent Hi Guys, Is it possible to have the link report pages of a dashboard only in the drill down reports and not in all element of the dashboard? I hope in your answe…Giuseppe Iacono 35 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Import Requisition records are not visible in Manage Requisitions.Content Hi all, We are using Importing Requisitions to import records and ESS job was successful with no errors. But the requisitions are not visible in Manage Requisiti…Harshith E S 72 views 12 comments 2 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
OTBI Report formattingSummary Trying to move data around to get everything in one row.Content I am trying to make each of the phone types its own column so that everything will appear in one …Brittany Lewis 254 views 29 comments 2 points Most recent by Renuka Nuguru-Oracle Reporting and Analytics for HCM -
OTBI reporting on expired approvals/transactions not workingSummary The delivered subject areas do not allow for 'expired' status to be reported upon.Content We have recently configured our approvals to expire after 21 days if th… -
changing the print order in Buyers PDFSummary is it possible to change print order contents on buyers pdfContent Hi, When we print pdf now, it prints in following order overview cover page requirements lines… -
FMLA Absense Report issueSummary FMLA Absense Report issueContent We have build a report in OTBI that would total all of the FMLA Time Off Codes (US FMLA, US FMLA No Pay, US FMLA PTO, US FMLA ST…Shabber Shaik 90 views 16 comments 1 point Most recent by Shabber Shaik Reporting and Analytics for HCM -
Goal Status Report - Capture Associates With and Without Goals CreatedContent We are attempting to create a performance goal tracking report that captures associates who have created goals as well as associates who have not created a goal …User_2025-01-23-23-27-03-729 134 views 6 comments 1 point Most recent by User_2025-01-28-05-32-59-092 Reporting and Analytics for HCM -
Need to count by hierarchy level only the managersSummary Need to create an OTBI analytic which will count from level to level only the manager not the ICsContent Hi all, I was able to create an analytic which shows alr…User_2025-01-23-22-38-50-675 73 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566 Reporting and Analytics for HCM -
Count FunctionContent Hi Guys, I need to realize a report that bring me the number of course assignment characterized by a specific status, But if i use a simple count on name of empl…Giuseppe Iacono 55 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can i edit or see database query for a pre-defined Subject Area in OBIEE?Summary How can i edit or see database query for a pre-defined Subject Area in OBIEE?Content Hi, I need to know about a SCM predefined subject area backed query or form … -
How to display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 42 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
UOM of the item is getting defaulted with Primary UOM while creating the Pick Wave Instead of UOM inSummary UOM of the item is getting defaulted with Primary UOM while creating the Pick Wave Instead of UOM in which Item has been received against the POContent Hi, Busin… -
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 29 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Demand Supply Inventory ReportSummary Looking for subject area that has all data elements for Demand Supply Inventory ReportContent Requirement: Purpose report is to provide the Demand, Supply and In… -
Unable to generate lot numbers while receiving the POSummary Unable to generate lot numbers while receiving the POContent We have enabled the lot control at item level and created the PO. When trying to receive the PO from… -
Unable to generate lot numbers while receiving the POSummary Unable to generate lot numbers while receiving the POContent We have enabled the lot control at item level and created the PO. When trying to receive the PO from…Dev Thota 49 views 3 comments 2 points Most recent by Kalyanakrishnan Parameswaran-Oracle Manufacturing -
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 178 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
To count the citizenship of an employee in OTBI ReportSummary An employee having how many citizenship in OTBI ReportContent Suppose Employee A contain 2 nationality, one is American and the other is Australian. So this empl…Soumya Goswami-Oracle 59 views 4 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
License and certifications Skill Area Attachments - Where are they stored?Summary Require ability to view attachments employees have added to their License and certifications in OTBIContent Hello, I am trying to view attachments employees have…User_2025-02-04-11-20-13-378 108 views 7 comments 1 point Most recent by User_2025-02-04-11-20-13-378 Reporting and Analytics for HCM -
How can we exclude the login user from the Headcount in the OTBI AnalysisContent How can we exclude the login user from the Headcount in the OTBI Analysis. We have are requirement, If a manager logs in and execute the report to see the headco… -
Only able to see Line Mangers in Worker Assignment subject areaSummary When reporting manager's information, I can only see records of Line MangersContent Hi I'm doing a report where I need to pull all the different managers that an…Rogelio H 67 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Balance Sheet in OTBISummary Balance Sheet in OTBIContent I have a requirement to build out a balance sheet specifically in OTBI. Some folks have recommended using the subject area for Gener…User_ZZQJ0 175 views 1 comment 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Access to query in CloudSummary Ability to run sqlsContent Need to know what options exists to run sql queries in cloud. Also wanted to know if there is a way to connect sql developer to cloud?Praseetha Mohandas-Oracle 67 views 6 comments 0 points Most recent by Praseetha Mohandas-Oracle Reporting and Analytics for HCM -
Create QR code in RTF template for OTBISummary Create QR code in RTF template for OTBIContent I am trying to implement a QR code for the employee number I have followed the documentation: https://docs.oracle.…Cesar Tepetla Corte 131 views 6 comments 0 points Most recent by Ognjen Pavlovic, HCM Product Management-Oracle Reporting and Analytics for HCM -
What is the Limit of records that can be inserted for individual Lookup Type in Manage Standard LooSummary Task : Manage Standard LookupContent Hi all, We wanted to know what is maximum number of records we can create to a Lookup type (Max Lookup codes we can store un…