OTBI
Discussion List
-
VVattikuti 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 291 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …Vibha Pandey - Oracle 31 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How To Embed OTBI Report To Responsive UI (Performance)Content Requirement ============ Manager able to see OTBI absence report using me -> career performance page -> Performance-> Employee Performance Document (Specific Emp…AvaneeshJain 314 views 14 comments 0 points Most recent by nanda.patil Reporting and Analytics for HCM -
How to update the Publish End Date in Offering using HDL File ?Summary: I am trying to update the publish end date as (2023/10/26) in Offering, and the HDL file got loaded successfully, But while checking from frontend navigation th… -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
OTBI Hourly Rate calculation for employees on monthly pay cycleSummary: I am modifying an existing report on employee's salary. The organization has bi-weekly and monthly pay cycles. When calculating the hourly rate some monthly emp…
-
Rating data is displayed in different rowsSummary: For the Perfomance Document Section I want to have two cases illustrated in two different columns: I wrote a Case-statement that if Perfomance Document Section …
-
Load Data from FAH(fusion Accounting Hub) to FAW, need more details?Summary: Data load from Fusion Accounting Hub(FAH -Fusion Applications) to FAW(Fusion Analytics warehouse) Content (please ensure you mask any confidential information):…NsanthoshK 41 views 2 comments 0 points Most recent by NsanthoshK Reporting & Analytics for Fusion Service
-
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
Oracledatatable for supplier masterdata fieldsSummary: In an external application, we are creating checks on Supplier master data information combined with data from other sources. For 2 checks we need the data fiel…Daniel.Hut 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
how to create Dynamic Parameter in Logical SQL in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 122 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Data Security in Custom BI Reports in Oracle Fusion Financials CloudSummary Data Security in Custom BI Reports in Oracle Fusion FinancialsContent Hi, We have lot of Custom BI Reports developed across financials Module ( AP , AR, FA , GL …Udit_Manchanda 521 views 9 comments 2 points Most recent by rahul.gupta.scm Reporting and Analytics for ERP
-
OTBI subject area for complex PO work confirmation dataCan someone help me identify the subject area in OTBI for work confirmation reporting? -
Hi Team,I want to apply Security on OTBI Dashboard using Area of ResponsibilitySummary: Hi Team,I want to apply Security on OTBI Dashboard using Area of Responsibility so that HR can see only their BU data not whole data Content (please ensure you …Nalin Jha 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Where to find HR Compliance and HR Operational ReportsWe recently went through an Oracle implementation, and was wondering where can I find HR compliance and HR operational reports. Our Implementation partner mentioned that…Ameya_J 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Download a Spreadsheet that has a link to attachment in the Journey RecordSummary: Our company is looking for a quick way to audit the attachments that have been uploaded into Journey's Content (required): “Is there a way to download a spreads… -
Payslip Template ChangesHi all, I'm hoping someone can help me here. Our payslip is a customised version of the seeded one provided by Oracle that currently has every page in landscape. We'd li…MikeW 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…Keval_Shah 354 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.2K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca…Dara Nagasai 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Purchase order PDF can't be downloadedSummary: Purchase order PDF can't be downloaded Content (please ensure you mask any confidential information): Hello I generated a customized Layout for PO, for purchase…
-
Comparing current Job Titles to previous week Job Titles in OTBISummary: Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports …GJ79 91 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Comparison between two tables with the same fields in one tableHello! I would need some help with this idea of an analysis. The idea would be to make a comparison in a single table of two different tables with the same fields. Somet…
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…NZ-user999 856 views 2 comments 1 point Most recent by NZ-user999 Reporting & Analytics for Fusion Service