BI Publisher
Discussion List
-
Receivables Billing History Extract - Unable to add custom parameter in BIP Data modelHello Experts, We have a requirement to add an extra parameter (Customer class) to the seeded report - Billing History Report. Data Model Path - /Shared Folders/Financia…Yugesh Keluskar 31 views 2 comments 0 points Most recent by Yugesh Keluskar Receivables & Collections -
Third party Balances Summary Report Differ when we run period range Group by No/YesSummary: We noticed an issue with "Third party Balances Summary Report" for source as Receivables. The issue is, the output/balances differ when we run the report for a …
-
How to get AR billing transaction note plain text without html tag ?Hi All, I'd like to build a customer report about AR billing which contains note. While I found the note in backend table contains html tags. Note in the UI: SQL result…
-
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
Retrieve all positive and negative balance associated with a customer.Hi Team, We have a requirement to generate a list of all customers whose accounts have either a positive or negative balance. Could you please provide a detailed explana…
-
How can we find Customer Details from VAT ID in Oracle ERPSummary: How can we find Customer Details from VAT ID in Oracle ERP Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Print Receivables Transactions – Historical Delivery Details Retrieval (Older than 1 Year)Hi All, Need to check if there’s any way to retrieve delivery details (email, timestamp, etc.) for invoices sent via the Print Receivables Transactions job, specifically…
-
AgingbyGeneralLedgerAccount_Understanding the Receivables Aging by GL Account ReportAgingbyGeneralLedgerAccount_The following three questions are asked about the Receivables Aging by GL Account report: ・There are 546 items when outputting CSV, but I wo…Yuma Suzuki-Oracle 1 view 0 comments 0 points Started by Yuma Suzuki-Oracle Receivables & Collections
-
ESS job is takeing more time to run the reportSummary: while scheduling report from analytics schedule report it is takeing less time to run, but while trying to run from schedule process it is takeing more time Con…Charan Kumar Reddy Lingala 33 views 8 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Add a document outside fusion which can be sent to customers using Print Receivables Transactions.Summary: We have a requirement where an additional document is required to be sent to customers along with the AR Invoice. This document is outside Oracle Fusion. Need t…Shefali Lakhani 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Can we Print incomplete AR Transactions in Print Receivables Transactions ESS JobCan we Print incomplete AR Transactions in Print Receivables Transactions ESS JobSidh 2 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to run the Create Customer Statements job for a date rangeOur Business Users want to be able to run the AR 'Create Customer Statements' job for a specific date range so as to filter out old transaction history. They also want t… -
Steps involved to integrate Oracle Fusion ERP to ZATCA using OIC integration (KSA)Summary: Need to integrate Oracle Fusion ERP to ZATCA portal. Kindly let me know the steps involved on how to create XML as per Saudi Preferred format. Content (please e…
-
Bulk Print pdf of Receivables Invoices to sftpSummary Bulk Print pdf of Receivables Invoices to sftpContent Looking for bulk extract of AR Customer invoices print version of pdfs by invoice number to sftp. Not seein…User_2025-01-28-19-49-26-512 439 views 14 comments 4 points Most recent by Ranga Swamy Ediga Receivables & Collections -
Can attachment query within bursting be updated to get attachments from OM or SMC modulesSummary: We have a business case where attachments from Order or subscription need to be sent along with invoice copies. While this is achievable by manually going and a… -
In what subject area can i find the XML delivery related fieldsSummary: On the manage transaction page, I see two fields related to electronic invoicing / XML devlivery Ready for XML Delivery XML Delivery Status XML Delivery Error M… -
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou…
-
Bursting Issue in Balance Forward Billing ReportSummary: We are encountering an issue with bursting in the customized Balance Forward Billing seeded report. Content (please ensure you mask any confidential information…
-
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t…PrerakKhandelwal 216 views 2 comments 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Customize Receivables Aging by General Ledger Account ReportSummary: Hi, We want to customize the "Receivables Aging by General Ledger Account Report" for a specific GL Account. We know how to customize/ extend a seeded ESS BIP r…
-
We are trying to customise the Standard Receivables Aging by General Ledger Account reportSummary: We are trying to customise the Standard Receivables Aging by General Ledger Account report and from the seeded output, we see that the accounted amounts has bee…
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…Radhika Sharma 196 views 6 comments 1 point Most recent by NITHIN TP-Oracle Receivables & Collections
-
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u…
-
How to get text attachment information from customised "Invoice Print Report" using SQL QuerySummary: Extract text attachment on customised "Invoice Print Report" data model when run via ESS job Content (please ensure you mask any confidential information): A si…
-
Bill-to-Customer Tax Registration NumberIn transactions, the 'Bill-to Customer Tax Registration Number' is stored in which table and column?Shireesha 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
Third-Party Control Account Balances Report - Include Zero Amount BalancesHello, In the Third-Party Control Account Balances Report there is a parameter with name "Include Zero Amount Balances", you can select either Yes or No in this paramete…
-
Customization of Create Customer Statements: Generate Log(unable to edit dataset)Summary: We have a requirement to add the receipt date and receipt number to the standard 'Create Customer Statements: Generate Log' report. We're trying to achieve this…VENKATA SWAMY BATHINA-Oracle 23 views 2 comments 0 points Most recent by VENKATA SWAMY BATHINA-Oracle Receivables & Collections
-
UNABLE TO GET THE EMAIL DELIVERY REPORT WHILE SENDING THE INVOICES TO CUSTOMER BY EMAIL BUSTINGSummary: We are currently facing a challenge with the BIP Email Bursting process used for sending invoices to customers. As part of our custom report setup, the invoices…
-
Transactions Print Data Model Lexical ReferencesSummary: Content (please ensure you mask any confidential information):In the data model Transactions Print, we added a custom line of code to the Header data set and up…Rory Mullin 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections