SQL
Discussion List
-
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…Meenakshi K 456 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM -
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 52 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…minati_behera-Oracle 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 45 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192 Reporting and Analytics for HCM
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 31 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 101 views 5 comments 0 points Most recent by Yves Blanc Reporting and Analytics for HCM -
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
SQL for PER_EMAIL_ADDRESSES to obtain Email Address IDSummary: Email Address ID required for HDL worker.dat file to mass upload email address changes. Content (required): We want to use HDL to mass upload email address chan…Michelle Hughes 4.5K views 6 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…Shreya Datir 43 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 94 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u…AjayKumar Maddipati 111 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati…
-
Cannot extract Moved to HR information from BI tables (Recruiting)Summary: Content (required): Hello experts, we need to track candidates under Moved to HR and Moved to HR date. Is there a BI table to extract this information? Thanks i…Valerio Curzi 23 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Security on HCM ExtractWe have created a extract and the customer want to implement security. Business Unit Security Need To Be Applied. The extract output should show only the records as per …
-
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Application Source website details informationSummary: Content (required): Hello experts, from BI, is there a way to extract website details for the Application Source object (Recruiting module)? For example, if we …Valerio Curzi 32 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How should I format the phone number in sql?HOW CAN I FORMAT THIS QUERY AS '+55 111 222 33 11' SELECT CASE WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 3) = '+55' THEN LTRIM (RTRIM ((PPH.SEARCH_PHONE_N…Cansel Karasoy 81 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
ORA-00911: invalid characterSummary: Hi Everyone! I am trying to retrieve a transaction. Below is the SQL Query SELECT a.TRANSACTION_ID,b.TRANSACTION_ID, DBMS_LOB.SUBSTR(a.data_cache,2000),DBMS_LOB…ShawShankk 1.1K views 14 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for HCM
-
Flow Schedule to have next schedule just after earlier runSummary: Flow Schedule to have next schedule just after earlier run Content (required): Hi Team, Greetings! We have a requirement to have the next flow submitted just af… -
SQL function to convert number into descriptionSummary: Content (required): Hello experts, do you know if there is a way to convert an amount into description? For example, in addition to salary amount 40.000 we need…Valerio Curzi 61 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle HCM BI Tabel for manager compensation plan approval statusSummary: Content (required): Hello experts, could you suggest the BI tables allowing to track workforce compensation manager approval status? In other words, we should b…Valerio Curzi 42 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
CMP_PERS.CUSTOM_SEGMENT7 Oracle HCM table nameSummary: Content (required): Hello experts, in which Oracle HCM table can I find the attribute CMP_PERS.CUSTOM_SEGMENT7? Thanks in advance for your time! Kind Regards, V…Valerio Curzi 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Error message when downloading BI ReportSummary: Content (required): Hello experts, when downloading a BI custom report with some users I get the following error message: ORA-01847: day of month must be betwee…Valerio Curzi 51 views 9 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Are the running records kept in the OIC environment like the scheduled reports?Hi, Is it possible to take the last runtime of the service I prepared in OIC and add a condition in this direction to my sql report?I s such information available? For e…Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM