Category 81
Discussion List
-
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 13 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 31 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 23 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 133 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.9K 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 7 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 32 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 41 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 530 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 66 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): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…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? -
Performance and Potential box empty for meetingSummary: Content (please ensure you mask any confidential information): Hello experts, we scheduled one meeting for potential and performance and the box names appear in… -
Restricting Candidate Pool Actions and Pool Creation for Recruiters in Oracle RecruitingIn our Oracle Recruiting instance, we are using the Global Talent Community Pool to maintain a central repository of candidates for future opportunities. Currently, recr…Aastha Deogharia 19 views 1 comment 0 points Most recent by Nathan CCC Recruiting, Opportunity Marketplace -
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.4K views 8 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur… -
Does any schedule process or reports show customer credit funding without enable credit management?Summary: Does any schedule process or reports show customer credit funding without enable credit management? Content (please ensure you mask any confidential informatio…