OTBI
Discussion List
-
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular … -
Formula to add 30 days to a date fieldContent Is there a formula that can take a date field and add 30 days to it? Version 21AScott Phillips 45 views 5 comments 1 point Most recent by Jennifer Wiggs Reporting and Analytics for HCM -
Payment Process Profile report & Payment process request template requestSummary Payment Process Profile report & Payment process request template requestContent Please provide any report or SQL query where I can get required information for …Kumar 57 91 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management -
How to control or restrict the Buyer from choosing other Buyer while creating the Purchase Order?Content What is the logic behind the Buyer field being open (LOV) and our client is having an issue because the Buyers are creating the POs on behalf of others with wron… -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 260 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Role security not being enforced on dashboard promptContent I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top…User_2025-01-23-21-24-21-434 17 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
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 14 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…VAYYALA JANAKI RAMANA REDDY 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 29 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 211 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 78 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 42 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