Payroll
Discussion List
-
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… -
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…Chaitanya Jogi 40 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 76 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…Kyle Norris 73 views 15 comments 0 points Most recent by Raghavendra Raghunath-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…
-
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 71 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 32 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 62 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…User_NSURV 11 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 21 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 31 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
UK Check/Cheuqe Payslip ReportSummary: UK Cheque payslip report query Content (required): I am adding the SQL query for custom cheque payslip report. Employee will have the payment method as cheque o…
-
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 51 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 164 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
ORA-01841: (full) year must be between -4713 and +9999, and not be 0Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type…RenzelkeithCoquia 123 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any …
-
Subject Area for Payslip Summary,HoursSummary: Can you please suggest if we have any subject area to get the below info Content (required): Version (include the version you are using, if applicable): Code Sn…pratyushak 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Submit a flow - When there is no privilege added to the custom roleSummary: Hi Team, We are facing an issue related to our custom payroll role. We have built a custom payroll role to perform a few payroll administrative works. This cust…Silpi 46 views 1 comment 0 points Most recent by Kathan Bhatt-Oracle Payroll and Global Payroll Interface (GPI)
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 174 views 4 comments 1 point Most recent by Sheri Curtis Reporting and Analytics for HCM -
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.…Jianzhong Tian 713 views 1 comment 7 points Most recent by KRajesh-Oracle Reporting and Analytics for HCM -
HCM Extract for Payroll ProcessHi We have requirement to get employee details who are processed in a payroll based on the given period start and period end date , so we are planning to create extract …
-
Custom flow is not producing the dataSummary i have attached custom BI Report to custom flow pattern when we are running the flow output is coming as blankContent Hi Team, we have a requirement to attach BI…Chaitanya Jogi 36 views 4 comments 0 points Most recent by Jon Taylor Reporting and Analytics for HCM