Category 81
Discussion List
-
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any … -
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…Rama Krishna Annam 1.3K views 2 comments 1 point Most recent by NERU Reporting and Analytics for HCM -
How to capture a field with blank spaces at the end?Summary: We are trying to create an audit report that will identify email addresses that have extra spaces in them. Any idea how to capture those outliers in a report? C…CGardner01 31 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
360 peer review participants not showing in OTBI reportI am trying to create a report to show the name of the peer participant and status of the task for a 360 document. The only names that I can get to appear are the employ…Kim Lacinak 33 views 3 comments 0 points Most recent by Andrea Rubino Reporting and Analytics for HCM -
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…Vaishnavi Katiyar 22 views 4 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM -
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the… -
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…Kristy Fung 13 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
OTBI report for Offboarding Journey also pulling rehires along with termsWe are trying to create a simple response and count report for Offboarding journey (for voluntary terms only) . We have added Workforce management - Checklist Real Time …Arnabb 2 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 60 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM -
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 331 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM -
Which table stores the details of benefit dependents and their ages in the Benefit tables or OTBI?Summary: I need to fetch the designated dependent name, relationship to the employee, gender, date of birth, and age for each benefit plan. Please help me understand how…Ketha Paramesh 426 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 15 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Recruit to Hire Dashboard customizationHi Team, As we have seeded Recruit to Hire Dashboard, we want to have customized dashboard based on our requirement. we want to hide below items from the dashboard. Can …VenkaeshSJDI 146 views 8 comments 0 points Most recent by Vaibhav Ramesh Reporting and Analytics for HCM -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 1.6K views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to adjust level of access to OTBI's Administration pageSummary: We have several members on our team that has full access to every option within the OTBI's Administrative page. Is it possible to limit this access? For example… -
Prompt values to be displayed on Direct and Indirect Reportees of manager selected.Summary: We have report which contains prompt Manager Direct Reportees Manager Indirect Reportees Job Name When i logged as a manager Prompt 1 will display all the direc…Hanuman_Prasad 15 views 2 comments 0 points Most recent by Hanuman_Prasad Reporting and Analytics for HCM -
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…Balavignesh A 66 views 14 comments 0 points Most recent by Balavignesh A Reporting and Analytics for HCM -
While running HDL to delete status processing rule from element i am getting below errorSummary: While running HDL to delete status processing rule from element i am getting below error METADATA|StatusProcessingRule|EffectiveStartDate|StatusProcessingRuleId… -
Report on Deleted Interview Feedback - RecruitingSummary: We have a requirement to track the Delete Feedback action on Candidate Job Applications. Has anyone created a report to do this? Content (please ensure you mask…Meeghan_Rodrigues 1 view 0 comments 1 point Started by Meeghan_Rodrigues Reporting and Analytics for HCM -
Is there any work around to get audit detail of External application identifier using BIPSummary: As we don't have audit table for External application Identifier (PER_EXT_APP_IDENTIFIERS) Is there any work around to get audit detail of External application …ManjunathaKD 31 views 7 comments 0 points Most recent by Ganesh Aithandal Muralidhar Reporting and Analytics for HCM -
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from … -
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a… -
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does …Rob Ward 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 5.7K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM -
BI Report for Job Requisition Approval FlowSummary: BI Report for Job Requisition Approval Flow containing full approval flow related data. Content (please ensure you mask any confidential information): Hi expert… -
how to personalize / customize all Oracle HCM notifications - my changes are not showingSummary: Customer requirement is to personalize all HCM notifications for users. The requested changes are the following: - place their logo in all HCM workflow notifica…Katarina Bartova-Oracle 204 views 2 comments 0 points Most recent by InaNotra-Oracle Reporting and Analytics for HCM -
What are the limitations of language pack?Summary: We need to translate the entire Oracle Cloud for users in a specific region. Could you please explain how the language pack will function in this scenario and w…Kritika Gupta 29 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Is it possible to report on element config? (e.g. is it taxable, pensionable etc)Summary: I'm looking to create an analysis which shows me the configuration of each element in terms of which have been set as taxable, pensionable, which payrolls they …BFell 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
generate statement custom field values not picking from rtf templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…karthies 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM