BI Publisher
Discussion List
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 97 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting and Analytics for HCM -
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana Kondaveeti 5.4K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Getting insufficent privledges error when executing SQL in Data ModelWe are trying to create a report that shows bursting queries scheduled in our system. The code was found here: Document 2210437.1 The SQL code we are trying to execute i…Christopher Hitchcock 21 views 4 comments 0 points Most recent by Christopher Hitchcock Reporting and Analytics for HCM
-
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 63 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing?Harish B Choctaw 23 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…
-
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh…
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 1 view 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Help with this error when trying to create offer "There was a problem creating the job offer..."What is the solution to fix this error when trying to create new offer? Have already tried reloading the template.Sara EW 50 views 1 comment 0 points Most recent by Erika B-Oracle Recruiting, Opportunity Marketplace
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 916 views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Goal Approval workflow notification issue with CLOB type data which have > or < symbol ?Summary: Goal approval workflow notification is having success criteria field where field is having below combination of text : 7800 and when notification triggered and …Ankur Jain--Oracle 2 views 0 comments 0 points Started by Ankur Jain--Oracle Reporting and Analytics for HCM
-
Public IP Address?Summary: Hello, our data team is interested in using SFTP to have the ability to automate reports from Oracle to our dashboard and have real-time updates. However, our I…B_Meiling 38 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
query to fetch educational details.query to fetch educational details.
-
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon… -
How to provide the correct Return Value from the List of Value query in the BIP Data ModelSummary: I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters r…Boying 32 views 11 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 12 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 110 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM
-
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…Ooha Pranathi Akkala 90 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…