Category 81
Discussion List
-
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 38 views 1 comment 0 points Most recent by Srikanth Nakka 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… -
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…User_2025-10-31-00-42-31-597 222 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 6 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…
-
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 21 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…
-
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 29 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_valuesHello Hope everyone is doing well! I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below quer…Gaurav Bhardwaj 20 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 125 views 2 comments 1 point Most recent by Showstopper09 Human Capital Management
-
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…
-
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
How to pass multiple input values in a flow pattern as a parameter.Summary: I have to pass multiple cost centers in a flow as a parameter to get the report. Can anyone help me to achieve this requirement. Content (please ensure you mask…Eknath Kayasri 11 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.8K views 10 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
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 4 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie…Valerio Curzi 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi…Aaron Reynolds 31 views 2 comments 0 points Most recent by Maciej Kozakiewicz 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 39 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 509 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM
-
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…Yeung Shing Keith 11 views 2 comments 0 points Most recent by Yeung Shing Keith 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 45 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 …
-
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): I have the attached query. Everything works just fine without the fina…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
Field Created on in OTBISummary: In which subject area of OTBI HCM can the field created on of an action be found?