Category 81
Discussion List
-
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f…Valerio Curzi 36 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Wrap text issue in RTF templateSummary: Content (required): As per the client requirement, I am creating a BIP report. The output of this report should be available both in excel and PDF formats. So I…Prajna Hegde 1.3K views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for … -
OTBI usage dashboardSummary: Identifying OTBI usage for performance monitoring Content (required): Is there a seeded OTBI Usage Dashboard? Have seen below post and wondering if Oracle alrea…ZenG 33 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Reporting Name at Manage Department PageSummary: We are looking for Query to fetch Reporting Name at Manage Department Page,as marked in screesnhot below Content (required): Version (include the version you ar…Priyanka More-Oracle 186 views 2 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int…Parag Hiremath 35 views 5 comments 0 points Most recent by Parag Hiremath 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… -
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 522 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 58 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 37 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 23 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 33 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 5 views 1 comment 0 points Most recent by Rambabu Laveti-Support-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 35 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 152 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 21 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 229 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 22 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… -
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 25 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 147 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 64 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…