OTBI
Discussion List
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m… -
How to transpose Rows to Column in OTBI Compensation Detail ReportSummary: you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values. …Jasmine 251 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom Notification based on field updateIs it possible to trigger a notification when a field on Negotiation header is updated to a specific value?
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can't find DFF's Fixed values TableManager Layout > Choose the defined layout > Details (Tab) > Add Field > choose attribute > finish > select the field and click edit > check the fixed list value > add t…Ahmed Matar 11 views 2 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Convert the column in the report to a numeric datatype from VARCHAR.Summary: I have a requirement: the output of the report, including columns like net_amount_due, should have a data type in number format after extraction in excel. Conte…DataWhiz 53 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
SQL to get Org Pay Method of PersonSummary: SQL to get Person Org Payment Method Content (please ensure you mask any confidential information): pay_org_pay_methods_f record holds the BASE_ORG_PAY_METHOD_N…Vijay Solanki 55 views 2 comments 0 points Most recent by Vijay Solanki Reporting and Analytics for HCM
-
Version controlSummary Version control for OTBIContent Is there any preferred version control software for OTBI and BI Publisher code? ThanksUser_2025-02-05-23-02-10-916 50 views 3 comments 0 points Most recent by Jayapal Reporting and Analytics for HCM -
How to use Import Maps for Sales Order uploadSummary: We have a requirement to use import maps for sales order import/upload facility Content (please ensure you mask any confidential information): We would like to …
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 61 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Is it possible to use FBDI for adding some sites to an exiting customer?We created a customer but we need to add many sites to him, so we are thinking about using FBDI, but is it possibile for an existing customer to use FBDI just for create…
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
Dynamic PO PDF bodySummary: one of my customer wants the PO PDF Body message that goes to the supplier to be customized dynamically and it needs to be editable for each email that is sent …
-
Invoice Lines with yellow exclamation markHi All, The Invoice lines have a yellow exclamation mark, with type Item and red box against Amount column. We are unable to find the error message it shows needs revali…Swapnil Kashid 12 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Allow tax withholding, Use Withholding Tax Flag, Withholding Tax Report Group, Federal ReportableSummary: Need help finding the table/s that holds the tax information below for Suppliers: 'Allow tax withholding', 'Use Withholding Tax Flag', 'Withholding Tax Report G…
-
Data Not Visible in OTBI Dashboard for the userSummary: We have created one custom OTBI dashboard. When we give access to the user, he can access the dashboard but data is blank. What roles are requried? Content (ple…Santosh Vaidya 51 views 3 comments 0 points Most recent by Santosh Vaidya General Ledger & Intercompany -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 51 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP
-
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL to find Material Transaction for Dropship Sales OrderSummary: SQL to find Material Transaction for Dropship Sales Order Content (please ensure you mask any confidential information): we are looking to get a SQL to find Mat…
-
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q…Upendra Nayak 504 views 5 comments 3 points Most recent by CSINGH_KCC Reporting and Analytics for ERP -
How to Retrieve Level 2 Manager's Designation in OTBI ReportSummary: I need to pull the designation of a level 2 manager using OTBI in Oracle Fusion. Looking for guidance on how to achieve this. Content (please ensure you mask an…Sankalp Shukla 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.user714053-Oracle 210 views 4 comments 4 points Most recent by Divyalakshmi Krishnamoorthy Reporting and Analytics for HCM
-
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based…Pedro Teixeira 2K views 7 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM