OTBI
Discussion List
-
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 21 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 57 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime OTBI AnalysisSummary: Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime not showing results Content (please ensure you mask any confidential info…
-
OTBI prompt set default values for date between first and last day of current yearI know that I can set a default for a prompt as todays date using the SQL expression select current_date from "Workforce Management - Worker Assignment Real Time" I thin…
-
How to Disable OTBI agentWe have almost 160 agents in one of the folders and we need to disable all the OTBI agents. How to check whether the agents are actively running and how to disable them …Karthik Soundarapandian1 41 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How do I connect SmartView to ERP Cloud?Hi, It's been a long time. In the past when Cloud ERP was fairly new(4yrs ago). I remember on a project we connected SmartView to Cloud ERP. If I remember right, ERP spi…Hyperion_Junkie 685 views 2 comments 0 points Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 41 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Analysis - Joining Work Relationship Real Time to the Checklist Real Time subject areaSummary Having an issue joining the two subject areas togetherContent In my OTBI analysis, i need to join the 'Workforce Management - Work Relationship Real Time' to the…Shelly Feyerherm 185 views 15 comments 0 points Most recent by Deborah A Reporting and Analytics for HCM -
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 192 views 2 comments 0 points Most recent by Becki Willard Reporting and Analytics for HCM -
custom subject area factSummary: My customer requested the creation of custom subject areas to put the information from these child custom objects in the reports. My team and I created the cust…Matheustavares#1412 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the …AjayKumar Maddipati 21 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Latest Tax not Pulling through Subquery ResultsSummary: Latest Tax not Pulling through Subquery Results Content (required): The sub query set up correctly pulls back latest tax code effective start date in a calculat…
-
Diagnose link purpose?Summary: What's the purpose of the Diagnose link in analytics dashboard? Content (please ensure you mask any confidential information): What's the purpose of the Diagnos…Chin Chi-Oracle 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Learn Records show Duplicates within OTBI Report for all employees and coursesSummary: Content (please ensure you mask any confidential information): Hello, I have recently created a report where the OTBI report shows duplicate rows for most cours… -
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 46 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
Multiple join in Procurement - Purchasing Real Time subject area - Need helpSummary: I am trying to create a very simple analysis from the start. But when I add colums from other folders, the rows multiply and the data is convoluted. Content (pl…