BI Publisher
Discussion List
-
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo…Oriana L. 10 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 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 5 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 70 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 28 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 15 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
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 133 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 217 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 1K 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 11 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 16 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 27 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 29 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.4K 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…
-
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 19 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 71 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 344 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 26 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 1.8K views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM