Category 81
Discussion List
-
OTBI field results cut offSummary: When I run the attached XML in OTBI, the field results in the vendor name are being cut off. Content (please ensure you mask any confidential information): An e…Julie Mandel 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw…
-
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 1 view 0 comments 0 points Started by Karen Settembrino Reporting and Analytics for HCM -
Usage of "Employment Start Date" quick action and "Work Relationship" quick action.Summary: Some of the Oracle document suggest using 'Work Relationship' quick action (instead of 'Employment Start Dates' quick action) to correct the start date of the p…
-
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?Gian Luca Triglia 11 views 1 comment 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 20 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Oracle ARCS Custom Report-Date parameterSummary: Client has a requirement wherein they want to generate report on month to date basis. Meaning when I generate report today (22/10/2024), it should fetch transac…
-
how to display salaries in arabic words in salary certificate?Summary: In salary certificate we display salaries in English and Arabic. For English we are using below code in template. For eg: For Arabic: In arabic…Deepthi Rai Mohandas 46 views 2 comments 0 points Most recent by Sahil Kathuria Reporting and Analytics for HCM
-
I am not finding the Observation Checklist in Add Content MenuSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Shahul Hameed 22 views 3 comments 0 points Most recent by Alex Joseph Reporting and Analytics for HCM
-
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…Support 26 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to call HCM extract parameter in BIP report.Summary: Hi all, I am working on a loopback integration where I have built a BI report which fetches the data according to the parameter which will come from HCM Extract… -
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.2K 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 31 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 21 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 12 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 1 view 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 54 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 322 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 373 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 16 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 125 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.2K 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 13 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 62 views 14 comments 0 points Most recent by Balavignesh A Reporting and Analytics for HCM