BI Publisher
Discussion List
-
Unable to pull E-Signature details from RequisitionSummary: I am looking to extract E-signature information, specifically the flow name, signature date and time, and the signer’s identity. My current approach joins IRC_A…Sandeep Aravindakshan 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…Sammeta Srividya 12 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Empty per_person_secured_list_v and per_assignment_secured_list_vSummary: I have admin profile but secured views are empty. Content (please ensure you mask any confidential information): I have admin profile but the following queries …Stefano_Mazzocca 408 views 7 comments 0 points Most recent by mgoswami Reporting and Analytics for HCM -
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…Raghavendra M 4 views 0 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 171 views 2 comments 0 points Most recent by Dineshkumar.A-Oracle Reporting and Analytics for SCM
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 11 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to save my preferred filter within the dashboard?Users cannot save or retain their own personal filters in the reports or dashboards. I understand that we can only configure default report filters/parameters - this fea… -
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …Welsey 4.5K views 6 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is there a way to fetch journal lines details which were updated while running the import correctionSummary: We have a requirement to create the BIP Report and show only journal lines which were updated while running the import correction process. Kindly let me know th…Basavaraj Navalagi 2 views 1 comment 0 points Most recent by Ganesh G.R. General Ledger & Intercompany -
Send Separate Remittance AdviceSummary Send Separate Remittance Advice process completes successfully but mail notification not receivedContent Hi All, We have Setup the Separate Remittance Advice and…Surya Muralidharan-185000 154 views 14 comments 1 point Most recent by User_H3XVX Payables, Payments & Cash Management
-
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
Custom lovSummary: How to incorporate custom lov Content (please ensure you mask any confidential information): I have an existing audit report which has two prompts. 1. Employee …
-
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…User_IYN7Q 909 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Standard report to provide Cost, YTD and Depreciation Reserve before running Depreciation programIs there any standard report which will provide the Cost, YTD depreciation and Depreciation reserve of assets after mass additions/mass copy in tax book before running t…
-
Learning Assessments (Exams/Scoring Questionnaires)Summary: The data associated them is held with the Talent and Performance area of Fusion. We need a report that can be run by a 'Learning - Read Only' role (and the Lear…
-
Query to fetch the item wise lots with the on-hand per subinventorySummary: Request to have a select query to fetch the item wise lots with the on-hand per subinventory Content (please ensure you mask any confidential information): We h…Mamdouh Ahmed 21 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…
-
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 324 views 6 comments 0 points Most recent by User_MFDCB Payables, Payments & Cash Management
-
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… -
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 39 views 0 comments 1 point Most recent by Noorul Ariff1986 Reporting and Analytics for ERP
-
Print Receivables Transaction Programwe are looking for an option to generate one email in one run with multiple AR invoice PDF attachments? we understand this is not possible through print receivables stan…Champion_Homes_Phani 2 views 2 comments 0 points Most recent by Champion_Homes_Phani Receivables & Collections
-
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t…SAI KOMATIREDDY 15 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 85 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 71 views 9 comments 0 points Most recent by Surjith Kumar Reporting and Analytics for HCM
-
Can anyone help to understand from where data is coming from Intercompany Reconciliation DashboardSummary: We are looking to build a report based on the data coming from this dashboard, can anyone please help to understand from where is the data appearing into this d…Fazil_Shahid_Khan 1 view 0 comments 0 points Most recent by Fazil_Shahid_Khan General Ledger & Intercompany
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
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.1K views 28 comments 2 points Most recent by Veeru S M-Oracle Reporting and Analytics for HCM -
HDL Error Updating ActivityAttemptActualEffort for Completed RecordHello, we are trying to update ActivityAttemptActualEffort via HDL using LearningRecordActivityAttemptV3 for a learning record already in Completed status. The HDL file …