Payroll
Discussion List
-
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 51 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM -
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.6K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need a report with each element and corresponding eligibility/eligibilitiesSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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…
-
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 175 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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 151 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.5K 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 32 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 41 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 31 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 31 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 18 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 46 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 13 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 29 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM