OTBI
Discussion List
-
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 31 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 52 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 62 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 57 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 505 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 -
Export Manage Receivable ActivitiesIs there a way to export the results in Manage Receivable Activities setup & maintenance screen? Or is there a back end table I can create a data model and report off of…Matthew - Town of Aurora 41 views 1 comment 0 points Most recent by Matthew - Town of Aurora Receivables & Collections
-
How to get detail of Data Access Security Policies applied at role level using sql querySummary: I need to get details of Data Access Security Policies attached at role level. I am using below query to get detail, but it seems its returning data which is en…rahul.gupta.scm 194 views 4 comments 0 points Most recent by rahul.gupta.scm General Ledger & Intercompany -
Transfer order shipping line status in otbi analysisSummary: Need to be able to extract the transfer order line status from 'Manage Shipment lines' UI Content (please ensure you mask any confidential information): Current…