Category 81
Discussion List
-
Change type of font in RTF templateSummary: Formatted text within an RTF template authored in Microsoft Word does not persist when rendering using Oracle Analytics Publisher Desktop Content (required): Th… -
OTBI Edit Column Formula for YYYYMMDDSummary: Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Manageme…User_2025-02-11-05-19-35-410 484 views 7 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
HCM Extract| Balance ValueSummary: Hi, I need to fetch balance value for dimension YTD. I created the balance group and HCM extract(Followed the attached PDF). But it is not working as expected. … -
No results after adding a column in subject area Workforce Management-Documents of Record Real TimeSummary: Content (required): Hi there We are trying to create OTBI report for a type of Document that we have. Actually, there are 6 specific custom made types, but when…Bobby Jourdan 48 views 16 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to build a HCM extract to generate HDL files.Summary: As per the business requirement, I need to build a HCM extract to generate the CalculationCard.dat file. I need to build an extract which can give me balances y…
-
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 32 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Report of Delta for Old and New ManagersSummary: Hi, I need to create a report / analysis that would pull the results for the employees who have a new manager value. I have taken first steps by creating an ana…J_Haskell 24 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Hi, need to pull the Last Update date field by yesterdaySummary: I am building a report to automatically pull the old and new manager data by "Worker Assignment Details"."Assignment Last Update Date" which should be by yester…J_Haskell 32 views 15 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
1095cSummary: How to modify or update 1095c form? Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that…Saksham S 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Extract should have two Parameters 1. Expense End Date 2. Payroll NameSummary: Need input on how to add parameters in HCM extract. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Arti P 3 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Reporting and Analytics for HCM
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Document Of records- Headcount - Document Count inconsistent resultSummary: I am trying to create a report with employees who have updated their 2nd covid vaccine on the DOR. I am able to get the count correctly. Then I am trying to get…
-
Issues Reporting on Development Goals after a Global TransferSummary: We are facing an issue in reporting (both OTBI and BIP) where an employee adds development goals and shows on our reports as expected, but after they have a glo…Gabrielle Ungaro 31 views 6 comments 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM -
Enforce 2 decimal places after a column result in s query.Summary: The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 4…Aloka Bhattacharya 153 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
HCM Extract and Bi Publisher delivery option auditHi Whatever change has been made to the delivery option in both HCM extract and BI Publisher. Does the change and the user who made changes gets audited?? If Yes, could …
-
Filter to bring back the greatest Response Attempt NumberSummary: Content (required): We have an OTBI report using looking at employees Performance Review Rating (workforce performance - Performance Rating Real Time), for most…Joe Dorrian 22 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Promotions and Transfers Reports and Data ModelsSummary: Business need for two reports: promotions and transfers showing From and To information Content (required): Hi, everyone. We are looking for an example of a rep…Michael Cashin 214 views 3 comments 0 points Most recent by User_VB02H Reporting and Analytics for HCM
-
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…Scott Conaway 24 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the…Karen Costakes 22 views 2 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …ViswanathaReddyKetireddy 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly executed) Is there any way to find. ThanksMohammed Rafi 146 views 3 comments 2 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming…User_2025-02-11-23-20-16-609 63 views 0 comments 0 points Started by User_2025-02-11-23-20-16-609 HCM Extract
-
HCM Extract failing at runtime for Name PAY_PAYPROC_UNKNOWN_ERRSummary: Hello, The HCM Extract validated and compiled with no errors is failing at runtime for below mentioned errors: Name PAY_PAYPROC_UNKNOWN_ERR Token1 null Token2 n…
-
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 54 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
[Alert Composer] Alerts are Working at the Course Level but Not at the Offering LevelSummary: Alert is not working at the offering level. I refereed oracle document (Doc ID 2610054.1) but don't know how to implement the rest API. If anyone has experience…
-
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …Arti P 32 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Why I am getting no results after using Workforce Management - Documents Of Record Real TimeSummary: Why I am getting no results after using Workforce Management - Documents Of Record Real Time . When I am using column Person Number and Document Type there is n…RakeshK 28 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Purge deleted learning item gives an errorSummary: Content (required): Hi there, We managed to delete some legacy records as explained here. The next step is to purge them, as explained here. The template we use…
-
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…Akram1206 33 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 12 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM