Reports
Discussion List
-
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 27 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 21 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 900 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. 14 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 5 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 2 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 43 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 267 views 10 comments 3 points Most recent by Javier Miranda Reporting and Analytics for HCM -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…
-
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 11 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 36 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 11 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 12 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 14 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 55 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… -
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 712 views 6 comments 0 points Most recent by Alex Pagliarini - Ninecon Reporting and Analytics for HCM -
Accruals on Payroll Activity ReportSummary: Payroll Activity Report is pulling PTO Accruals as of Inception to Date for Rehires which is incorrect. Content (please ensure you mask any confidential informa…Ayesha Islam 15 views 2 comments 0 points Most recent by Ayesha Islam Reporting and Analytics for HCM
-
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 32 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 8 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur…Rob F 42 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
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 76 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …