Category 81
Discussion List
-
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a…Mark Stoker 113 views 2 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
How can i get absences in BIP Report that where approved and then withdrawn/deleted .Summary: Hi, Please suggest tables that stores absences that where approved and then withdrawn , are there any transaction table that stores the data or absence events t…GummadiNamrata 49 views 4 comments 0 points Most recent by GummadiNamrata Reporting and Analytics for HCM -
Loading Job Requisitions via HDL - What table is collaborators held in?Summary: I'm loading Job Requisition from one Oracle environment to another and I'm having trouble finding the table where Collaborators sit. Please advise. Thanks! Cont…User_H77SF 42 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 4K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM
-
OTBI : How to customize the seeded OTBI dashboard and analysis used in the dashboardSummary: Hi All, I have to customize the line manager dashboard -> Absence (tab). When I click on edit dashboard -> edit the analysis, I can see the analysis. But I want… -
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
I need help in drill through custom URL.Summary: Direct integration is built between Oracle cloud ERP and EPM Planning cloud. I am planning to create drill through to source using custom URL. I am unable to ge…
-
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 56 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
query or table in service request managementSummary: We need to identify tickets that are not addressed for those requested information /response is already provided in Oracle service request management. We have c…
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 319 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 183 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
OTBI Recruiting Candidate Data SecurityHello, We currently operate in multiple GDPR countries, and our Legal/Data-Privacy departments are requiring that we lock down candidate and job requisition data based o…Nick Dorfner 11 views 2 comments 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, LaurianeLauriane Massin Whitaker 11 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th…BDO Sue Cronin 14 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…SAKTHI SUNDAR 111 views 5 comments 0 points Most recent by User_BN0QX Reporting and Analytics for HCM
-
Getting correct calc_breakdown_id from pay_action_contextsTeam, We have developed one HCM Extract and having balancevalue field. This field gets value from Rule (Fast Formula). We have written the fast formula and calling one v…Manoharan 85 views 0 comments 0 points Started by Manoharan Payroll and Global Payroll Interface (GPI)
-
How to alignment of text in TCS statement ?Summary: The text alignment in columns of TCS reports is inconsistent, with some columns using left alignment and others using right alignment. However, the alignment of…Divyansh srivastava 3 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Misalignment Candidate selection process phase and state between OTBI and UISummary: Content (required): Hello Guys, We would create a report that show for each Candidate selection process Phases and States the correct number of application. By …Giuseppe Iacono 23 views 9 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review …
-
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…Harini Sairam 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
user email ID associated with the user name listed in the licenses usage reportsSummary: Hi, Anyone can help me to get the table and column name for the below screenshot im attaching. actually im working on active user role report, i need this colum…Supraja Sunnapu 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
createException: Security violation... permission: 16578Summary: I created a report but a few users receive this error message, why? Content (please ensure you mask any confidential information): Version (include the version …Stefano_Mazzocca 429 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Cancel scheduled reports in oracle fusionSummary: Cancel scheduled reports in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
How to get full length sentence of a label in bar graph for charts function in RTF Template of BIPSummary: We do have feedback questions and ratings against each question. The goal is to display a bar graph in RTF Template with question vs ratings. How to get full le…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 25 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM