Category 338-2
Discussion List
-
OTBI - Customer Credit - Last Review Date / Next Review Date Missing?Hello, We are looking to pull the Last Review Date and Next Review Date areas of the customer account profile history to an OTBI report. I cannot locate these fields to … -
How to add Batch Source context to RA_CUSTOMER_TRX DFF?Summary: We try to use transaction header DFF with batch source context. Initially we have defined batch source contexts and leave the select action to user. However, it… -
Credit Memo Tax Rate is IncorrectCredit Memo Tax Rate is Incorrect 6% Rate is entered on the Line but when saving the Credit memo the default tax rate is being applied. -
AR transaction numbering for Complete and Incomplete TransactionsSummary: Hello Team - I have all AR transactions (invoices, credit memo) setup for approval. The transactions in complete status are getting created with 3001, 3002 etc …Sreerag Narayanan 8 views 0 comments 0 points Started by Sreerag Narayanan Receivables & Collections -
Customer is live on Oracle Receivables for some time but wants to enable AR statements nowHi, Customer is live on Oracle Receivables for some time but wants to enable AR Statements now. As per functionality the first statement will print all the transactions … -
Autoinvoice error asking for Invoicing rule and Revenue Schedule ruleSummary: Content (please ensure you mask any confidential information): We are encountering an issue where Sales Order 9990061 (Customer Shipment), created from the CPQ … -
AR Consolidated Remittance AdviceWe are looking to enhance our Accounts Receivable communication process. Currently, our Oracle system triggers a separate remittance advice email for every transaction a… -
Inquiry Regarding Expansion of DFF Attributes for RA_CUSTOMER_TRX Flexfield codeSummary: Hi All, For the RA_CUSTOMER_TRX DFF (Descriptive Flexfield) code for AR billing transactions, we currently have Attributes 1 through 15 available, and all avail…JoginderSinghChopra 26 views 1 comment 0 points Most recent by Sridhar_Rejeti_1423 Receivables & Collections -
Customer Import FBDI DFF to update with null or blank valueI am using Customer Import FBDI to update TCA Customer Accounts descriptive flexfields (DFF, e.g. attribute14 in HZ_CUST_ACCOUNTS table) with blank or null value. It is … -
Setup for Automating AP Payment Creation from AR Receipt Refunds in Oracle FusionI would like to know how to configure the system so that when I perform a receipt refund in AR, an AP payment (payment request) is automatically created. Could you expla… -
Receivable Receipt Recommendation using Auto match rule setDuring auto lock box receipt process- Receivables applies receipts to transactions based on the transaction information provided. But Auto match rule, showing some more … -
Is it possiable to customize "Create Receivables Receipt" privileges?Summary: We have a new requirement: To seperate create receipt function and application or unapplication function. But these functions are from "Create Receivables Recei… -
Import Trading Community Data in BulkSummary: Hi All, I am having an issue trying to import customers through ERP adapter in OIC. I could successfully load the files in interface table but theImport Trading…Sumana Bhattacharjee_ 467 views 26 comments 1 point Most recent by Sumana Bhattacharjee EC Receivables & Collections -
How can I automatically apply the receipt on the Transaction with the same transaction number?How can I automatically apply the receipt on the Transaction with the same transaction number both of the transaction ? there is an integration with a third party (Magen… -
API cannot update delivery method on invoiceSummary: We want to update delivery method on AR transaction through API, but it is not allowing us to update/save any value. Content (please ensure you mask any confide… -
How to exclude Credit memos from paid invoice adjustment-"Create Automatic Billing Adjustments?Summary: The issue we are encountering now is that when we have an invoice that has a credit memo applied and the remaining balance is less than +/- $500, it is getting …Manoj Kr P-Oracle 32 views 3 comments 0 points Most recent by Soumajit Karmakar Receivables & Collections -
How to Configure Strategy Tasks on the basis of due datesHi Team, My Client wanted to configure the Automatic Strategy task to send the Reminder Letters to client on the basis of due dates. Can someone please help me how to co… -
How do we delete an existing Customer Contact role at the Account Site Level using FBDI or API?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manikanta reddy Jaripothula 12 views 0 comments 0 points Started by Manikanta reddy Jaripothula Receivables & Collections -
Please explain step by step - for processing Receivable receipts via FBDI template in Fusion 25CHi How Process FBDI template for Receivable Receipt using Auto Lock Box setup Auto Lockbox Setup: Completed successfully.AR Receivable Receipt Template: Prepared and val… -
Is there any way to know which invoices are successfully printedSummary: Is there a way to determine which invoices had print receivable transactions successfully generated, the output was delivered to the customer, and the delivery … -
Unable to Reject Adjustment for transactionsSummary: Approver is not able to reject the adjustments for the transactions. Getting error "arp_process_adjustment update exception: ORA-01403:no data found(AR-855636)"…Rohit Kumar Singh 74 views 4 comments 0 points Most recent by Sharon Harper Receivables & Collections -
How to send a notification to user while creation of AR invoiceWe need to trigger a notification or alert to the user during the creation of an AR Invoice if there are any available prepayments for the customer. This is necessary be… -
How to apply a receipt on another receipt via webservice?How to achieve above operation from REST/SOAP webservice? -
Auto Cash Rule -Clear the Past Due invoice group by payment termI have a customer with multiple invoices and want to apply a receipt using the FBDI template to clear past-due invoices grouped by Payment Term. The receipt is a single … -
Unable to create an AR receipt using Receipt API receive error FND-UNIQUE-ALWAYS USED using ReceiptSummary: Hi, I am using Unable to create a receipt in receivables module using receive error FND-UNIQUE-ALWAYS USED - FND 01. Our sequence is set to Gapless and Manual. … -
How to get the Highest credit limit usage value for customer wise?We developing credit snapshot report, How to get the Highest credit limit usage value for customer wise? From the time the customer is in Oracle Cloud what is the highes… -
Automatic Offset Accounting for Small Payment Variances (Bank Fees)There are cases where small differences such as bank fees occur between the receivable amount and the actual payment amount. In such cases, is it possible to automatical… -
Manage Transaction Types I could not find ORA_JEPL_TRX_TYPE Like ZAL , VAT etcSummary: After enabling the Poland Localization and Deploying the Receivable Transactions for Regional also could not fine the ORA_JEPL_TRX_TYPE Like ZAL , VAT etc to at…Satya Prasad Chamana 8 views 1 comment 0 points Most recent by Satya Prasad Chamana Receivables & Collections -
How to update global DFF on AR Invoice using SOAPAs part of the Poland e-Invoicing initiative, we need to capture the KSeF number (GLOBAL_ATTRIBUTE9) in Oracle Accounts Receivable (AR). However, we are experiencing iss… -
How to reprocess an XML AR invoiceWhen we are sending a XML invoice thru CMK, it might happen that some information are not correct and that invoice cannot be routed to the customer. If we correct them a…