Payroll
Discussion List
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 218 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM -
Matrix Manager into HR Hierarchy for Line Manager in PayrollIn the common lookup PER_SUPERVISOR_TYPES we have created a manager role named Indirect Manager. Is there a way we can take these newly created roles and merge them into…Sean-B-01 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need table references for Managed Object Groups / Element SetI have created an Object Group of the type Element Group and added a few elements to it. Now, I am trying to retrieve the list of elements from a BIP (BI Publisher) Repo…Sai Krishna Adabala 11 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 63 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data …supriya kadam 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
Is there possibility to disable Things to Finish tile on homepage of Oracle Fusion RedwoodSummary: want to check possibility to disable Things to Finish tile which came with update on Redwood theme on homepage of Oracle Fusion for specific user. We want to di…
-
Sign On Bonus Effective Date ReportWe have a OTBI Sign On Bonus report that runs based on hire date. I'm looking to update this report to pull based on Sign On Bonus Effective date instead. However, when …Nicole A. 13 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Inaccessible columnSummary: This report is to fetch the personal contribution of an user. It is working file for everyone but one user. She is getting an error which is attached. I have tr…
-
How to hold the EOSB payment after preforming Local and Global Transfer?Summary: The business wants to hold the EOSB payment (Years of Service) and transfer it to the new assignment after the completion of the Local and Global transfer, alon…Anisha Suri 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Converting PW to EMP future installments switched to paid on start date instead of staged future datSummary: When converting PWK to EMP, if there are multiple future Sign On Bonus installments, all element entries from the PWK record are removed. Additionally, all inst…Madhuja Bhaumik 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…Jon Taylor 17 views 2 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 292 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
Payroll OTBI with Balance Definitions, Names, Feeds and Element names with Input Value NamesSummary We have a Balance Name called Net Pay with a Balance feed of multiple combinations of Elements and Input Value Names but I cannot find this relationship in the m…
-
Payroll Data Validation Report Returns No Data in Test EnvironmentSummary: Hello , I am trying to validate the Payroll Data Validation Report in our test environment. The process completes successfully and generates both PDF and Excel …Shalu Khade 21 views 1 comment 0 points Most recent by Tiff Dickson-Oracle Payroll and Global Payroll Interface (GPI)
-
which hdl used to create individual balance adjustmentsSummary: We are looking for the hdl to create the individual balance adjustment for the person Content (please ensure you mask any confidential information): We are look…Balaji Vijayakumaran 31 views 5 comments 0 points Most recent by Paul Driver Reporting and Analytics for HCM
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
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…
-
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 933 views 13 comments 1 point Most recent by Lohit Kad-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 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 483 views 9 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
Payroll - Calculation Cards Real Time FieldsSummary Trying to find two specific fields withing Calculation Cards Subject Area: Issuing Authority and Order Amount Payee.Content I am working on building a report for…
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
How to Find the Pension Scheme Name from the 'Benefits and Pensions' (BnP) Calculation Card in a BIPHello Experts, I am building a BI Publisher report to show employee pension details. I had a requirement, were I need to retrieve the Pension Scheme Name from the employ…
-
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
Need Descriptive Flex Field to display under Time Periods tab in Payroll DefinitionsContent Customer has a requirement for an additional column called "Payroll Run Complete" to show values as "Yes" or "No". This column would represent the Payroll Proces…Alysia Santana 29 views 3 comments 1 point Most recent by Cloud_Payroll Reporting and Analytics for HCM
-
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…Henry Imgrund 22 views 2 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
Need query for Calculation card values to run result values in hcm fusionSummary: Need query for Calculation card values to run result values in hcm fusion Content (please ensure you mask any confidential information): Need query for Calculat…Kaustubh Deshmukh 13 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM