BI Publisher
Discussion List
-
Extract Specialisation, Spec Section, Course, Offering, Offering Section, Activity in 1 row?Summary: Is there a way to extract the Specialisation, Specialisation Section, Course, Offering, Offering Section and Activity in one row? Content (required): Is there a… -
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 675 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
How to show parameter in exacel template in fusion bi reportSummary How to show parameter in exacel template in fusion bi reportContent In BI report datamodel, I have taken parameters and build report also. Now in bi excel templa…Soumya Goswami-Oracle 68 views 6 comments 0 points Most recent by ShitalRamteke Reporting and Analytics for HCM -
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 13 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need table and field names in ORC Requisition Page->Progress SectionSummary: Need table and field names in ORC Requisition Page->Progress Section. Kindly help, below is the screen shot of the page and highlighted the fields. Progress Sec…GajavalliKoteswararao 55 views 2 comments 0 points Most recent by Ronal Khara-Oracle Reporting and Analytics for HCM
-
Fast Formula making difference between date fieldsSummary: Content (required): Hello experts, do you have an example of fast formula making the difference between dates? For example we need to create a fast formula maki… -
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 2.9K views 4 comments 0 points Most recent by Gamidi Venkat Rambabu Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.1K views 6 comments 0 points Most recent by User_CTDSJ Reporting and Analytics for HCM
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 127 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 1.9K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav…Evgeniya Repnina 32 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Reporting on rejection commentsSummary What is the name of the BI database table that stores the tracking of rejection comments for transactions?Content I was easily able to find / report on the comme…User_2025-01-28-21-53-32-678 133 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 36 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How …Consultant Ian 22 views 0 comments 0 points Started by Consultant Ian Reporting and Analytics for HCM -
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh…
-
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
BIP Report LOV becomes read-only when the number of characters increasesSummary: Content (required): I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV t…Akash Kiran Jana 56 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to send the BIP report output to dynamic email address based on the report resultsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Shlomo Elnekave 475 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…VinodKumar 578 views 6 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM
-
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 73 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 76 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM