Category 81
Discussion List
-
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 25 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 16 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 121 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 …Bindu Janoti-Oracle 59 views 4 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM -
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…
-
Help with Extracting L1/L2/L3 Managers in ReportsHi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in speci…
-
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 13 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.6K 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 12 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 36 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 31 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 469 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 12 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 21 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 18 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 13 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.2K 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…
-
Getting error when running OTBISummary: Getting error when running OTBI analysis using Benefits - Person Information Real time Content (please ensure you mask any confidential information): Hi, Gettin…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.1K views 18 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 30 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM