Category 81
Discussion List
-
Onboarding Report Jobs failingSummary: we have 15days and 30days reports but when we schedule the report it failing and even self also failed . we are used data parameters duration of 16 months . Det…AjayKumar Maddipati 33 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
subject area (affiliation)Hello, I want to create a report on movements and in this report I would like to have the following information: - Affiliation (social security in a French context) -Soc…Hiba Ghoualmia 2 views 2 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want … -
Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 41 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
HelpDesk category reportingSummary: My company utilizes an HR Shared Services department for HR Inquiries. They are essentially a call center for HR questions. They file tickets for each inquiry, …
-
Where can I find the database table that holds Segment Value Security Conditions and Policies?Summary: I'm looking for the table in the database where Segment Value Security Conditions and Policies live. Content (required): I am making some changes to the rules a…David Rabalais 97 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
How to stop BI Workflow Notifications (Personal Information - Disability Info) in Fusion HCMSummary: A BI notification is triggered when an employee enters Disability Info (Navigation Person Details -> Disability Info). We can see there are a couple of seeded B…
-
Learning Evaluations CommentsSummary: We have an OTBI Report developed using Learning Management Real Time subject area to show questions and employee responses. We are unable to show the comments e…Ridma Karunanathan 23 views 2 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
Agent / Recipient List OTBI reportSummary: Is there an OTBI report I can run to see which recipients are listed against an Agent? Content (please ensure you mask any confidential information): I need to …
-
Dashboard: Workforce Compensation Budgets issueSummary: Content (please ensure you mask any confidential information): Hello experts, what is the meaning behind the attached budget seeded reports? The count of total …Valerio Curzi 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How can I add a deep link to go straight to an employee's details?Summary: I am trying to create a deep link in OTBI using the employee number to open the Additional Person Info page, but can only get to the initial page rather than th…Mark Stoker 247 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Hiding Schedule and Job from BIP report part of dashboardSummary: Hiding Schedule and Job from BIP report part of dashboard Content (please ensure you mask any confidential information): Hi, We've a BIP report part of a dashbo…Bhavna-Civeo 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Query to find Ownership type of candidate pool(Private, Shared, Global)Summary: I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, ther…Sujay Bhowmick 66 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report to confirm those that do not have a probation keyedHello, Has anyone built a report to show those that do not have a probation keyed? I have tried building one based on anyone that has the action reason 'end probation' a…
-
How To Prepare Extract For Changed, marked attributes, previous data under threading groupSummary: Content (please ensure you mask any confidential information):Hcm Extracts Version (include the version you are using, if applicable): Code Snippet (add any cod…B V LAVAN Salivahan 23 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Formatting issues in excel template for BIP report (formatted as number in data model but is text)Summary: So, we have a BIP report which details the amount for various pay elements, the element name is hard coded in sub select clauses so we can control the column or…
-
Employees with no rating not showing in calibration reportSummary: We have a requirement to replicate the standard Table and Graph in the Calibration Plan as Oracle has hidden this if a manager has more than 500 reports. We mak…Laura_Stewart_Sita 72 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Act as Proxy Manager for Line Manager DashboardSummary: As an HR user with view all, I am unable to proxy the line manager view what they can see in their own dashboard. In Workforce Compensation, there is Act as Pro…Sonia Canumay 44 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to include legal employer to a document of record OTBI reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aina Emmanuel 32 views 4 comments 0 points Most recent by Aina Emmanuel Reporting and Analytics for HCM
-
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 61 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OPSS Audit Report BIP TablesSummary: What are the Tables used in the Oracle Platform Security Services (OPSS) Audit Reports? Need for a BIP Report Content (required): Hello everyone, I have a repor…Tom John Bontoyan 33 views 2 comments 1 point Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 2 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Logical SQL with NULL resultsSummary: I'd like a Performance Tile based on a Logical SQL query to show Zero when no results are found i.e. there is a null result Content (please ensure you mask any …Richard Kemp-Eyre 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Line Manager Dashboard Workforce Trends with no resultsSummary: Hi, We are working on customizing the seeded Line Manager Dashboard. In "Workforce Trends" tab there are no results for the analysis (see attached screenshots) …Vasco 57 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 32 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 175 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM