OTBI
Discussion List
-
Actual completion dates for a Maintenance work order operationSummary We would like to see actual completion date of each operation. Please let us know how it can be seen ( UI or OTBI) and not planned completion date. Content (requ… -
PICK SLIP NUMBER SUBJECT AREAHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI report, would someone know what subject area can I find the order pick slip number? T… -
Dashboard for PerformanceSummary: Can someone please share any performance dashboard they have built? The standard dashboard available in system is very basic and not at a level suitable for pre… -
Pending worker conversion date in OTBISummary: Pending worker conversion date in OTBI Content (required): Hi, we would like to know where (Subject Area - Folder - Field) we can have the possibility to extrac… -
OTBI Report not showing all the data thats in HCMSummary: Customised report not showing data for all employees but its in HCM Content (required): Hi We have a customised configuration for our DBS details. Up until last… -
Need to create a BI report for AP Invoice Account Coding Status,Coder Name,Comments,Completion DateSummary: We have requirement to create BI report to give invoice level information along with the account coding status, coder name, coder comments and its completion da…Chowdari Malapati Monika 160 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
OTBI report for Average allocation by Rating is giving 'No Result; however working for managerSummary: We have created custom OTBI report to display the Rating v/s Average Allocation %. The OTBI dashboard is created and the report is added to the dashboard sectio…Shruthi T 31 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Expiration Date QuestionSummary: Question on Expiration date on OTBI and UI We have created an OTBI report (screenshot below) and would like to understand where the expiration date is being pul… -
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 1 view 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM -
Query Invoice Group via BI ReportSummary: Content (please ensure you mask any confidential information): Is the business object Invoice Group available as column in one of the AP tables? Its available f…Rory Mullin 151 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management -
How do I get my OTBI Income Statement to default to the current GL period?Summary: My OTBI Income Statement is defaulted to January 2022, but we would like it to dynamically open to the current GL period. Content (please ensure you mask any co… -
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 1K views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Table and Column to Track Printed Work Orders via ESS JobSummary: We are running the ESS job to print the Mainteance work order 'Print Maintenance Work Order Details'. I wanted to identify the column which marks the Work Order…Aravinth Elangovan-Oracle 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Maintenance -
Seeded Line Manager Role cannot view Future-Dated Hire Events in OTBIContent Hi, We have a report on a Line Manager Dashboard that looks at future-dated hires. For this, we are using the "Workforce Management - Worker Assignment Event Rea… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i… -
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su… -
Display month name's with sorting in OTBI Analysis outputsSummary Display month name's in OTBI Analysis outputsContent Hello Team, I have created OTBI report in that month column value should be displayed like Jan, Feb, Mar, et…User_2025-07-18-14-08-42-473 168 views 7 comments 0 points Most recent by Hari S Reporting and Analytics for HCM -
How can i get Performance current task name in OTBI?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Juhi Kumari 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
1Required The bank account suffix from Supplier site bank account Subject area OTBISummary: Required The bank account suffix from Supplier site bank account to enhance from exist supplier bank account subject area.. We have raised SR 3-38474138291 : CC… -
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, …Jessica L. 168 views 3 comments 0 points Most recent by Jennifer-Leung Reporting and Analytics for ERP -
OTBI report Fetching both Active and Inactive Records when select only Assignment status as ActiveOTBI report Fetching both Active and Inactive Records when select only Assignment status type as Active from Subject Areas : "Workforce Management - Worker Assignment Re…ROHIT NAYAK_120 3 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to add the segments of the Chart of Accounts to the OTBI Subject AreaSummary: Unable to find the 4th and 5th segments of the Chart of Accounts in the General Ledger or Budgetary Control subject areas Content (required): Our COA has 5 segm…Julia Looi 478 views 5 comments 1 point Most recent by Marynol Algura-Oracle Reporting and Analytics for ERP -
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…Cesar Tepetla Corte 11 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia… -
How can documents uploaded to the attachment area under enrolment additional information be viewed?Summary: I am trying to find out where uploads by a learner are stored and how they are accessed. Navigation path ME>Learning>Course>Additional Info View More Details> A… -
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM