BI Publisher
Discussion List
-
Can we duplicate "Create Customer Statements" ess jobSummary: Hi, Can someone please help me in undrestanding if we can duplicate Create Customer Statements ess job. If yes, how do i call other child ess jobs after duplica…Shireesha 4 views 1 comment 0 points Most recent by Jeffrey Beltran-Oracle Receivables & Collections -
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…PrasadN 98 views 5 comments 0 points Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
-
How to default Invoice Template on customer basis?Summary: Content (please ensure you mask any confidential information): We have a requirement where we want to have separate invoice template on the basis of Credit card…
-
Issue while creating AR Customer Profile using we serviceHi, I tried to create Ar customer profile using the ReceivablesCustomerprofileservice webservice It was working perfectly before with me using the same combination of pa…
-
Error handling in Dunning Letters?Summary: Error handling in Dunning Letters. Example: when there is no email address or dunning recipient specified for a customer then the 'Send dunning letters' job pro…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
Request to Exclude Zero-Amount Records from Standard Customer Statement ReportHi Team, We have requirement in the standard customer statement report output and require a solution or workaround to exclude zero-amount records from the report. For re…Raman_Balasubramaniam 35 views 3 comments 0 points Most recent by User_VQFGM Receivables & Collections
-
How to fetch Customer VAT number on Sales invoice reportSummary: Could someone please help which column, table stores Customer VAT number to add in the report. I have checked in the ZX_PARTY_TAX_PROFILE table for column rep_r…
-
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 20 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…
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …
-
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…
-
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 34 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 5 views 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 36 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 6 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 Job
-
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…