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
-
Add new column in collection dash board after unpaid reasonSummary: Add new column in collection dash board after unpaid reason Content (please ensure you mask any confidential information): Add new column in collection dash boa… -
AutoAccounting Rules in AR – possible to override with Customer Class or Mapping Set?Hello, My client asked me to change the account distribution in AR transactions. Currently, AutoAccounting Rules for this Business Unit use the "Transaction Type" as the…
-
Is there a way to configure different currencies for different Business units in collection metric ?Summary: Is there a way to configure different currencies for different BUs in Collection Metrics? Content (please ensure you mask any confidential information): In the … -
How to Set AR Invoice Transaction Date via PPM and Import Autoinvoice?Summary: Hi Oracle Community, I’m creating a project invoice in Oracle Project Portfolio Management (PPM) and using the Import Autoinvoice job to generate the AR invoice…
-
Email being sent to customer when address is incorrectSummary: We're experiencing some issues with email addresses when it comes to customers. When "Print Receivables Transactions" is ran, for some reason there are some ema…
-
unable to find inventory item templatesSummary: We were using : select * from egp_system_items_VL WHERE NVL( TEMPLATE_ITEM_FLAG,'N') = 'Y' to get the items templates. But now we are not able to find any templ…
-
AutoInvoice upload error duplicate invoice numberDear all While uploading the FBDI file i find this error stating that there's a duplicate invoice number while if you search in manage transactions it's not available al… -
Certain field in Header part not able to edit once Complete and ReviewSummary: Certain field in Header part not able to edit once Complete and Review Content (please ensure you mask any confidential information): Hi, Once click the "Comple…
-
API to Withdraw Adjustment Pending in ApprovalSummary: We have a requirement to withdraw adjustment (Pending in Approval) via API. So, we are using createReverseAdjustment method of SOAP API (/fscmService/Adjustment…
-
Bulk update of customer account profiles to disable "Send Statement" optionSummary: We have a requirement to update 800k existing customer account profiles to disable "Send Statement" option. Content (please ensure you mask any confidential inf…
-
how can i get last date when customer was printed in final mode for a customer in oracle fusionHow can I get the last date when statement was printed in final mode for a customer in oracle fusion. Is that value stored in any table or is there any API that can be u…
-
Customer Statement ReprintHello, Hope everyone doing good. While running 'Create Customer Statement' program and when I select Generate Bill as Re-print i am not getting any value under Cycle fie…
-
How to use FBDI Upload Customers for adding dunning purposeSummary: We want to use the Oracle Dunning Process however there does not seem to be an easy way to update customer data so that 1) We can update a bill to site (the pri…
-
I need to get the data from the DFF at the organization level, but I couldn’t find any API.Summary: Content (please ensure you mask any confidential information):
-
Tax invoice number should be linked to the supply/transaction typeSummary: Content (please ensure you mask any confidential information): We have the following requirement-The tax invoice number on AR invoice should start with the init…
-
Getting Special Characters in Rest API response for only one fieldHi, We are getting special characters in REST API response for one of the filed which is a DFF and the values are pipe delimited. Below is the screen shot. Do we have a …
-
What is the best practice to store Peppol ID to generate AR XML InvoiceSummary: Hi team, We are currently implementing an XML invoice solution for the Belgium Business Unit in Oracle Fusion. As part of the requirements, we need to include t…
-
Print Receivables process for 'Paper' batch when there are no eligible transactions ends in ErrorSummary: As far as I know there isn't a way to change this but we are wondering if there is a way to update how Print Receivables works when the 'Paper' batch for Print …
-
Is deposit date can be disabled once receipts are remitted?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…
-
How to "Override Account" in bulk for AR invoicesSummary: We have a requirement where entity segment on receivable account class of around 1500 AR invoices need to be overridden after the invoice has been accounted and…
-
unable to load customer account dff with number data typeSummary: Hi Team, I have a dff value with Number data type defined in customer master account level. I want to populate the value for this DFF using FBDI. I am not findi…
-
Is there any REST API to get HZ_IMP_BATCH_SUMMARY details?Summary: Hi, Currently we are trying to run recon reports based on 'Import Bulk Customer Data' job completion. Hence, we are using HZ_IMP_BATCH_SUMMARY table to get the …
-
I have more than one attribute required when creating receipts via spreadsheet, how do I add them?Summary: We have more than 1 DFF (attributes) required when creating manual receipts. But when creating receipts via spreadsheet, there is only one column for the attrib… -
Remove Null value in DFF fieldSummary: We have a descriptive flexfield in Accounts Receivables. The display type is "List of Values" and it is based on Resource object using an SQL query. How can I r…
-
Dunning Erroring Suddenly for a BUWe've been running send dunning for several years, suddenly this month a whole BU has error'd an we're unsure why. We understand that a customer may not be configured co…
-
Rest API or Web Service to update AR Invoices Header values and Line ValuesWe got one requirement to update bill to customer and ship to customer at Account Receivables Invoice header level. As there are no values present in the REST API docume…
-
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…
-
Is it possible to print AR invoice by ledgercan we create AR invoice print template(Print Receivables Transactions) by ledger? We have implemented by Business unit and its working successfully. Could you please le…
-
Query for Customer Statement for Open transactionsHi, Can someone please help me with the query to get only open transactions for Customer statements. In the seeded data "CustomerStatements" I see ar_statement_headers a…
-
Is it possible to delete responsibility from customer contact on account level using FBDI?Summary: We have around 500 customer accounts that we need to delete the responsibility "Statements" since we don't require these to receive statements, is it possible t…