Category 81
Discussion List
-
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 42 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 364 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Manage Content TypesSummary: Hi team, Need a table or SQL quere where Manage content type information stored. Content (please ensure you mask any confidential information): Version (include…
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…Nagendra Chitra-Oracle 28 views 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting and Analytics for HCM
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 39 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…priyankatriv 43 views 8 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 35 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay https://us.v-cdn.net/6034893/uploads/ZMJ07…AjayKumar Maddipati 5 views 0 comments 0 points Started by AjayKumar Maddipati Reporting and Analytics for HCM -
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…Venkatesh Babu Somalinga 182 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Looking for Issue description and resolution querySummary: Content (please ensure you mask any confidential information): Dears , I am working on a query to get issue description and resolution , I found them but I coul…Beshoy Hakim-Oracle 13 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 18 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
if a journey- checklist is deleted in ORC, what are the ways we can check who has deletedSummary: if a journey- checklist is deleted in ORC, what are the ways we can check who has deleted the checklist. We wish to capture the data of deleted ones Content (pl…
-
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…Neha_C-Oracle 109 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 7 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
How to make HCM Line Manager Dashboard available to HR Admin Roles ?Currently Line Manager Dashboard works only for its direct and indirect reports. We want it to execute under the Data Security of HR Admins, so that they can see data fo…RahulMore 20 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 88 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Attachments - Deeplink in OTBIHi, Is it possible to have a deep link for attachments in OTBI so that the person accessing the report can view the respective attachments, such as PDFs, highlighted in …
-
npm pack command is failingSummary: I am trying to generate .tgz file using npm pack command but command failed due to 'bots-node-sdk' is not recognized as an internal or external command. But I h…Sam_1404 26 views 1 comment 0 points Most recent by PoojaUmesh_GSC-Oracle Digital Assistant & Mobile
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 18 views 3 comments 0 points Most recent by Mohamed Eliyas Reporting and Analytics for HCM
-
I need to upload modified custom component, but I am unable to convert the file into tgz formatSummary: I have modified couple of .js files from HCM custom component but I am unable to convert it into .tgz format. Content (please ensure you mask any confidential i…Sam_1404 17 views 1 comment 0 points Most recent by PoojaUmesh_GSC-Oracle Digital Assistant & Mobile
-
Unable to upload the .tgz fileSummary: While uploading the .tgz file I am getting an error- The custom component deployment failed: Failed to fetch custom component metadata, error response: 504 How …Sam_1404 16 views 1 comment 0 points Most recent by PoojaUmesh_GSC-Oracle Digital Assistant & Mobile
-
How to report on reverse termination?Summary: Trying to report on reverse termination, but I get no results We are sruggling to document reverse terminations performed by our costumers in HCM, since in the … -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…John Aitken 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I join WLF_SKILL_CENTER_ITEM_DN to WLF_ASSIGNMENT_RECORDS_F?Summary: In HCM work life, I need to join a skill name to an assignment. WLF_SKILL_CENTER_ITEM_DN has SKILL_CENTER_ITEM_DN_ID and PROFILE_ID as possible keys to join to …MorganH13 28 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
Workforce Management - flexfields visibilitySummary: Claro Guatemala is having issues with flexfields when migrating Absences screens. The issue is those fields were hidden in classic screens but once in Redwood, …Felipe Matallana-Oracle 8 views 1 comment 0 points Most recent by Barbara Fox -Oracle Workforce Management -
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Get the "Related Materials" attachment in Learning reportSummary: Content (required): hi there, I have a learning report but want to capture also a link to the related materials on the Offering level. see image. is that even p…Bobby Jourdan 37 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM