Category 81
Discussion List
-
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 13 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 250 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 12 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 27 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 52 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 22 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 42 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 61 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 12 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 11 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 1 view 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 37 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 23 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 12 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 1 view 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 11 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 41 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 45 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 294 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,Michael_B 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…
-
Getting "The file uploaded may contain a virus or otherwise failed to be scanned for viruses."Summary: While trying to load the company logo image on an OTBI Report, i am getting the following error. "The file uploaded may contain a virus or otherwise failed to b…user10838976 82 views 9 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for HCM
-
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…JMLMIII 42 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM