BI Publisher
Discussion List
-
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any… -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 33 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached DocSummary: This post shares a comprehensive SQL query that retrieves detailed Contract information from Oracle Fusion ERP Cloud, especially for ECM_BUY contracts. It conso… -
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi…User_2025-02-05-10-38-08-223 170 views 6 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for ERP -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 77 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 3.8K views 53 comments 20 points Most recent by Aitor Quintela Reporting and Analytics for ERP
-
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 44 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
Is there any base table for privilege master along with table to map privilege table with roles?Summary: Hello experts, We are trying to create a BIP query to map the user to role and role to privilege. Previously we were using the "ASE" tables for this purpose, bu…
-
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 31 views 6 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
Tracking bounced back emails Print Receivables TransactionsAR invoices need to be delivered through email to customer email ID. Is there any tracking mechanism to monitor the bounce back? So that, a valid email address can be ob… -
Table to view Project Expenses Mass Adjustment Reason and TypeSummary: Which table can I use to get the "Adjustment type" and "Adjustment Reason" for mass adjustments made against Project Expenses. I found the table PJC_TXN_MASS_AD… -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 1.8K views 10 comments 3 points Most recent by PadmanabhamP Reporting and Analytics for ERP -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 995 views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 3 views 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 2 views 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Trigger email notification when approver has requested more information on a requisition.Hi All, I'm trying to implement a change where an email notification should be triggered when an approver has requested more information on a requisition. I'm editing ex…Evanshi Vasani 52 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 664 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP
-
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 2 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty…
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP