SQL
Discussion List
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several … -
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 308 views 5 comments 2 points Most recent by DebashishDeka Reporting and Analytics for HCM -
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
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…
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 81 views 1 comment 0 points Most recent by Deepsji Payroll and Global Payroll Interface (GPI)
-
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 1 view 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 24.6K views 25 comments 11 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 171 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 612 views 7 comments 0 points Most recent by Kamalnath V Reporting and Analytics for HCM -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit…
-
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 601 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 291 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
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 421 views 5 comments 0 points Most recent by Raj Battiwala 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 40 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 713 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 41 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.7K 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 21 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 41 views 2 comments 0 points Most recent by Milan_Mohanty 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.1K 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 179 views 3 comments 1 point Most recent by SUSAN SANDIFER Reporting and Analytics for HCM