BI Publisher
Discussion List
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 32 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f … -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 11 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.3K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 55 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 22 views 1 comment 0 points Most recent by Srikanth Nakka Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an… -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 26 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_valuesHello Hope everyone is doing well! I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below quer…Gaurav Bhardwaj 17 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 121 views 2 comments 1 point Most recent by Showstopper09 Human Capital Management -
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a …Bindu Janoti-Oracle 59 views 4 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont… -
Help with Extracting L1/L2/L3 Managers in ReportsHi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in speci… -
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer… -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.7K views 10 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 1 view 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 471 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…Yeung Shing Keith 11 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for HCM -
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,… -
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need … -
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): I have the attached query. Everything works just fine without the fina…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur… -
Does any schedule process or reports show customer credit funding without enable credit management?Summary: Does any schedule process or reports show customer credit funding without enable credit management? Content (please ensure you mask any confidential informatio… -
BI Publisher - RTF template - write a numeric value in lettersSummary Need to write in letters a numeric value from a BIP fieldContent Hello, I am creating a RTF template that I want to display as a report in BI Publisher. In this …Alice Gouzy 123 views 13 comments 1 point Most recent by Ravi Tilekar Reporting and Analytics for HCM -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 31 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM -
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 962 views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical… -
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM