SQL
Discussion List
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (Payroll-> Review Journal Entries) For An Employee Columns are: Accountin…Manoharan 45 views 1 comment 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…
-
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…Manoharan 11 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Report parameter definitionHi, There is a absence start and end date in the absence used report I created.and when i select start and end dates i want to see absences in that range this is how i d…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Length of Service CalucationSummary Need to subtract Current Date from Legal Employer Seniority DateContent Does anyone know of a SQL formula to subtract the current date from Legal Employer Senior…Rebekah Gilday 116 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,Cansel Karasoy 54 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Team Dashboard ErrorSummary: Content (required): I have created a custom role but it is unable to see the compensation tab of the team dashboard area. I know it is a missing role problem bu… -
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl…
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 33 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
when we schedule the report we getting below error messageSummary: Hi Team, when we schedule the report we getting below error message. Thanks, Ajay Content (required): Version (include the version you are using, if applicable)…AjayKumar Maddipati 71 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Data PurgeSummary: Hi Team, Could we get the list of dependent components which will be purged when we select particular object in "Data Purge" Example: if Payroll is selected in …
-
Is there a table to find the size of files uploaded on Documents of Records?Summary: Is there a table to find the size of files uploaded on Documents of Records? Content (required): Version (include the version you are using, if applicable): Cod…PrafullMadhur 21 views 2 comments 0 points Most recent by PrafullMadhur Reporting and Analytics for HCM
-
Seeded list of action and action reasons for HCMSummary Need a seeded list of action and action reasons in HCMContent Hello Everyone, Hope you all are safe and healthy. I need a list of seeded action and action reason…Akanksha Jain 256 views 3 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
We have onboarding 30days questionarie BI report, issue is not showing status in reportSummary: Hi Team, We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming. I observed that employess statu…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Getting the value of Enable Position Synchronization field from Legal employer setupSummary: Getting the value of Enable Position Synchronization field from Legal employer setup Content (required): Hi Team, Greetings! Is there a report or diagnostic or …Parag Hiremath 21 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Oracle table name containing employment category informationHi, I need a list of cost center information defined in the system, can you share the table containing this information with me? I find the cost center information assig…Cansel Karasoy 505 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
OTBI Subject Area/SQL to fetch HCM Approval Delegation detailsContent Hi, Does anyone know the OTBI subject area/Table names which can fetch the details of HCM Approval delegation in Person's Account Management page. Best Regards D…
-
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m…
-
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
SQL Query to display OTL Calculated Hours/Reported HoursPlease I want a query or tables to search in to get the reported hours and calculated hours, except for those tables (HWM_TM_REC , HWM_TM_REP_ATRB_USAGES ,HWM_TM_REP_ATR…Muhamad 772 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require…
-
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
"Number of Job Application changed to..." Code NeededDoes anyone know the code behind the following columns? For example, when viewing the numbers, the highlighted "Number of Job Application changed to Job Offer Phase" fie…
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 108 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 272 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM