SQL
Discussion List
-
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 12 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 31 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 77 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 30 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 261 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 32 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 546 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 827 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 22 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 281 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
RTF Template with Excel Template AlignmentWhat would be the best way to get the good alignment when using RTF and output is Excel. We have more number of columns ...Example see the date of birth. The same way it…
-
Correct sorting of report in sql queryHi, I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digi…Cansel Karasoy 24 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Convert Numbers to words in OTBI Report.Summary: Hi Everyone! I am trying to build a OTBI report for employees salary. Subject area used: Compensation - Salary Details Real Time. I want a column where it displ…
-
R12 HCM OTBI subject area database table mapping spreadsheetSummary R12 HCM OTBI subject areas to database tables mapping spreadsheetContent These spreadsheets are published by Oracle OTBI Development. The spreadsheets document F…User720640-Oracle 2.2K views 33 comments 30 points Most recent by Rishita Reporting and Analytics for HCM -
BI - CASE statementContent Wondering how we can use the CASE statement in the WHERE clause. I keep getting error 'Missing Keyword' and I dont see anything wrong with my CASE statement. It …User_WHB5J 151 views 22 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…