Reports
Discussion List
-
How to find Standard Working Hours for a DepartmentSummary Need to report the Standard Working Hours for a department on employee reportContent On an existing report that contains the employee's standard working hours, I…Greg Wissler 95 views 6 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 25 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM
-
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 494 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a backend table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Lis…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 85 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 60 views 3 comments 2 points Most recent by Rishitha sravanya Reporting and Analytics for HCM -
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 16 views 0 comments 0 points Started by Velidi Supraja Reporting and Analytics for HCM
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 314 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 32 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 42 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 913 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?After updating the Name of Department from '60508-East Operations-508' to '60508-Operations-508' via Setup & Maintenance > Manage Departments > Update > Submit The FND_F…Matt_C. 19 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 10 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
List of all Oracle ERP ReportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Venkatesh Chittajallu 10 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …Sherie Ross 48 views 3 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a…Mansur Khalil 275 views 10 comments 3 points Most recent by Javier Miranda Reporting and Analytics for HCM -
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing …
-
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …Priya J N Singh 24 views 2 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 47 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Oracle HCM Inquiry Personal Payment Method and Bank AccountHi Oracle SME's, Here is our inquiry, since moving to redwood we noticed that the bank account and personal payment method has been separated. We just need a query to he…pmarquez 32 views 0 comments 0 points Started by pmarquez Payroll and Global Payroll Interface (GPI)
-
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 17 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
transaction administration subject area securityHello experts, we had an report using the subject area Human Capital Management - Transaction Administration Real Time and it dont consider the security of the employees…Lucas B Maciel 18 views 3 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.4K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 57 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn…