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
-
Rounding AccountWe have created an AR transaction and applied a credit memo to it, the invoice belonged to Canada Business unit, but the currency was used was US dollars the transaction… -
Rest API or Soap Service to get Attribute4 value from HZ_CUST_ACCT_SITES_ALL tableSummary: Requirement is to get Attribute4 value from HZ_CUST_ACCT_SITES_ALL table using a Rest API or a SOAP Service Content (please ensure you mask any confidential inf…
-
How to create standard receipts in spreadsheet?Summary: We have reviewed the spreadsheet file but couldn’t find a column to apply the receipt to the invoice number. Therefore, we would like to know how to perform thi…
-
Privilege to view TaxPayerIdentification Number on Customer screen and ReportSummary: If we assign 'Application Implementation Consultant' role then we can see 'Taxpayer Identification Number' on Receivables Customer screen and also in hz_parties…
-
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…
-
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? -
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… -
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…
-
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…
-
24D Transaction review and control still showing incomplete action after approvalsSummary: 24D Transaction review and control still showing incomplete action after approvals Content (please ensure you mask any confidential information): We also tested…
-
Delinquent invoices are not being selected by Send Dunning Letters jobSummary Error - A dunning letter is not generated because there are no valid transactions to be included in the dunning letter.Content Any idea why Delinquent invoices a…