OTBI
Discussion List
-
Learning courses linked to any of the communityHi Team, Anyone developed the report to link the courses under the topic community? If so, please share. Thanks, -
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 41 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
Is there any standard report for reject inspection in Oracle Fusion?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…
-
CTO and OTBI practical tip as of 20AContent Dear SCPers! There are 2 points I would like to bring to ease troubleshooting and avoid filing SRs in the following scenarios. 1. OTBI fix will come in 20C. With…DinaJacobs-Oracle 54 views 2 comments 0 points Most recent by SARTHAK GOSWAMI Supply Chain Planning and Collaboration -
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 26 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Not able to join 3 subject areas including Quality Issue, Receiving Shipments and Purchase orderSummary: Content (please ensure you mask any confidential information): Not able to join 3 subject areas including Quality Issue, Receiving Shipments and Purchase order.…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" subject areaSummary: Duplication of "manager question text" and "manager response text" in "Workforce Performance-Performance Check-in Real Time" subject area. Content (required): A…kayoung lee 102 views 2 comments 0 points Most recent by Ilaria Petrosino Reporting and Analytics for HCM
-
How to add components under payables landing page in oracle fusion to create an infolet tile.How to add user defined component under Payables> Invoices in Oracle fusion to display the count of Not validated invoices. Attached the Screenshot below: I have tried w…MitaliMeshram 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 81 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
Partially Accounted payment Accounting status is not able to fetch from data base tables or column.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Travis Perkins Description (Required)…Bhanuchander Manthri 161 views 7 comments 2 points Most recent by Vivek Nigam Payables, Payments & Cash Management
-
Exclude Bank Holidays from Absence Days calculationSummary: Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded Content (required): We have a number of sickness absence…Dawn Cawston - CPS 111 views 22 comments 2 points Most recent by Dawn Cawston - CPS Workforce Management -
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 1.1K views 5 comments 0 points Most recent by Estefanía Payables, Payments & Cash Management
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
Work Schedule future dated rows not joining correctly OTBISummary: We have a report comparing the work schedule vs the work schedule assignment. Work schedule (Assignment real time) Work Schedule Assignment ("Person Schedule As…
-
How to know and then set the PO Approval limits for all the Approvers in the System?Summary: We are currently using Supervisory Hierarchy for PO Approvals . There is a requirement to find out the PO Approval limits of all the Approvers in the system and…
-
Learning Records Real Time - Questionnaire ResponsesThere was an error rendering this rich post.
-
Need Help adding a Component DFF to Item Structure ReportSummary: We have Setup a custom Component DFF in item Structure, we need to add the custom dff field in to the Item Structure seeded report. In the data model we are not…
-
Project Manager role to restrict access to purchasing data for own projects onlySummary: Project managers should only be able to view purchase orders, requisitions and AP invoices for the projects that they are assigned to as a project manager. Can …
-
Need Help to Understand SR DocSummary: https://us.v-cdn.net/6034893/uploads/8WUK9TXNSQP3/howtofixbcissue-updated1.docx We have issue, Canceled PR still consumed the project budget. The SR engineer gi…
-
Securing purchase order-, purchase requisition- and supplier invoice details by projectSince the project commitment and project cost subject areas do not provide all required purchase order/requisition and supplier invoice details, project managers of our …
-
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur…
-
Where is 'Last Updated Date' in OTBI for Licenses and Certifications?I am trying to pull a report for all licensure in our organization. I see every field listed on the licenses and certifications UI except 'Last Updated Date'. Where woul…JohnMayo1 1 view 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runsSummary: How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runs, if you have custom layout. I am unable to upload PurchaseOrd…
-
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
Divide Incorrect OTBIHi All, I have a LSQL report which returns an incorrect value when dividing. I've tried other operators such as addition and multiplication, and the formula calculates t…Nick Dorfner 11 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…Global Support Desk 21 views 2 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
Unable to convert our customer outstanding balances to USD for Indian EntitiesSummary: Hi Team, We have requirement to convert customer outstanding balances for India entity to show in USD. In OTBI if you provide option convert outstanding balance…Rajasekhar Reddy Adam 11 views 2 comments 0 points Most recent by Rajasekhar Reddy Adam Receivables & Collections
-
OTBI Analysis Report is not giving Salary Information as expectedWhen we are running the OTBI report, the salary information for the terminated employees is not displaying as expected, and for a few employees, salary details are getti…Paul D 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM