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
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t… -
Data Point - Site Total Receivables BalanceSummary: The total outstanding amount in USD for a site. On-account or unapplied cash is taken into consideration to reduce the outstanding amount. Is it possible to cal…
-
IEX Fusion Essbase Data Integration QuestionHi All, We are currently reviewing ways to extract the metrics created in the IEX Essbase (Advanced Collections) for use in OAC. We thought to use Data Integration in EP…
-
How Can we run Create Late Charge Batch process based on Completion of a Event (I.e. Period Close)?Hi Team, We wanted to create Late Charge invoice based on closing of AR Period. Please let us know if someone achieved this requirement to Run Create Late Charge Batch E…
-
Can we manually calculate interest on late charges and also waive it off if required?We have a use case wherein the business wants to know: If Interest can be charged on late charges manually? Can Interest on the late charges be waived off if it is charg…
-
CustomerImportTemplate.xlsm - Malware.W2000M/AVI.snh.lvymuSummary: CustomerImportTemplate.xlsm - Malware.W2000M/AVI.snh.lvymu Content (please ensure you mask any confidential information): Customer Import Template Blocked When …
-
Relationship between receivable transaction and custom object in pageHello Gurus, I've created a custom object where I use the field CUSTOMER_TRX_ID to extend information from AR invoices. How can I make it so that on the AR invoices scre…
-
Need to restrict Credit note distributions created from InvoiceSummary: The ask is that if we credit the invoice, the credit memo distributions are fetched from Invoice and we want to restrict that no user should be able to update s…
-
Receivable remittance batch import FBDISummary: Receivable remittance batch import FBDI Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…
-
How to correctly add the Bad bedt attribut to the report data model querySELECT hp.PARTY_NAME AS "Customer_name", rcta.TRX_DATE AS "TRANSACTION_Date", rcta.TRX_NUMBER AS "TRANSACTION_NB", fabuv.BU_NAME AS "Business_unit", rcta.INTERFACE_HEADE…
-
How to store URL in a dff in customer master page through sandbox customization in Fusion?Summary: We have created a DFF to store KYC document URL in customer master site level. Is there some customization through sandbox possible to store the value in dff as…
-
It is possible to add an additional receivables information on the Bank Reconciliation PageSummary: While trying to reconcile the AR receipts we would like to use additional fields on the Receivables to help us reconcile the transactions. Is there any possibil…
-
Match Original AR transaction with Void transaction automaticallySummary: In Fusion Cloud Cash Management, while auto reconcile, can the system recognize and match Original AR transaction with Void transaction automatically?
-
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning… -
Is there Any Webservice Available to update revenue contractsSummary: We have a requirement to update Plan Start Date on Promised line of a revenue contracts via API.
-
How to update the additional information of invoice lines for a processed invoice in Fusion?Summary: We have an external Appian application from where few transactions(Invoice & Credit Memo) are raised and interfaced to Oracle Fusion (AR Module) via Rest API us…
-
Collection Dashboard display non due transactionsSummary: Collection dashboard display non due transactions in Current bucket Content (please ensure you mask any confidential information): The transaction which not due…
-
How to send dunning letters having customized logicSummary: Hi We have one scenario as below, for same customer, if account 1 's invoice is past due 5days, then we will send dunning letter to them, but if it's account 2'… -
Can you enable dup checking when creating customers using the "Upload Customers From Spreadsheet"Summary: Duplicate checking is only enabled in the UI, but the client also wants to enable it when creating a customer through the spreadsheet This ensures that when cre…
-
how to bulk upload customer site level DFF fields other than FBDIis there any simpler way to upload DFF at customer site level.
-
Is there any way to change the Print Status flag?Summary: mmary: Is there any way to change the Print Status flag to YES/Printed without running the Print Receivables Transaction Process? Content (please ensure you mas…
-
Invoice movement from one customer to otherSummary: In case we have to move an invoice from one customer to another customer when the period is closed, can we use adjustment functionality and how? Content (please…
-
OTBI Report that includes oustanding BalanceI am trying to build an OTBI report for customer ATR transactions including outstanding balances (Remaining Balance). But I couldn't find out the customer Outstanding Ba…
-
How to write SQL query to fetch the Tax value present in TransactionSummary: Needed to write SQL query to get total tax amount for a particular transaction shown in UI(please check below screenshot ) Version (include the version you are …
-
Set Invoice Line Quantity to a Default ValueSummary: Is it possible to set a default value for "Quantity" when creating an Invoice in Receivables? Transactions are related to services and are non-quantifiable; thu…
-
Reversed Unidentified Receipts Not Being Picked Up By SweepSummary: We are trying to sweep the Reversal Event of multiple identified and unidentified receipts, but the sweep process is not picking up the unidentified receipts. H…
-
Dispute Credit Memos-How to combine Serial Participants and Parallel Participants based on AmountSummary: How to configure approvals based on dispute amount for both Serial Participant/Parallel Mode and Parallel Participant/Parallel Mode Content (please ensure you m…
-
Where can I find the create customer statements RTF to change to Logo?Summary: Good day, I am in the process of activating the create customer statements report because the Finance Team hasn't used it; However, I realize that the logo is n…
-
Oracle Fusion Role - Customer Data Steward - Specific PrivilegesSummary: We want to know what are the privileges used to achieve the below result with customer data steward role End date of a site from Customer Data Steward Role make…
-
Is it possible to apply a miscellaneous receipt to an open credit memo?Summary: The "Number" field is not visible when entering a miscellaneous receipt and selecting reference type = "Credit Memo". Content (please ensure you mask any confid…