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
-
Err-There are multiple records in this file which resolve to the same target record in the databasewe have been using 19-tab for initial customer upload and 4 tab to update Bill-to site, Additional Address elements and Reference Accounts (with references used in 19 ta… -
How to suppress customer statements for no activity and $0 balance?Customer Profile Class has a minimum statement value of .01 USD for all customers. All customers are invoice in USD. There is no activity for the customer for the month.…
-
SLA rule is not working if input source is selected as one of the DFF for Credit MemosSLA rule is not working for Credit Memo Transactions. Same input source "Ship from" is working for AR Invoice, but not for Credit Memo. Ship From is one of the DFF attri…
-
How to merge customer accounts and sites through FBDI?Summary: We have a request for bulk Customer account and site merge, so we are looking for an option through the FBDI merge process. Is it possible to merge customers th…
-
Feasibility of Applying Credit Memos to Transactions for Different CustomersSummary: We have a requirement to apply credit memos to transactions that belong to different customers. Could you please confirm the feasibility of this functionality? …
-
Is there a way to update AR_INTERFACE_LINES for source DOOSummary: We need to update some fields in the AR interface lines for international ocean shipments but API AR_AUTOINV_INTF_PKG.UPDATE_INTERFACE_LINES is deprecated and n…
-
Is there an available API to create or update Remittance Batches for receipts?Summary: Is there any available API to create or update Remittance Batch for receipts? We need to create a remittance batch and attach receipts to it via integration. In…
-
Sources not available under Conditions section while defining Accounting Rules in ARSummary: "Transaction Source Name" not available under Conditions section while defining Accounting Rules in Receivables. i) I ran "Create and assign subledger sources" …
-
How to fetch Customer VAT number on Sales invoice reportSummary: Could someone please help which column, table stores Customer VAT number to add in the report. I have checked in the ZX_PARTY_TAX_PROFILE table for column rep_r…
-
Why is Account rule to get cost center not working for Credit Memo JERS?Summary: We have created an account rule to get cost center and attached it to Invoice and Credit Memo it is working fine for Invoice, but it is not picking up the corre… -
Could not find "Payment netting" activity type in receivables activities.We are trying to receipt on receipt application and we are encountering an error You must assign a general ledger account to the payment netting activity. (AR-856100) Ou…
-
Print receivables transaction does not trigger the Upload Receivables Transaction processSummary: print Receivables transaction does not trigger the Upload receivables transaction process. I have the lookup setup available that enables this feature Content (…
-
Exchange rate type is different in AR Invoice as compared to SOHi all. It has been observed that exchange rate type used in pricing strategy for an item on SO is not passed to AR. It always default the rate type to Corporate though … -
What is the standard accounting process for BFB invoices?Summary: Content (please ensure you mask any confidential information): We have BFB enabled for the customers, where cycle like Daily, Weekly, Semi Monthly and Monthly a…
-
Why legal entity on AR invoice is not defaulting from Transaction Type?Summary: Content (please ensure you mask any confidential information): We have made a logic where Transaction Type on the Autoinvoiced invoice coming out of Order Manag…
-
How to create Custom Role for AR Specialist by excluding Post to ledger option for AR Invoices?Summary: We tried to create Custom role for AR Specialist by keeping Account in draft mode and restrict post to ledger option. We have deleted Subledger accounting manag…
-
Mass update of Expiration Offset DaysIs there a way to mass update the Expiration Offset Days at customer account level? Updating the Customer Receivables Profile Class is not an option as it would impact a…
-
What is the use of "Delivery Date for Tax Point Date" in AR Transactions HeaderHi Team, Could anyone provide insights on the significance of the 'Delivery Date for Tax Point Date' in the AR Transaction Header? Additionally, can this value be interf…
-
Split revenue line with SLA and derive amount based on Item costSummary: We have scenario wherein the revenue line is to be split and the total revenue amount is to be broken down based on Item cost and Mgmt Fees For example: For a R…
-
Request for Solution & Documentation on Oracle Fusion ERP Integration with ZATCA for AR invoicesSummary: We are currently working on implementing e-Invoicing compliance for Saudi Arabia (KSA) and need to integrate Oracle Fusion ERP with the ZATCA portal in accordan… -
QR invoicing and connection to ZATCASummary: Dear All, Accounts receivable invoices must have a QR code. Content (required): We are using e-invoicing and must implement QR invoicing and connection to ZATCA… -
To Update data in AR Interface TableHi Oracle Community, We have a requirement to update the 'MemoLine' field in AR interface table in Oracle fusion. We have tried the below rest API but in the response pa…
-
Is it possible to upload Autoinvoice FBDI without "Line Transactions Flexfield Context"Summary: Content (please ensure you mask any confidential information): We are currently working on an integration requirement where customer invoices will be imported i…
-
Synchronize Account address between CX and Fusion ARSummary: In CX cloud, user can add now Address to a customer account and choose if its use (bill_to, ship_to). Is their any process that synchronizes the addresses betwe… -
Fusion Cloud -Unable to add a new line for an existing AR invoice using REST APISummary: We are trying to add a new line to the existing 'Incomplete' AR invoice for both Manual and DOO sources. We are getting error:400Bad Request. Content (please en…
-
Product Fiscal Classification change codeSummary: Hi! We have a note that in the Payables (AP) module the TAX tab is filled in and the Product Fiscal Classification column has a specific code |172301|. Where ar…
-
How to purge/delete specific errors on autoinvoice ADFDI / Manage AutoInvoice Lines?Summary: Hello, We have many integrations coming in during testing and need to purge specific errors out of certain file loads. Doc IDs I have read discuss Oracle not al…
-
update DFF more than Segment30 in FBDISummary: In the current FBDI customer template, we have observed that some DFF attribute options are visible , but only a limited number can be seen . For example in the…
-
When business unit has a specific value then the custom DFF field should be made required fieldSummary: Hi Experts, I am looking for a way to make a DFF field required only for one business unit and optional for other BUs. This DFF field is required by business fo…
-
Individual Transaction Collection Strategy Tasks for External SystemsAs per the new 25C release Individual Transaction Collection Strategy Tasks for External Systems What external source we are talking here? What this means? How external …