BI Publisher
Discussion List
-
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…Nirosha Yelicherla 3 views 0 comments 0 points Started by Nirosha Yelicherla Receivables & Collections -
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…
-
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 …Adriana Martins 1.2K views 7 comments 1 point Most recent by KarthikDamamkar Receivables & Collections
-
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a …
-
Each line must have a unique combination of INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE valuSummary: Hi team, I was trying to test one edge case, where I wanted to process already imported invoices. but few errored out with Duplicate invoice number which is exp…
-
Ability to store Email ID on Order and then use it for sending invoices to customerSummary: Content (please ensure you mask any confidential information): Need an ability to capture ordering email id for credit card customers and use that to send an em…
-
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 8 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 106 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 39 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…
-
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