OTBI
Discussion List
-
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a… -
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
Equivalent reports in fusion for the following EBS reportsSummary: Hi All, Could you please help to find the equivalent reports in fusion for the following EBS reports. 1.All Inventory Value Report 2.Material Account Distributi…
-
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …Oriana L. 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th…
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our … -
Purchase requisition and purchase order Comparison ReportSummary: I want to create a query to retrive PR Amount and PO Amount Associated with It and return difference between them Content (please ensure you mask any confidenti…Mohamed Adel53 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 169 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 155 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 32 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 3 views 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 161 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 1.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