To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Receivables & Collections
Discussion List
-
Accounts Receivable payment terms based on business daysWe have a need to set up Accounts Receivable payment terms to be based on business days (not weekends). Has anyone had any luck with setting this up in Cloud? The curren… -
What is the use and impact of BFB Delivery Method: Email, Portal upload and Paper?Summary: Content (please ensure you mask any confidential information): Out Client needs to have Balance Forward Billing functionality enabled for certain customers and …
-
Does Oracle support any bulk upload process or method to upload Trading Partner ID for CustomersSummary: Use case - to convert E-invocing customers in cloud and also find a way to bulk upload Trading Partner ID records in CMK Unable to upload Trading Partner ID for…
-
Does Oracle provide tables, action logs, or audit reports to track AR invoice transaction actionsHi We would like to know whether Oracle provided any tables, action logs, or audit reports to track Manual AR invoice transaction creation or modification actions. Inclu…
-
credit check functionality without creating Case FoldersSummary: Can we use the credit check functionality without creating Case Folders? Our requirement is simply to place the Sales Order (SO) on hold if the credit check fai…
-
High Volume Customer Data MigrationHi, We have a new requirement from a B2C client to convert 3 million+ customers to Oracle Cloud. I am seeking your expertise and would appreciate any best practices, str… -
Requirement for Segregation of Duties in Oracle Fusion ReceivablesBusiness Requirement: There must be a clear separation of duties between two users in the Receivables module in Oracle Fusion to enhance control and compliance. User Rol…
-
How do you upload bulk AR transactions/bank statement into the AR moduleI am trying to load Bank Statement with Receipts into the AR module. Currently we use the lockbox, but lockbox can only load 1 Bank account per lockbox, We have about 50…
-
Is possible to use the AR_EXCEPTION_TREND (Exeption reason) for SLA on account?Summary: We need to use the receipt exeption reason to define on account SLA. Content (please ensure you mask any confidential information): Version (include the version…
-
Payment made via CC in Bill Management, but it's not cleared in Fusion; invoice still unpaidPayment made via CC in Bill Management, but it's not cleared in Fusion; invoice still unpaid
-
Bulk CSV upload for Receipt Class and Method configurationHi, I am trying to load the receipt class and method configuration using CSV File. However I am getting the below errors. I am looking for working CSV File upload templa…
-
Customer Bank Account and Debit Authorization not populate when loading invoices through AutoInvoiceWhen loading Invoices via AutoInvoice for Customers with the Receipt Method of Automatic for Direct Debits, the Customer Bank Account and Debit Authorization does not po…
-
What is the character limit for a collections note?Summary: Is there documentation on the character limit for a transaction note in Collections? Content (please ensure you mask any confidential information): In Collectio…
-
You must enter a combination of the {COLUMN1} and {COLUMN2} columns that's unique in the {TABLE_NAMESummary: loading customers and getting the above error The combination of columns {COLUMN1} and {COLUMN2} must be unique in table {TABLE_NAME}. Not sure what to correct …
-
How to apply credit memo to an invoice using FBDI template ,Can someone please share the example?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to create a reverse receipt or receipt reversal in Fusion Cloud via REST APISummary: How to create a reverse receipt or receipt reversal in Fusion Cloud via REST API Content (please ensure you mask any confidential information): Version (include…
-
Different Print Receivable invoice template for Receivables and Project AccountingSummary: Is there a way to to have different Print Receivable invoice template for Receivables and Project Accounting in ESS job and in Manage Transaction(AR module) UI …
-
CMK-AR Customer configure as B2B Trading Partner and Customer Account Collaboration using SOAP/RESTSummary: Hi Team, We are setting up customers in AR, and there is a need to send AR Invoices through CMK, for that purpose we need to enable the below configurations to …
-
API to update INTERFACE_STATUS column to 'P' for RA_INTERFACE_LINES_ALL tableHi Team, We need to update INTERFACE_STATUS column to 'P' for RA_INTERFACE_LINES_ALL table. Is any webservice which we can use to update AR invoice interface table.
-
Generate Audit reportsSummary: We need confirmation from Oracle on two points to address the audit related questions, 1.We are testing the audit reports after updating email id/phone in the c…
-
How can we make the 'Description' field mandatory in Collections Activities?Summary: Hello, We have a requirement to make a field mandatory on the Collections Dashboard. In the Collections Activity section, we need to make the 'Description' fiel…
-
Oracle Fusion Pre-delinquent Dunning Setup DocumentCan someone please help me with documentation or guidance related to Oracle Fusion Pre-delinquent Dunning setups? I’m specifically looking for a detailed setup/configura…
-
Automate AR Receipts creation from BAI2 fileSummary: The business requires the creation of AR receipts using a consolidated BAI2 file that includes transactions from multiple bank accounts and modules (AP, AR, and…
-
How to make Site details, Tax profile and Profile history tabs under customer site as view onlyHi Experts, I have created a Custom role "MD_Customer_Payment_details_Custom" to allow the user to have View /read only access for these tab - Site details, Tax profile,…
-
SQL query to fetch all notifications/emails sent by Fusion for AR invoice print.We need to extract all notifications/Approval/email notifications that are triggered in Fusion within a specific time range. If the Print Receivable Transaction ESS is r…
-
System has not created the Credit Memo from disputeSummary: We have come across a scenario where the AR invoice is for 51,150 AUD. Now, the user is submitting the dispute for 1.60 for specific line. So while submitting t…
-
Miscellaneous receipt via SOAP web service after 25C Patch is failingAfter applying 25C Patch , Misc receipt creation is failing . When MiscellaneousReceiptDistributionsService is not provided , the upload is failing . TDocumentation says… -
How to receive callback for Import Receivables Transactions Using AutoInvoiceSummary: Since we cant call "Import Receivables Transactions Using AutoInvoice" via ERP adapter, we are using erpIntegrationservice as per guidance given below in How to…
-
two WHT tax regimes: CIS and PSC,while for PSC we do not want a tax authority invoice to be generateSummary: I have two WHT tax regimes: CIS and PSC. For CIS, we require the system to generate a tax authority invoice, while for PSC we do not want a tax authority invoic…
-
How to do Multiple Receivables accounts on a single invoice in Oracle Fusion?Summary: How to do Multiple Receivables accounts on a single invoice in Oracle Fusion? Content (please ensure you mask any confidential information): Requirement is to h…