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
-
Applying Closed invoices on a Receipt via Apply Receipts APISummary: We are created a VBCS application to Apply a Invoice on a Receipt and It uses Apply Receipt (Standard Receipt application) API to Apply a Receipt. But while Pas… -
Rest API to create customer relationship at Customer levelHello, I've managed to create a customer account relationship at Customer level with crmService/CustomerAccountService SOAP Service. Can we do the same creation but with…
-
sample query to check Invoice/Credit Memo has been posted to GL?Hi Team, Need sample sql query to check Invoice/Credit Memo has been posted to GL or not in oracle cloud.
-
exclude non receivable balances calculation in AR to GL REconciliationI have recently started using a natural account in AR product and for enabling its Reconciliation, i changed the financial category of this account to Accounts receivabl…
-
We need a query to retrieve the AR remittance batch approver's name and approval dateHi, We have arequirement to retrieve the approver name and approval date for a remittancebatch. Could you please confirm if there’s an existing table, column, or queryth…
-
How to disable auto application of receipts for specific customerSummary: How to disable auto application of receipts for specific customer Content (please ensure you mask any confidential information): There are few customers which s… -
Is there a Rest API to unapply credit memos from invoicesSummary: Hello Experts, wanted to see if there is a Rest API that Oracle has to unapply credits from invoices. Currently our invoices process manually unapply them from …
-
How can we account the discounts in Sales Order Invoices in separate Revenue/Discount accounts ?Summary: Requirement is to capture discounts in separate account (other than Revenue account) Sales Order : List Price - $100.00 Discount1 - $5.00 Discount2 - $6.00 Disc…
-
Send Dunning Letters- Dunning Delivery ErrorSend Dunning Letters is ending in Error, the Dunning Letter is generated as a PDF in the subprocess, but delivery is failing. The error details in Dunning Delivery proce… -
Camt.053 and Statment IDSummary: I need to reconcile bank statements in CAMT.053 format with the system transactions. There is a field named 'Statement ID' while submitting for reconciliation i…
-
How do you set an alias for the name of an organization, account, or site in Receivables CloudIs there a way to input an alias for customer information in ERP Cloud, Receivables > Billing > Manage Customers?
-
While submitting the 'Create Customer Statement' job, the 'Create subprocess errorsSubmitted Create Customer Statement with Below parameters: Transaction Business Unit- Generate Bill- Bucket- Cycle- Statement Date- As off Date- After submission ch…
-
REST API to update Activities in CollectionsSummary: Is there Any REST API to create activities in Advanced collections module Content (please ensure you mask any confidential information): Version (include the ve…
-
Intercompany Flag is populated on Converted AR TransactionsHi Team, We have converted few Open AR Transaction with the help of FBDI for an account which is an internal customer account but in FBDI we have converted similar to th…
-
How to update REFERENCE_LINE_ID in AutoInvoice interface tableSummary: How to update REFERENCE_LINE_ID in RA_INTERFACES_LINES_ALL AutoInvoice interface table in integration (without using ADFDI, preferably using a webservice or pac…
-
Set RA_INTERFACE_HEADER segment value through Auto Invoice import templateSummary: I want to set RA_INTERFACE_HEADER segment value and RA_CUSTOMER_TRX segment value through Auto Invoice import template in one time. Content: I set Contract Invo…
-
how to create default payment system for this payeeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to register a shared contact for different parties in bill managementSummary: We have a requirement to register a person (contact) assigned to multiple customer parties for Bill Management. Content (please ensure you mask any confidential…
-
Customer Payment using Payment processorSummary:We have a existing Payment processor named as EPX. We would like to use that as our payment processor for our customer payments. Is that possible in ERP Cloud li…
-
During the Merge process, where the impacted Transactions are getting stored?Hi, We have an option to merge one customer (ABC) with another (XYZ). After the Customer Merge Process, the Merged customer (XYZ) is reflected in the already created tra…
-
What is the table for Manage Receivable Document Sequence?Summary: What is the table for Manage Receivable Document Sequence? We wanted to extract the data for business purpose but unable to find the table for this form, does a…
-
Error while uploading contact from simplified customer spreadsheetSummary: I am not able to add contact for a customer using the simplified customer spreadsheet. The customer successfully loads but the contact is failing. Attached the …
-
Unable to update AR Transaction Invoicing ruleSummary: Hi Team, We have a scenario where data was imported without Invoicing rule and revenue scheduling data accidentally. After import is completed, we are unable to…
-
Auto create AR customer Receipts based on Bank statement linesSummary: Is there any feature/ solution whereby we can auto create AR customer receipts based on Bank statement Lines? We have voluminous receipts deposited by customer …
-
Tax Invoice Printing Options does not work accordinglySummary: Set the Tax Invoice printing option to Itemize and Sum; however, when printing an invoice it still only shows the the total Sum of the the tax. Is this feature …
-
Lockbox ORACLE EXTENDED BAI2 fileSummary: Hi Team, The client has below 2 requirements to load a lockbox file (ORA_EXTENDED_BAI2) , where a single receipt (record 6) may contain multiple transactions (r…
-
Credit Memo application Via LockboxSummary: Is it possible to apply the credit memo in the overflow (record4) using the auto lockbox BAI2 extended generic format Content (please ensure you mask any confid…
-
How to bulk upload info on mailstop at customer site address levelSummary: Hi Experts, How to bulk upload info on mailstop at customer site address level?Pls help. Content (please ensure you mask any confidential information): Version …
-
Send Dunning Letters log says contact information is missing for customer, we require SQL queries.Summary: Send Dunning Letters log says contact information is missing for customer; we require SQL queries to create custom report to add these error detail of the custo…
-
REST/SOAP service to Remove Credit Memo ApplicationWe are looking for an API/SOAP service which will allow us to remove the application of a credit memo to an invoice. This can be done via the UI: Receivables > Accounts …