Payroll
Discussion List
-
Is there a way line managers can view element entries?Summary: Is there any way line managers can view reports with element entries? I'd like to create an overtime report so they can monitor their reportees claims but it do… -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9K views 122 comments 35 points Most recent by Virendra Reporting and Analytics for HCM -
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 4 views 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 31 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 25 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 13 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Under Payroll relationship, end date is not updating when reverse termination payroll performedSummary: When we performed reverse terminate payroll under Payroll relationship> Payroll Association, End date is not reverted . Post Reverted , End date is not changed …Shwetha_01 28 views 2 comments 1 point Most recent by Yogita Someshwar Payroll and Global Payroll Interface (GPI)
-
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 121 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
Element entries related to the current assignmentContent Hi Team, We are generating an offer letter for the candidate once they become a pending worker. For that we are getting the data from the element entries table. …Shikha Agarwal 678 views 4 comments 1 point Most recent by Ashraya S.N Reporting and Analytics for HCM -
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…GauravGupta39 1.3K views 3 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 39 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM
-
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 224 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 12 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 12 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 48 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. 14 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 14 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 12 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 14 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 271 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…