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
-
May i know the logic to recognise revenue in open/ closed Ar and GL periodHi~, I have created a AR transaction invoice with revenue scheduling. When i closed the AR period and GL period at Sep 2024, i undergo process to recognise revenue after… -
AR Receipt Applied to Negative InvoiceScenario: An AR receipt was automatically applied to an invoice which already had a negative balance Question: Why would the system allow the receipt to apply to a negat…
-
Is there any REST API to update Customer Site Address?Summary: Thousands of customers were uploaded by using the simplified Customers FBDI. Now we realize there are many Customer Site Addresses with incorrect Postal Codes. … -
How to remove link to original order for referenced RMA using ARInterfaceLine service mappingSummary: We have business requirement to remove the link between referenced RMA and original order when RMA is interfaced to AR so we could generate on Account Credit Me…
-
Can we restrict Customer to Specific Transaction typeWe have a relationship of Customer (Customer Account) with Specific Transaction Types
-
How to remove/update values in reference_line_id filed from RA_INTERFACE_LINES_ALL table via APIWe are reaching out to request urgent assistance regarding a critical issue impacting our business operations, which we have also reported through a Service Request (SR)…
-
How to update the payment terms at the Credit Limits and Late Charges tab ( Customer site)Hi Everyone, I am uploading the customer data along with late charges information through FBDI template. I was able to upload the customer data along with late charges i…
-
Ship-to Site Number field is missing in the Receivables Transactions Real Time subject area for OTBISummary: I need to add *Ship-To Site Number field and I don't see it available under Receivables Transactions Real Time subject area. Please suggest if it's available in… -
Can we add approval workflow to automatic receipts in Oracle Fusion ReceivablesSummary: We have the requirement to add approvals to automatic receipts in receivables , do we have any option available in oracle fusion? Scenario : when user click on …
-
The right-side border is not visible in the Activities infotile.Summary: The right-side border is not visible in the Activities infotile in the Advanced Collections work area. However, when the zoom level is reduced to 33%, the borde…
-
How to resolve time out error in running a Fusion BI report specific to an user account?Summary: A specific user is getting time out error after running a report with specific parameter. But the same report with same parameter is working for another user. P…
-
Credit Authorization values counted twiceSummary: Some customers are failing credit check due to the fact that certain transactions comprised first of a Sales Order and later of an Invoice are effectively count…
-
Payment Terms getting change from Sales order to AR InvoiceSummary: We have below payment term setup Bill to site payment term- S38 Account payment term-S28 and when we created the sales order payment term showing as -S38 but wh…
-
No validations while creating bank account in bill managemeSummary: I would like to know if there is a way to check if the bank account details provided are legitimate during the time of payments in "Bill Management" portal. I s…
-
how to schedule a schedule process job using webserviceSummary: We would like to automate the Import AutoInvoice scheduled process to run daily, with today’s date passed as the interface date parameter. Currently, we are una…
-
Consolidated Customer Statementhen enabling customer statements, we are trying to consolidate multiple bill-to site activity for an account to a single consolidated statement. We followed Oracle’s rec…
-
Customer Import FBDI not updating Collaboration Messaging configurationsSummary: We would like to Mass update Customer Account Profiles to enable the required fields for using CMK (Collaboration Messaging) for: Preferred Delivery Method: XML…
-
sql query to get details from Receivables > Accounts Receivable > Manage Tax on Advance ReceiptSummary: Looking for tables and query to get details from page - Receivables > Accounts Receivable > Manage Tax on Advance Receipt The line details and tax details also …
-
How to customize email body and subject and split it by invoice number/customer name?Summary:Hi team, We request some support in modifying the SJG Dunning letter (Reminder emails for unpaid invoices). The email notification to customers/clients only rece…
-
Allow strategy to change - SignificanceSummary: What is the significane of Allow strategy to change parameter in ESS and on Setup page? Content (please ensure you mask any confidential information): Version (…
-
In case of AR Invoices how can we have the Conversion Rate Date same as Sales Order DateIn case of AR Invoices we want to capture the Conversion(Exchange Rate) Date same as Sales Order Date. System Behavior: At present it is directly getting derived as the …
-
Collection letters ErrorWhen sending the collection letters, the process ends with an error where it says "No Dunning Site Found, Looping through delinquent Billto Sites" "The contact informati… -
Purge only Error Records for AutoInvoice Interface TableSummary: Purge only Error Records for AutoInvoice Interface Table Content (please ensure you mask any confidential information): Hello Oracle Community, I’m working with…
-
Automatic receipt creation for IC invoicesSummary: HI Team, Could you let us know if there is a way to generate automatic receipts for intercompany invoices? This is a client requirement, and we would appreciate…
-
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…
-
How can we reduce the rate precision to 4 for those contra currenciesSummary: Currently in Manage Daily Rate, our contra currencies (EUR -> SGD) is populating FX rate with very long precision. It created rounding differences when the AR t…
-
Apply receipt to balance forward bill based on balance forward bill numberI wan to apply receipt manually to all the invoices which are part of single balance forward bill but there is no option to search invoices based on balance forward bill…
-
Is it possible to control invoice line ordering through autoinvoice?Summary: Is it possible to control invoice line ordering through autoinvoice? Content (please ensure you mask any confidential information): We have an integration that …
-
how to could you please help us in group assignment of collectors for dunningSummary: hi we understand as a part of configuration for dunning, we have to attach profile class (collector) to customer master and attach employee record to collector …
-
Prevent the user from changing the accounting date in Create trx with a date higher than today?In receivables, task create transaction, I must avoid that the user, for example today, issues an invoice with an accounting date higher than tomorrow, for example. At m…