SQL
Discussion List
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c…Nivya Mathire 3 views 1 comment 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
Current Date Agent Set UpSummary: I am using Workforce Assignment Real Time and Workforce Relationship Real Time. An agent provides the data. Because the agent exports rather than pulling the cu…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 25.5K views 25 comments 12 points Most recent by Joseph Murphy Reporting and Analytics for HCM
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 183 views 12 comments 1 point Most recent by Amr Kasber Reporting and Analytics for HCM -
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 680 views 7 comments 1 point Most recent by Kamalnath V Reporting and Analytics for HCM -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…Maddipati Ajay Kumar 696 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep_Chavda 306 views 2 comments 0 points Most recent by User_E19UQ 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 …Maddipati Ajay Kumar 61 views 3 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM
-
Is Marketing Communications Opt In available in Recruiting OTBI?Summary: We need to report the Redwood Recruiting candidate-profile value “Marketing Communications Opt In”. The value is stored in IRC_CANDIDATES.OPT_IN_MKT_EMAILS_FLAG…KiranSagar.-Oracle 41 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether…VijayaBaskar Ranganathan 747 views 9 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
How to Join FND_BPM_TASK_HISTORY_B with HCM Tables to Retrieve Employee Conversion DateSummary: Hi Everyone, I have an existing Oracle HCM report that retrieves employee Hire and Rehire information. There is now an additional requirement to include the Emp…
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…Manoharan 941 views 8 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 44 views 4 comments 0 points Most recent by Jenny Scognamgilio Reporting and Analytics for HCM
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.8K views 22 comments 1 point Most recent by Mitali Meshram Reporting and Analytics for HCM
-
Re-hire employee HDL templateSummary: Hi Expert, We are looking for an HDL template to rehire terminated employees. The requirement is to rehire employees with the same assignment information they h…Md Jamil 24 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
Retrieve “Processed People” count for Generate Total Compensation Statements ESS process in BIPFor the ESS process Generate Total Compensation Statements, the Scheduled Processes log displays values such as: Selected people: 1921 Processed people: 636 Ineligible p…Ankush Jadhav -Oracle 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac…Charan Kollipara 1.2K views 14 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM
-
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 201 views 3 comments 1 point Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We…Suganthi Srinivasan 45 views 2 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM
-
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 127 views 6 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 106 views 4 comments 1 point Most recent by Raj Battiwala Reporting and Analytics for HCM -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 411 views 4 comments 1 point Most recent by Rahul_Jadhav02 Reporting and Analytics for HCM -
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…Opkey PA 106 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …