BI Publisher
Discussion List
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
MilanMohanty 21 views 0 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
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 62 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 …
-
Is Data numbers on graphs with different colours possible?Can two different colours be applied for value and count in the below graph? Like, Total Number of Opportunities data number should be in one colour and Total Value of O…Nalsoft Pvt Ltd 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 352 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 1 view 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 124 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 21 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 11 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 51 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 21 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Payments approval details not available in BPM history tablesSummary: Hi Team, There are approval rules setup to handle the 2 level approvals of payment process requests. However the payment approval data is not getting stored in …Shashank Shekhar 73 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
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…
-
EXP_EXPENSE Tables link between AP_INVOICE_DISTRIBUTIONS_ALLSummary: EXP_EXPENSE Tables link between AP_INVOICE_DISTRIBUTIONS_ALL Content (please ensure you mask any confidential information): Hi, We have Employee expenses in the…
-
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 32 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 21 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
Need change in IDR Recognition ReportSummary: We need change in the input parameter option for selecting multiple business units as currently we are able to submit for only one BU Content (please ensure you…Srividya VVR 41 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Grade values not appearing in the notification templatePlease refer to the document below for more information about the encountered issue. Thank you.VDoolhur 1 view 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 71 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 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
How to configure Primary Classroom in WLF_LI_CLASSES_FSummary: How can I pull Primary Classroom from HCM UI in BIP along with the full address. I tried using WLF_RESOURCES_TL but it only pull the name of the place/building …
-
Where to get attestation fields in BIPSummary: Client would like to pull in BIP report the Attestation fields found in Offering Level of HCM UI. Attached are the fields needed by client: I already have 2 out…