Category 81
Discussion List
-
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 146 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 14 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 58 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
Query for finding Assignment number from Calculation Card under Associations.Summary: Need a query through which we can find assignment number from calculation card under association. Content (required): Hi All, Can anyone please share the query …Pinky Mukherjee 935 views 5 comments 0 points Most recent by FCL_coop_AS Reporting and Analytics for HCM -
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 12 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…Arti_Priya 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absence Calendar Subject Area not showing all dataSummary: When I run my report using the Absence Calendar Subject Area a large amount of data is missing. I have tried running the Generate Daily Breakdown of Absence Det… -
Does anyone set up goals and perform management for Redwood ? Are any issues faced ?Summary: Does anyone set up goals and perform management for Redwood? Are any issues faced? Content (please ensure you mask any confidential information): Version (inclu…
-
Document record request, details are not reflecting on Supervisor's notification page.I'm raising a Document Record request from an employee user but in supervisor's notification page the document details are not reflecting in the document details column …
-
Absence notification is not sent to Line Manager after Employee withdraws it.Summary: In the Absence approvals, when an absence is requested by an employee and is approved by their Line Manager, when the employee attempts to withdraws the absence…
-
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…Barile Alberto 48 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Generate query related ODA reportsSummary: I want to generate analytics report for responses for specific queries like feedback query to understand bot responses and communication with user to improve pe…
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 261 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Performance Document Goals Employee Calculated Rating Not Working for Some WorkersSummary: We'd recently revamped and launched our Performance Reviews, and we've found some folks are having issues with one particular part of the document. When they go…
-
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
Report on User Actions in Oracle HCMSummary: Good evening, I need to extract a report with all the actions performed in the system by users (e.g., hiring an employee, entering Performance Goals, etc.). Is …Guido Masciello 13 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
Can anyone explain scecurity being used on seeded DM?Summary: The business looking to add security to a custom version of EmploymentCreateProcesses, like the security being used on seeded /shared/Human Capital Management/W… -
Is it possible to limit offering capacity without using the Wait List functionality?Summary: We have a business unit that wants to limit their ILT offering capacity, but they do not want to use the wait list feature. Is this supported? Content (please e…
-
how to use get_variable in IF condition in RTF templateHi Team, We have a requirement to display the data in report based on net sal, to get this done we are using below tag in RTF template and its not working, we tried diff…Suresh Gandla-Oracle 416 views 4 comments 0 points Most recent by Arun Raj Reporting and Analytics for HCM
-
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
Capture the Learning Activity description in OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, is it possible to get the description of an Activity in an Offering from the Learning R…Bobby Jourdan 42 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 745 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM