OTBI
Discussion List
-
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom… -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a… -
receivable adjustment amount column to add in OTBI ReportIn our report we are using OTBI subject area Receivables - Transactions Real time our users want to see the adjustments in the report. So we added Receivables - Adjustme…priyankarao 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
How to get party tax profile third party and third party site?We would to get a query to extract party tax profile third party and third party site but but with the one we used we can only extract third parties: Select zxp.PARTY_TY…Ylenia Gentile 133 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global -
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
query to join CSE_FAILURE_EVENTS with WIE_WORK_ORDERS_BHello Oracle Community, I need help finding a table or view to join the CSE_FAILURE_EVENTS table with the WIE_WORK_ORDERS_B table, rather than using WIE_WO_ASSETS. When … -
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 151 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 153 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 12 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. 161 views 3 comments 0 points Most recent by Jennifer-Leung Reporting and Analytics for ERP