Payroll
Discussion List
-
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is … -
Seeded report to get every earning/deduction/taxes of any specific employee during a date rangeSummary: Need to know if any seeded report exist that we can leverage to get details of every earnings/deductions/taxes of any specific employee during a pay period or f…
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
Back end table storing Costing type and Distribution groupSummary: Please share the back end table and column names storing costing type and distribution group name Content (required): HDL load fails with message A distribution…
-
Payroll Data Validation ReportSummary No results in Payroll Data Validation ReportContent I am trying to validate the data in test environment by executing the delivered Payroll Data Validation Repor…Sowdha Murugan 111 views 6 comments 1 point Most recent by Phia Belgica Reporting and Analytics for HCM -
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 146 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM -
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.4K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Top 10 Percent PaidSummary Need to pull the top 10% paid US staff Content Hi, I need to create a query that shows me my top 10% paid staff. The legal definition is: "In determining which e…user6284475 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there an HDL loader for the Federal Calc CardSummary: Hi All, I am looking to see if there is an HDL loader than be used rather than the HSDL loader CA Tax Credit Information Is there someway to cross reference whi…User_2025-02-04-08-51-08-912 21 views 4 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
SQL query to get the costing details at the element entry level.Summary: Hi , I have a requirement where I need to fetch the costing details at the element entry level. I have developed the code ( PFA) but not able to get the costing…
-
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 42 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Catalog of Payroll Flows Dashboards in OTBI reportingContent From 21C or 21D release onwards, following OOTB Payroll dashboards will be deprecated: * Active Processes Dashboard * Payroll Flow Details Dashboard To continue …Tanvi Jain-Oracle 280 views 6 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
how to sum two condition in e-text template on oracle fusion hcmSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w…
-
Output from BI Report is not fully getting passed to HCM Extract in the flowSummary: We are working on the process with the flow including the first step of HCM extract execution which calls BI Report to generate the data in HDL format and then … -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 32 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 19 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
Payroll Pay Affecting changes reportSummary Payroll Pay Affecting changes reportContent Hello, I am in process of creating the Payroll Pay affecting changes report and wanted to know if any one has come ac…Dharmendra Jha 47 views 2 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM
-
Incorrect result in summary report for Payroll - Element entries history real timeSummary Incorrect result in summary report for Payroll - Element entries history real timeContent For an employee, I am getting 8 records and the sum is 631.95 I have be…AvaneeshJain 14 views 5 comments 0 points Most recent by AvaneeshJain Reporting and Analytics for HCM -
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected …Akshat Rajpurohit 30 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
OTBI Reports over Payroll DataSummary We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent The OTBI reports tool is struggling to p…Raz Baboorian 51 views 4 comments 2 points Most recent by Raz Baboorian Reporting and Analytics for HCM
-
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…Prudhvi Indukuri 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…User_2025-01-31-00-25-12-234 128 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …User_2025-02-11-07-08-23-440 40 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…User_2025-02-11-07-08-23-440 90 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM