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
-
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… -
How to stop creating the bank account while importing lockbox file to Oracle?While importing the lockbox, the system is creating a new bank account for every payment by associating an MICR to the customer account. Is there a configuration availab…
-
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…
-
Need to customize receipt write off approval through BPM workflowSummary: We have the following business requirements related to the Receipt Write Off process: Notification on Insufficient Limit: The system should notify the user when…
-
FBDI AR:- Data Imported in Interface Table but Not Getting Picked During Import AutoInvoiceHi Team, We are loading AR invoices using FBDI in Oracle Fusion. The data is getting successfully imported into the interface table (RA_INTERFACE_LINES_ALL), but while r… -
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…
-
How do automatically add invoice lines when order and invoice amount is less than a threshold?How do automatically add invoice lines when order and invoice amount is less than a threshold? -
How to set up Receivables Payment Term with Cut off Date?Summary: Receivables Payment Term with Cut off Date Content (required): For Exp: "Term Logic= If Invoiced upto 26th of the month, due date is 25/24th etc(as required) of…
-
Can multiple remitted receipts create a single journal entry and appear as one system transaction?"How can I modify the SLA account rules and system transaction grouping setup in Oracle Fusion so that multiple remitted receipts create a single journal entry and appea…
-
Automatic receipt generation for Cross-currency TransactionsCross-Currency Automatic Receipt Generation. Example : Transaction in Functional Currency. But received payment in multicurrency(other than Functional Currency) from Cus…
-
Is there a detailed document on setting up AR E-invoicing for Germany and SwitzerlandSummary: The legal basis for electronic invoicing in Germany’s federal administration is the E-Invoicing Ordinance.−The Ordinance specifies requirements for the invoice …
-
Lockbox FBDI import going into errorHi team - I am trying to import data to the lockbox via FBDI where I am using "Default lockbox" as my Transmission Format, and my Lockbox Accounting Data Source is set t…
-
Cannot see the full list of AR approvalIf the bad debt adjustment is over approver A's approval limit, Approver A cannot see the pending approval in the transaction listing. How can all the approval item be s…
-
Collection Metrics Dashboard for all the customersHi Team, In 25B Oracle released the solution to access to collection metrics with operative roles, instead of AIC role. We would like to know if there is a way to see th…
-
Credit Card Customer Payments Failing in Bill Management Portal.Summary: We have tried make a credit card Payment from the Oracle Bill Management Portal using CyberSource gateway. We are getting below error message The payment system…
-
How to prevent the automatic application of credit memos created in Contracts to AR TransactionsSummary: Credit Memo created in Contract are applied to AR transactions automatically even when the Transaction is fully receipt. We would like to stop this auto applica…
-
How to group PPM invoices into single AR InvoiceSummary: We are creating two invoices from PPM and interfacing them with Accounts Receivable. We want these two PPM invoices to create a single invoice in AR, however, a…
-
AR Receipt acounting ->How to seperate discount applied transaction amount and tax amountHi Team, In the receipt print screen ->’Discount amount’ is applied transaction total including tax amount. So when looked at receipt accounting entries, there is only o…
-
Is it possible to based invoice due date on actual delivery date?Summary: Invoice due date should be based on delivery date instead of invoice date or shipping date. Content (please ensure you mask any confidential information): We st… -
Facing error 'Attribute Receipt Source Type in ReceiptSourceManageUI1 is required' in Receipt SourceFacing error 'Attribute Receipt Source Type in ReceiptSourceManageUI1 is required.' Not sure what this means and if it has any impact on any receipt related functionalit… -
Is it possible to include all dunning contacts in one dunning emailSummary: I believe for Print Receivables it is possible to have the invoice TO emails all included in the one email to all the contacts. I would like to know if this is …
-
XSL style sheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
E-invoicing for GermanySummary: How to implement Germany E-Invoicing (AR & AP) Using Service Provider & Peppol Network Content (please ensure you mask any confidential information): Which serv…
-
Logic behind customer bank details updating at receipt level under customer and remittance bank tab.While we are uploading the MICR details Through lock box. Lock box file has multiple MICR details , want to know on what basis it is picking customer bank details. Recei…
-
clarification of setup steps for AR e-invoicingSummary: How to make the right setups for AR e-invoicing to Business Partners through a local Service Provider which is not seeded? Do I need to set up CMK, B2B Adapter …
-
To Update the Transaction Date and GL Date field values in the RA Interface table through API / OIC.Summary: In our business scenario, Sales Orders get created and the DOO will post the data into RA_Interface table. However, before importing the data to create AR Invoi…
-
Create settlement batch ESS JOB is not visiblei want to auto schedule the Fund Capture process, I am able to see create automatic receipt and create Remittance batch both the program Create Settlement batch is not v…
-
Can restrict account CoA when creating debit note/credit note in AR moduleHi, Can we restrict the selection of account CoA when creating debit note/credit note in AR module?
-
Cash Application RequirementOur client uses FTNI for cash application. They're implementing Oracle Receivables for financial management. There’s a challenge with handling unapplied receipts, especi…
-
How to Exclude prepaid transactions from Dunning lettersI have a request from our Business to Exclude transactions considered as prepaid. So they have been paid in advance and the transaction has a due date the same as the tr…