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
-
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…
-
Want to update the Customer information in account for the category manager fillSummary: The client has requested an update to the Category Manager field for accounts where customers were created manually. Is it possible to update the Category Manag…
-
Customer Account TypeWhen creating a customer, the account type lov under account information has just internal and external. Can this lov be updated? if yes, how can i do the update?
-
Need to hit the different BSV for the receipt write offSummary: Client is expecting to have the entries created as below On creating the receipt: Below is the accounting entry being created based on the bank account code com…
-
CybserSource Credit Card Integration is allowing for mismatched CVV numbersSummary: We are intentionally submitting a mismatched CVV number between the card number and what is being input when creating the Credit Card in Fusion. The transaction…
-
Is it possible to default a AR transaction Header DFF context based on Transaction TypeSummary: Is it possible to default a AR transaction Header DFF context based on Transaction Type? Content (please ensure you mask any confidential information): We are l…