BI Publisher
Discussion List
-
-
Display only Learning Initiative data from the WLF_EVENT_ASSIGNMENTS_F tableSummary: We noticed that data belonging to both Learning Assignments and Learning Initiatives is being stored in the same table: WLF_EVENT_ASSIGNMENTS_F. According to th…upanshu avi-Oracle 69 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Adjusted FTE Table and Views for BI Publisher ReportsHi, I have a couple reports in my system that require the addiction of the Adjusted FTE field as a replacement to the standard FTE field, and I've had a look at the HCM …
-
Query that fetch Calendar Events and LocationSummary: I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but …Matheus Roberto 327 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
Parag Hiremath 9 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 31 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to extract LEGAL_ENTITY_IDENTIFIER?I need a SQL query for a BI report to extract the LEGAL_ENTITY_IDENTIFIER, starting from a department.Gian Luca Triglia 119 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…Kevin Robertson 26 views 2 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…Amit Mundlye-27103 17 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
Columns within the PER_SHARE_INFORMATION table is not populating.Summary: Business need request has come in to build a report regarding shared data access. I have used the PER_SHARE_INFORMATION table. This gives me the employees who a…Max W 58 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
benefits cancelled before coverage start dateSummary: Hello Experts, I have to extract in BIP the employees that cancelled or changed a benefit plan before the coverage effective start date. Can you explain me how …Sebastian La Spina 26 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…
-
Need Data base Oracle tables stored ThirdPartyOrganizationPaymentMethod details.I am working on a conversion BIP report for ThirdPartyOrganizationPaymentMethod . Can you please share a sample SQL to query these information we loaded using HDL.… -
'Range Values' in calculation factor from element definition pageHello Experts, I have requirement to get all details of calculation factor , Please check below image to identify requirement. Thanks.Rajdeep Chavda 37 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM
-
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
Is there a report or query to see changes for employees Loans status before payroll runsHello All, Is there a report or query to see changes to employees Loans status before payroll runs, for example if they refinance , new etc? Thanks, Version 23CGail Wilmoth 28 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
Grade values not appearing in the notification templatePlease refer to the document below for more information about the encountered issue. Thank you.VDoolhur 6 views 1 comment 0 points Most recent by ravali koaduru-Oracle Reporting and Analytics for HCM
-
Does anyone know the arguments for pay_balance_utility.get_bal_grp_usage_values?Summary: Content (required): I would like to run a quick SQL to validate the balance group usage without creating and running a full HCM Extract. This procedure was ment…Scott Paulin 73 views 8 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 … -
Adding Grade Details to Standard Approval Workflow Notifications using Custom templateBusiness has a requirement to add Grade under Employment Details section that is displayed in the delivered/standard Workflow Approval notifications. We have tried achie…Neeraj Awate 15 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Is the Revoke User Access field from HCM termination process available in BI Publisher?Summary: The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to f…
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 294 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 139 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration
-
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 45 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
how to get the length of service based on gradeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…a.w.anand 18 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM