Get Started with Redwood: Oracle Cloud SCM and Purchasing
Payroll
Discussion List
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 12 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Wage Basis Rules Configuration ReportSummary: I have been tasked with creating a report for the Wage Basis Rules so that we can confirm the setup when an element is added to the system Is there a subject ar…User_2025-02-04-08-51-08-912 51 views 3 comments 1 point Most recent by Eric Geddes Reporting and Analytics for HCM
-
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package…
-
W_2 document delivery preference reportSummary W_2 document delivery preference reportContent Hi All, Recently we enabled W_2 consent functionality enabled. Is there any seeded report to get the details that …Peoplesoft 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Payroll Costing Setup: Join Position Level Segments with Work Structure DataSummary: Having trouble finding a good way to join Position Level costing segments from "Payroll Costing Setup Details Real Time" with relevant columns from "Worker Assi…
-
How to build HR analytics using Payroll Period and Payroll Year as time dimensionSummary HR OTBI Analytics with Workforce Management - Worker Assignment Event Real Time subject area and Payroll Calendar as Time DimensionContent Workforce Management -…User_UM4C6 44 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Pension Reports using Payroll - Calculation Cards Real TimeSummary: Build a report showing Employee Pension Details Content (required): I am trying to build a report with the below field requirements but keep getting more than o…
-
I need to prepare pension payover report for Uk legislation in BIPSummary: Condition for this Report is that Employees should not come in Report during opt-out period end date and after opt-out end date employees Employee Contribution …Tiw.Jyotsna-Oracle 1 view 0 comments 0 points Started by Tiw.Jyotsna-Oracle Reporting and Analytics for HCM
-
How to get list of valid Procedure Elements which are used in Payroll HCM Extracts?Summary: We are trying to customize a seeded payroll extract. As most of the extracts use procedure elements to fetch data, we wanted to know if we have some documentati…
-
Need Output as a XML for generate payslip process in Flow patternSummary Need Output as a XML for generate payslip process in Flow patternContent Hi Team, we have a requirement to get the payslip xml from generate payslip process , we…User_2025-02-04-07-00-18-658 61 views 3 comments 0 points Most recent by Naramsetty Ashok Reporting and Analytics for HCM
-
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…Ashutosh12 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 489 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Seeded HCM Extract for payrollHello, Is there a seeded HCM Extract to get total payroll balances per location/department? Thanks in advance!
-
Need a table or Query to get the IRS Limit values for 401K elements in PayrollSummary Need a table or Query to get the IRS Limit values for 401K elements in PayrollContent Hi Team, Need a table or Query to get the IRS Limit values for 401K element…User_2025-02-04-07-00-18-658 68 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
How to convert State Code into State name in BI AnalysisSummary Convert state code into description using subject area or table.Content Hi, I am building an analysis to get some information from a Person's payroll run results…Senthilkumar D 142 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM
-
Gross to Net YTD valuesSummary Require a report that shows the Gross to Net YTD valuesContent I found the base report in /Shared Folders/Human Capital Management/Payroll/Payroll Calculation Th…User_2025-02-04-08-51-08-912 69 views 3 comments 0 points Most recent by Shray N Reporting and Analytics for HCM
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
Payment Method Bank Account Details is not available in OTBI Payroll Personal Payment details RealSummary: We have a customer requirement that we only need to use the Bank Account in ESS Personal Payment Method but when we try to create an OTBI using the Payroll Pers…
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 21 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 93 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 135 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
"Close Date" in Payroll RelationshipsSummary: Morning, We are trying to report on the "Close Date" in Payroll Relationships but I am struggling to find it in OTBI. Would it be possible to have it in the OTB…Tim Hopkins 13 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 23 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table…
-
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…tiffnyc 33 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 217 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM