BI Publisher
Discussion List
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.4K views 29 comments 2 points Most recent by Prashant_Kadlag Reporting and Analytics for HCM -
Auto-Populate Employee Information from HCM When Creating an Expense Report in Header SectorSummary: When an employee creates an expense report in Oracle Expenses, the employee's address information is not readily visible in the expense report header. This ofte… -
Is PER_ACTION_OCCURRENCES.CREATED_BY reliable for identifying the initiator?Summary: We use PER_ACTION_OCCURRENCES in our HCM reporting to identify who initiated an assignment transaction (Employee, Manager or HR). Historically, CREATED_BY has b…SimonG 29 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Oracle HCM Reporting - Disable or Hide Parameter Based on Selection of Another ParameterSummary: We have two report parameters, Payroll Name and Consolidation Set, and need to make them mutually exclusive. When a value is selected for Payroll Name, the Cons…HariPrasad$24 47 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o…Abhilash K - Deloitte USI 13 views 1 comment 0 points Most recent by Sabarish Reddy Ganda Reporting and Analytics for ERP -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 26 views 9 comments 0 points Most recent by User_16WBA Reporting and Analytics for HCM
-
How to call ESS job by API erpintegrationsHi Experts, I 'm trying to execute ESS job "General Ledger Trial Balances Report" by API erpintegrations in postman. POST https://xx.fa.us2.oraclecloud.com:443/fscmRestA…Marcos Allonso-53979 72 views 4 comments 0 points Most recent by Tanya Matani General Ledger & Intercompany -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…soureddy 938 views 99 comments 12 points Most recent by CA Nirmal Choudhary Receivables & Collections
-
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3.3K views 7 comments 0 points Most recent by Consultant Ian HCM Extract
-
what is column for Taxpayer Identification Number (TIN) for customers in OracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BICC Extract Failures with "Error occurs while calling remote service ADFService11G" after 26CUpdateSummary: We have been experiencing intermittent failures with several BICC extracts following the Oracle Fusion Cloud Applications 26C update. The failures started appea…
-
Is there a way to identify if the business unit name is hardcoded in extracts or reports in hcmWe renamed the Business unit and this will have an impact on the seeded/custom reports and extracts so we wanted to do a global search using the string/hardcoded value l…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti…Phani Sajja 357 views 9 comments 1 point Most recent by Consultant Ian Reporting and Analytics for HCM -
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming… -
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t… -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…Sunny G 51 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages …Rajdeep_Chavda 31 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Can we use SQL table field in alert composer templateSummary: Hello experts, How can we use SQL table field in alert composer template? we are using SQL in filtering condition to pull our population and want to use SENIORI…
-
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma…Velidi Supraja 559 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
Issue with bursting queryHi, Facing some issue with custom email notification for overdue learning in the learning module. Have developed a SQL query with bursting but employees are receiving mu… -
Replicating a few dozen Fusion tables to ADB for heavy reporting: what worked and what brokeThere was an error rendering this rich post.ANTHONY DANSO-LARTEY 17 views 0 comments 0 points Started by ANTHONY DANSO-LARTEY Reporting and Analytics for ERP
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 90 views 12 comments 0 points Most recent by User_H0GYP Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 263 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for HCM
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…
-
BI Publisher empty column missing from csv outputSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Shruthi Sadanand 23 views 1 comment 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…Lydia Jayasingh 217 views 8 comments 0 points Most recent by Vinoth_BI Reporting and Analytics for ERP
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …ScottLCIS 67 views 5 comments 0 points Most recent by Pankaj Toshniwal-Oracle Reporting and Analytics for HCM