Category 81
Discussion List
-
BIP notification sender nameSummary: Hello Experts, We have a requirement where we need to update the Sender name of the notifications being sent thru BIP, for example, Payslip notifications or not…AprilleLyn 11 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
call bip report from Absence page and pass person_id as parameterSummary: I need to call bip report from Absence page and pass person_id as parameter Content (please ensure you mask any confidential information): Version (include the …Farah Alajou 16 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
What is the table name stored allocated task code?Hi I need to get the allocated task code but I can't find it in PER_ALLOCATED_TASKS and PER_ALLOCATED_TASKS_TL table, I can find only TASK_NAME but can't find TASK_CODE.…Mohamed Salah 24 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 14 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
ORC - Candidate Details Report with phone numberSummary: Looking for the column or field phone number that has both country code area code and phone number rather than displaying it in separate columns In the UI, its …ikc 50 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Open a PDF in a new App or Quick actionIt is necessary to create an APP or Quick action that redirects to a PDF that the client provided us. I'm using the sandbox structure tool. But there is no option to upl…Brandon Martin-Oracle 15 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 50 views 6 comments 0 points Most recent by Regie Mercado Reporting and Analytics for HCM
-
tempContent (please ensure you mask any confidential information) Version (include the version you are using, if applicable): Code Snippet (add any code snippets that suppor…Satheesh Nesamani 17 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to transpose Rows to Column in OTBI Compensation Detail ReportSummary: you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values. …Jasmine 256 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 18 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
element entry secured views queryIs there a query that contains a table to be used to get only the secured list element entries based on the element security profile. Similar to the table per_person_sec…bervin13 35 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 57 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 30 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Parameters for Assignment Descriptive FlexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we configured a DFF based on the doc on this link: https://docs.oracle.com/en/clou…
-
SQL to get Org Pay Method of PersonSummary: SQL to get Person Org Payment Method Content (please ensure you mask any confidential information): pay_org_pay_methods_f record holds the BASE_ORG_PAY_METHOD_N…Vijay Solanki 50 views 2 comments 0 points Most recent by Vijay Solanki Reporting and Analytics for HCM
-
which table stores area of Expertise and Area of Interest in Talent ProfilHello, I would like to know which table stores Area of Expertise and Area of Interest in Public Info in Talent Profile page. Attaching the screenshot for reference. Rega…
-
Filter on Performance Documents Deep LinkSummary: Filter on Performance Documents Deep Link Content (please ensure you mask any confidential information): I have this deep link: It opens this page: Does exist a… -
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 66 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…GajavalliKoteswararao 15 views 0 comments 0 points Started by GajavalliKoteswararao Reporting and Analytics for HCM
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Creating Performance Documents for prior years history : for 2018 to 2023- delta change EE/Mgr docSummary: Ran create performance doc batch eligibility & create for each year. Since employee manager & employee - changes occur in the course of the year and over the ye…S. Chandra 5 views 1 comment 0 points Most recent by Alexandru Sapintan-Oracle Performance Management
-
Which table stores the data from plans and plan types tab?Hi Team, I am trying to fetch the data from plans and plan types tab which is under below navigation: Benefits Administration > Plan Configuration > Program Name > Basic…Saurabh_Mharolkar 46 views 2 comments 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM
-
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? https://us.v…AjayKumar Maddipati 28 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
hcm infoletSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Joe Hiltner-Oracle 17 views 0 comments 0 points Started by Joe Hiltner-Oracle Reporting and Analytics for HCM -
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 5 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Reports are not displaying to tag them in Link or Image section in DashboardSummary: Hi Team, We are creating the Dashboard. Unfortunately, we were encountering that BI reports are not showing to add them in the Link or Image sections in the das…Dasari Dileep 20 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to Retrieve Level 2 Manager's Designation in OTBI ReportSummary: I need to pull the designation of a level 2 manager using OTBI in Oracle Fusion. Looking for guidance on how to achieve this. Content (please ensure you mask an…Sankalp Shukla 43 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 67 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Exclude 'Days Suspended' in Recruiting Dashboard Time to Hire data?Summary: Exclude days suspended in Recruiting Dashboard 'time to hire' metrics Content (please ensure you mask any confidential information): Our client wishes to exclud… -
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 318 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM