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
-
Receivables invoice open balance as of historical date (excluding tax lines)Summary: looking for PLSQL API to calculate invoice open line amount (excluding tax lines) as of any historical date. For example: If an AR invoice had original open bal… -
Is it possible to have multiple Unearned account in a single transactionSummary: As per my knowledge, Unearned Account is derived from Transactions Type and Customer Account and Sites as per Auto Accounting. Businesses want to capture each r…
-
An incoming Direct Debit transaction can be requested for refund by debtor bank, post settlement.Refund Request initiated by Debtor Bank:-Refund is initiated on or after the value date of the incoming collection transaction. Thus the transaction will liquidate by th…
-
AR Import AutoInvoice Credit Memo Tax LineSummary AR Import AutoInvoice Tax LineContent I'm trying to create a credit memo for a specific transaction and to credit the tax line only I currently have 2 lines in m…
-
Miscellaneous Receipt - Select Credit Memo as reference type and Credit Memo number as reference numSummary: While creating Miscellaneous Receipt manually, there is an option available in UI to select Reference type. The list of value under Reference type includes Cred…
-
Custom Transaction Source from Oracle Order ManagementSummary Custom Transaction Source from Oracle Order ManagementContent I created a Custom Transaction Type and got it assigned to the AR invoice created from Order Manage…
-
Context based receivable transaction screen flexfieldTeam - Need help. Is it possible to create a context based DFF in Create Transaction Screen which shows only for Debit Memo class of transactions and that too for a spec… -
Unable to find Outbound Format in Funds Capture Process ProfileHi, We are configuring CyberSource Integration in PROD and have completed setups till Payment System Accounts. However, we are stuck at assigning the Request and Respons…
-
How to Enable query by example for manage receiptsOn the AP Invoice side, we have the option to query by example . For AR Receipts there is no option to enable query by example Please view below screenshots and suggest …
-
Is there a way to not expose uninvoiced orders for Credit Balance Calculation?Summary: The available credit for the customer or customer account is calculated as: Total Defined Credit Limit - Open Credit Authorizations - Open Receivables Balance =…
-
Customer bank account is not populated automatically when receipts loaded through adfdi fileCustomer bank account is not populated automatically when receipts loaded through adfdi file
-
How to Validate Invoice Legal Entity with Revenue line Legal Entity (PBSV)Hi Everyone, While Creating an Invoice in AR module, we get the default Legal entity from the GL setups (Lets say "LE A") and it will be populated at the Misc tab of Inv…
-
Dunning letter is not getting generated,Summary: Hi I have enable staged dunning and whenever i am trying to run the dunning letter it';s going into error and in the error it;s also not generating any proper e…
-
Setup to generate tax invoice number in shipment lines?Summary:Setup to generate tax invoice number in shipment lines? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
dff mandatory based on condition.Can I make a DFF segment mandatory based on value selected in Transaction Type in Ar. For example , if transaction type is "Debit Memo" , then DFF should be mandatory ot…
-
I am not able to split up the exchange difference line in receipts.Hello My client wants to split up the exchange difference line (positive and negative) according the value of business division segment that was used in the invoice reve…
-
Create Dispute need to expire based on the Rule and later need approve/rejectSummary: Create Dispute on Receivable transaction need to expire based on the Rule and later need approve/reject In "FinArTrxnsCreditMemosApproval" on "Non-collection Wo…Niyamadullah.Abdulkhader 11 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle
-
Request for White Paper on AR Approval WorkflowHello, I am writing to request a copy of the white paper on on AR Approval Workflow I greatly appreciate any assistance you can provide in sharing the white paper with m…User_2025-03-07-00-37-17-870 61 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle
-
Sales Order creation to go on credit hold if the customer has Past Due Invoice AmountSummary: We have a requirement to create Sales Order for a customer and it should go on credit hold when the customer has Past Due Invoice Amount irrespective of the cre…Mahesh Kumar Lakshmana 121 views 2 comments 2 points Most recent by Rasheed - Fusion Support Engineer-Oracle -
Localization Document Sequence Numbering for EMEA CountriesSummary: EMEA Country Entities require gapless localization document sequence numbering to meet their local Requirement. Content (required): One of our client is using R…
-
Send Dunning Letters - incorrect email addressSummary: What happens to dunning letters that are automatically fired for customers who have a bad or incorrect email address entered within Contacts? Content (please en…
-
Receivables Debit Memo WebServices with DFFSummary: We understood there is no API for Debit Memos Transactions, hence we are using SOAP Webservice Debit memo. But could not find any field to pass DFF (Descriptive…
-
AR_PLB_CUST_OK - Customer identified by customer account number. Imported Receipts stuckSummary: Process Receipts Through Lockbox and Post Receipt Batch are completing successfully but data is not getting imported into the system. Lockbox Execution Report i…
-
In AR invoice transaction date is 31st march, but GL transfer date is 1st April in oracle fusionIn AR invoice transaction date is 31st march, but GL transfer date is 1st April in oracle fusion, what could be the issue? Business is expecting GL Transfer Date same as…Hemanth Buccapatnam Tirumala 31 views 11 comments 0 points Most recent by Hemanth Buccapatnam Tirumala
-
How to fetch the customer bank account details in receipt refund pageCould you please help us to get customer bank account details in receipt refund page. we are looking for a rest api or soap webservice which will bring the customer bank… -
SQL to find Automatic Collections Transaction Strategy Tasks with "To Be Created" statusSummary: SQL to find Automatic Collections Transaction Strategy Tasks with "To Be Completed" status Content (required): Hi, Looking here, at Strategy Tasks for a sample …
-
How to avoid creation of separate Invoice for Freight while using Grouping rules on shipment basis?Summary: System is creating separate invoice for Freight, if Sales Order contains Freight. Content (required): We are following grouping rule based on shipment basis (mu…
-
Using advanced collections to automatically assign collectors based on strategy group assignedSummary: Using advanced collections functionality, is there a capability to the automatically assign collectors based on the collection scoring and strategy assigned, or… -
I can't create a refundHello, I am navigating into "manage credit memo applications" in AR, but unfortunately when I search for the transaction number and click on issue fund, the following er… -
Workflow notifications upon Period OpenSummary: Hi Team, We moved from R12 to Fusion. In R12, when new period is opened or prior period is closed, we had triggers to email group of people indicating if the pe…