OTBI
Discussion List
-
Account Analysis Report - P_CUSTOM_PARAMETER_1 fieldsSummary: how to customize the Account Analysis Reports in following fields P_CUSTOM_PARAMETER_1, .... Content (please ensure you mask any confidential information): Hi, … -
Conditional Formatting in OTBI AnaylsisSummary Conditional Formatting in OTBI AnaylsisContent Hello, I am using conditional formatting to show when a field is NULL by changing the color of the field box. I ha…Shanna Oppenheim 58 views 7 comments 0 points Most recent by Ivony Ann Paula Salango Reporting and Analytics for HCM -
workflow notification customizationHi, We have business requirement to change the layout of Approval notification related to Global Transfer & Global Temporary assignment, The standard forms as shown belo…mshehab 11 views 1 comment 0 points Most recent by Sahil Kathuria Reporting & Analytics for Fusion Service
-
Finding interface values in final tablesHello everyone, can anyone help me? I'm having trouble identifying some fields that are loaded into the interface table to inventory transactions (INV_TRANSACTIONS_INTER…Ivan Torres NTTDATA 21 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
How to Remove Unwanted currencies from LOV in Sales Order?Hello, After putting End date and disabling the currency in the " Manage Currencies " still system is showing the currencies in the Sales Order Header. We required to se…Sankarjith P M 81 views 9 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management -
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 31 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Duplicate record in analysisSummary: Duplicate record appears when pulling data from Workforce Management - Document of Record Real Time Content (please ensure you mask any confidential information…Steph Yeung 51 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 474 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM -
How can we get agreement amount changed in OTBI?Summary: We are trying to get Agreement amount changed from original document to the latest Revision History Content (please ensure you mask any confidential information…
-
I have created a initiative which included OTBI Report and some10 employees are part of this OTBISummary: I have created a initiative which included OTBI Report and some 10 employees are part of this OTBI, However if I need to exclude few of them, is that possible w…
-
Seeded Reports - Key RMCS Reports and OTBI ReportSummary: Can someone guide me for Key RMCS Reports and OTBI Report in latest versions. Content (please ensure you mask any confidential information): Version (include th… -
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 52 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Customer party DFF info is not show in OTBI analysisSummary: We have some DFFs in the customer party level and try to show those customer DFF info in OTBI analysis report with AR transaction. But the DFF info is not shown…
-
Invoice Print Template criteriasSummary: I would like to have 2 different criteria for Invoice Print Template Content (please ensure you mask any confidential information): If I have only criteria like…usr_a.nv 31 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
OTBI Report Not Returning employment contract detailsSummary: Created an OTBI report using subject area "Workforce Management - Employment Contract Real Time" to extract contract details. However, the fields when added fro…User_2025-02-11-02-55-52-410 41 views 16 comments 0 points Most recent by Samir Patro Reporting and Analytics for HCM -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 71 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 51 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Report of units that cannot be reserved due to low stockSummary: The business requires knowing the information of order line units that cannot be reserved due to low stock and in consequence the customer's order cannot be ful…Fabian Castillo 11 views 1 comment 0 points Most recent by Fabian Castillo Reporting and Analytics for SCM
-
How to show AR invoice balance in OTBI dashboard?Summary: I want to show AR invoice balance info in the OTBI dashboard. For example, I want to show info list in the 'View Balance Details' tab in the AR invoice page, su…
-
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 1 view 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the table name to capture/extract audit enabled seeded attribute for example user item type?Summary: What is the table name to capture/extract audit enabled seeded attribute information for example user item type? We have checked EGPSYSTEM_ITEMS_B table but it …
-
OBIEE Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actuSummary Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5389, maximum: 4000)Content Hi, I am trying to create a data mo… -
How to create Formula type Depreciation Method with different Depreciation Rates for different PerioSummary How to create Formula type Depreciation Method with different Depreciation Rates for different Periods?Content Hi Experts, I have requirement to create the calcu…
-
Prompt not working in a logical sql analysisSummary: I created a logical sql analysis (see image1). And I also created a dashboard prompt (see image2). I filtered the "Calendar_Year" as 'Is Prompted' but for some …
-
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 22 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
The table AP_AWT_GROUPS from the tables and views for financials not bringing any dataSummary:The table AP_AWT_GROUPS from the tables and views for financials not bringing any data while AWT_GROUP_ID from AP_INVOICES_LINES_ALL bring data Content (please e…Mariam Umar 62 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management