OTBI
Discussion List
-
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop… -
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242 Reporting and Analytics for HCM -
Item descriptions in Another LanguageSummary Item descriptions in Another LanguageContent Hello We have an implementation for LATAM countries and they would like to have different item descriptions in spani…gabriel kinovisques-163562 13 views 1 comment 2 points Most recent by Debalina Maiti-Oracle Product Master Data Management
-
Finding the actual performance document managerSummary Would like to find the document manager of the performance evaluationContent Dear All, We have created the OTBI analysis through Performance Document Status Real…Janaki Ramana Reddy Vayyala 57 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 30 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…Ramkumar Sethuramalingam 36 views 2 comments 0 points Most recent by Ramkumar Sethuramalingam Reporting and Analytics for SCM
-
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t…Prabhu Krishnamoorthy 6 views 2 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 191 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 73 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to locate documents in someone queue for approval and then reassign them to someone elseContent There are few POs sent to the user for approval and the user is not available to approve them. They are pending his approval so how to identify them and reassign… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 41 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
Column Formatting for hashtag resultsContent Hi all, I'm hoping the request I'm asking is relatively simple to do. We have an OTBI report that when run within OTBI, displays date values as '00/00/0' but whe…MikeW 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Include Unbilled PPM invoices in Available Credit CheckContent Our client woul like to leverage the Credit Management module, however they are having difficulties with the available credit calculation. The available credit o…Suzette Dixon 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Receivables & Collections
-
Trial Balance ReportSummary Trial Balance Report in multiple currenciesContent Hello team, Are there any steps on how to create/customize a trial balance report in order to show local and f…Alex121-Oracle 76 views 1 comment 1 point Most recent by Anca A-Oracle General Ledger & Intercompany
-
How to derive 'Price' and 'Values' from multiple Price ListsSummary How to derive 'Price' and 'Values' from multiple Price ListsContent We've multiple Price Lists defined in our system. For same Organization/BU, we've different P…Omkar Panda-Oracle 85 views 9 comments 1 point Most recent by SilviaCosentino-Oracle Supply Chain Planning and Collaboration -
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 63 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales