BI Publisher
Discussion List
-
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 961 views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 2 views 0 comments 0 points Started by Karen Settembrino Reporting and Analytics for HCM -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas… -
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?Gian Luca Triglia 11 views 1 comment 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 12 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…Support 23 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any …
-
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…Rama Krishna Annam 1.1K views 2 comments 1 point Most recent by NERU Reporting and Analytics for HCM
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…User_UM4C6 1.2K views 6 comments 0 points Most recent by Rohini Rayavaram Reporting and Analytics for HCM
-
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…Kristy Fung 11 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 51 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM
-
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 304 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM
-
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 918 views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…Balavignesh A 61 views 14 comments 0 points Most recent by Balavignesh A Reporting and Analytics for HCM
-
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 138 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Is there any work around to get audit detail of External application identifier using BIPSummary: As we don't have audit table for External application Identifier (PER_EXT_APP_IDENTIFIERS) Is there any work around to get audit detail of External application …ManjunathaKD 31 views 7 comments 0 points Most recent by Ganesh Aithandal Muralidhar Reporting and Analytics for HCM
-
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from …
-
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a…
-
BI Report for Job Requisition Approval FlowSummary: BI Report for Job Requisition Approval Flow containing full approval flow related data. Content (please ensure you mask any confidential information): Hi expert…
-
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 1 view 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 139 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis…Ketan- 257 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
BIP Report timing out for select Associates in-consistentlySummary: This report is run by about 165 associates. Almost 80% of runs are successful where others are getting “Time out error” for rest. It’s not consistent, though. C…
-
Report to identify employees with corruption in "PER_PERSON_NAMES_F" tableSummary: Hello, We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused er…
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in…