BI Publisher
Discussion List
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo… -
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in…
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 72 views 8 comments 0 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM
-
How to fetch custom attribute of Legal Entity in BIP?Summary: How to fetch custom attribute of Legal Entity in BIP? Content (please ensure you mask any confidential information): I have this custom field: I cannot see it i…Stefano_Mazzocca 2 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to print data from different levels in the same line in Etext templateHi All, I am using EText template for HCM Extract which results in Employee having Multiple Balances. The Requriement is to display the employee record along with all th…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…
-
How to display a BIP Report in multiple excel sheetsSummary: How to display a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we would like to display the output of a…Barile Alberto 17 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Table FND_SESSIONS, columns FIRST_CONNECT and LAST_CONNECT, what do they mean?Summary: Content (please ensure you mask any confidential information): Can someone explain what FIRST_CONNECT and LAST_CONNECT columns in table FND_SESSIONS represent? …Stefano_Mazzocca 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we create custom views in Oracle fusion?Summary: Can we create custom views in Oracle fusion? We need to create the view to use it in a value set.
-
Which BIP table stores the attachments under Talent Profile?Summary: Which table stores the attachments under Talent Profile? Content (please ensure you mask any confidential information): I'm trying to fetch this attachment unde…Stefano_Mazzocca 13 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
How to set a display order for the columns of a BIP Report (csv output)Summary: How to set a display order for the columns of a BIP Report (csv output) Content (please ensure you mask any confidential information): Hi, we created a BIP repo…Barile Alberto 34 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 159 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 949 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 11 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 22 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…
-
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.1K 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 56 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM