Category 81
Discussion List
-
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 33 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
What is the best way to show all employees for a specific element even if they do not have it?Summary: I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't Content (required):…Mark Stoker 32 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…Franziska Reichel 187 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 11 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Help for Dates crossing into New YearSummary: HI All, I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those …User_2025-02-04-08-51-08-912 22 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 22 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
What HR roles can see Performance analyticsSummary: We have a Dashboard containing a tab with information on Performance Documents (status, ratings, etc.) and a tab containing information on Goals. Line Managers …Wouter.Schaap 3 views 5 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
ORA-00933 : While generating explain plan in BISummary: When we are generating the explain plan we are getting this error message from BI Data set. oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933…
-
Sample CSV file for Purging Learning recordsSummary: Content (required): Hi there, I am looking for a sample csv file for purging Learning records Is there any available? Thanks in advance. Bobby Here is the featu…Bobby Jourdan 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 23 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 500 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM
-
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 47 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
How to map an Subject Area Field to an Oracle tableSummary: I am trying to find the table that holds the company name for our contingent worker the field that I am trying to map to SQL is I thought the data would be in t…User_2025-02-04-08-51-08-912 31 views 9 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
How to exclude logged in user from BIP report?Summary: Logged in user needs to get excluded from their own BIP performance report Content (required): Hi, we have built a custom BIP report for performance data for ma…Franziska Reichel 32 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM
-
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…Annette M 21 views 2 comments 0 points Most recent by Wiktor Ornatowski-Oracle Reporting and Analytics for HCM
-
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 390 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Prevent files with only header row from getting generated from etext bursting in BI PublisherSummary: Prevent files with only header row from getting generated from etext bursting in BI Publisher Content (required): Hi Experts, I' bursting an etext template with…Aloka Bhattacharya 12 views 8 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 668 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need a report with each element and corresponding eligibility/eligibilitiesSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 32 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 123 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 33 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject areaSummary: How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area Con…Nikhil Bhandari 333 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM