BI Publisher
Discussion List
-
Request for Solution & Documentation on Oracle Fusion ERP Integration with ZATCA for AR invoicesSummary: We are currently working on implementing e-Invoicing compliance for Saudi Arabia (KSA) and need to integrate Oracle Fusion ERP with the ZATCA portal in accordan… -
New Parameter to Oracle Data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag… -
How to Enable EFF on AR Invoice not DFFSummary: How to Enable EFF on AR Invoices not DFF Content (please ensure you mask any confidential information): Due to limitation of DFF attributes list on AR Invoice, …
-
Rejection reason message need to be printed in the Reversal Status ReportHi Oracle community, I hope this message finds you well. We have encountered a scenario where different levels of rejection reason message need to be printed in the Reve…
-
To update the "Send statement" box, we use the REST API for Customer profile.Summary: to update the "Send Statement" checkbox for a customer in Oracle Fusion do we have the rest api and If yes what it is Content (please ensure you mask any confid…
-
How to get XML extract "Funds Capture Payer Notification" ReportHow to get XML extract "Funds Capture Payer Notification" Report https://docs.oracle.com/en/cloud/saas/financials/24d/faofc/funds-capture-payer-notification-reports.html…CA Nirmal Choudhary 21 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
How do we split the invoice and supporting attachments into separate files in Print ReceivablesCurrent State : Invoice and supporting attachments are sent as one file to the customer from the client when they run the Print Receivables Job in Oracle Fusion Requirem…
-
Add parameter to Seeded report- Statement Generation data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
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 3 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 444 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 238 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 204 views 6 comments 1 point Most recent by NITHIN TP-Oracle Receivables & Collections