Category 81
Discussion List
-
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 … -
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 9 views 3 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for HCM
-
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci… -
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…
-
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 834 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 19 views 3 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM -
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 18 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 38 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Invoice Approval ErrorSummary: Invoice Approval error is going into error with error reason as - Error either due to insufficient privilege to execute web service or deployment issues with th…User_UPHXT 7 views 1 comment 0 points Most recent by Nathan CCC Payables, Payments & Cash Management
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
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…
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
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 -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…
-
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 12 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.3K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to find 'Self-assigned Event Rule' tab under Create Life Event pageSummary: Hi Experts, I’m trying to configure a new Life Event in Oracle HCM, but I’m unable to see the “Self-assigned Event Rule” tab under the Create Life Event page. C…Madhuja Bhaumik 12 views 0 comments 0 points Started by Madhuja Bhaumik 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
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 24 views 1 comment 0 points Most recent by Srikanth Nakka Reporting and Analytics for HCM
-
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…Adil_R 19 views 5 comments 0 points Most recent by Julian Challenger-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… -
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity…
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…
-
How to adjust the alignment of output messages within the OTBI dashboard reports?Summary: Hi Team, Could you please advise on how to adjust the alignment of output messages within the dashboard reports? I’ve attached a screenshot below for your refer…Saras Mudliyar 5 views 0 comments 0 points Started by Saras Mudliyar Reporting and Analytics for HCM
-
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…Stephen Jones 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle 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 11 views 2 comments 0 points Most recent by Ayesha Islam Reporting and Analytics for HCM
-
Incorrect "created_by" values in table PER_USER_ROLESWe have identified an issue in the PER_USER_ROLES table where the value in the CREATED_BY column does not reflect the actual user who assigned the role. Most of the time…ReEDCarolineW 19 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Looking for Questionnaire Question / Check-In Questionnaire manager and worker response textI’m currently working on building an OTBI report to extract “Questionnaire Question” responses from the Workforce Performance – Performance Rating Real Time subject area…