Category 81
Discussion List
-
BI Report Catalog window (Data Model ) to be made Read OnlySummary: Please refer attachement. I need to make the BIP reports query read only in BIP Content (please ensure you mask any confidential information): Version (include …Preeti Khondre 11 views 2 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 42 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Add new entity using Manage Attachment entitiesIs it possible to add a new entity using 'Manage Attachment entities' task and make the attachments available for one of the standard Objects? I tried adding for one the…SatyendraSingh Dangi-Oracle 41 views 3 comments 0 points Most recent by SatyendraSingh Dangi-Oracle Reporting and Analytics for HCM
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 504 views 3 comments 2 points Most recent by nmdp-andrew Reporting and Analytics for HCM -
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 31 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 1 view 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 42 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 91 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 21 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 11 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 234 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 21 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 64 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 21 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 71 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 43 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 30 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 31 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 1 view 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