Category 338
Discussion List
-
You must enter a combination of the {COLUMN1} and {COLUMN2} columns that's unique in the {TABLE_NAMESummary: loading customers and getting the above error The combination of columns {COLUMN1} and {COLUMN2} must be unique in table {TABLE_NAME}. Not sure what to correct … -
Apply Receipts Using AutoMatchSummary: Parameter "Exact Match Only" : How to set the default value to "Yes"? Content (please ensure you mask any confidential information): Version (include the versio…Michelle Young 391 views 3 comments 0 points Most recent by Wilson Chelakadan Receivables & Collections
-
Need to Display Only Receipt/Transaction Number (Without Labels) in AR Statement ReportHi all, We have a requirement to customize the Generate Statement Report and display only the Receipt or Transaction number in Reference field (AR_STATEMENT_LINE_CLUSTER…
-
how to Apply Receivables Prepayment ManuallySummary: we created a manual prepayment invoice, and then we applied it on a receipt. Now we created Manual sales invoice, and when we came to apply the prepayment, we c…
-
How to restrict Zero amount when creating AR Invoice. Do we have any standard functionality?Zero amount should not be allowed in AR Invoice. Any standard functionality or what the steps to restrict ?
-
Bill Management - CWB and Test ScriptsSummary: Bill Management- CWB + Test Scripts Content (please ensure you mask any confidential information): We are currently looking for the seeded documentation related…Venkatesh Padamwar 9 views 3 comments 0 points Most recent by Venkatesh Padamwar Receivables & Collections
-
How to receive responses/acknowledgements via CMK for E-invoices sent to government or customer?Summary: Sending of E-invoices pertaining to AR Invoices is tested via CollaborationMessaging Framework (CMK) outbound messages (i.e. sending AR Invoice) using Email met…
-
Transaction Approval Workflow Configurationa) How? to configure approval workflows for manual and imported invoices by role-based. b) The following functionalities needs to be explored: i. Requesting additional i…
-
Print Receivable Job Error ExceptionGET_REQUEST_DATAORA-20303: property executionTerritory not foundHi, We are continuously getting the Print Receivable Job Error for "Exception in GET_REQUEST_DATA forORA-20303: property executionTerritory not found for request" and in… -
autoapply invoice to receiptThe user or customer prefers to create the receipt through a spreadsheet. Once the receipt is available in Oracle, it will be created and automatically applied to the co…Gangala Lavanya 9 views 2 comments 0 points Most recent by Gangala Lavanya Receivables & Collections
-
AR Invoice Document PrintSummary: We have a requirement to have common templates for Multiple Business Unit. For example, Business Units under North America and Canada to follow one template. AP…
-
Unable to create a text field in customer account DFF that allows 1000 characters.We are trying to create a DFF at customer Account level and our requirement is to create a text field that allows 1000 characters whereas data type chracter system is no…
-
Receivables payment terms apiSummary: Need to bring Receivables payment terms using rest api Content (please ensure you mask any confidential information): I am using /fscmRestApi/resources/11.13.18…
-
API to fetch payment term details for Account receivablesSummary: I want to fetch payment term detail from Account receivables. where is need the DUE_DAYS, DUE_DAYS_OF_MONTH and DUE_MONTH_FORWARD. I am currently using BIP repo…
-
Create an AR invoice directly from a Sell contractSummary: We have implemented Enterprise contracts (Buy Intent) in Oracle fusion. My question is related to contract of Sell Intent. Our business scenario: We are a media…
-
Org Level Contact - Person RelationshipSummary: Trying to Create a Org Contact in fusion (A Person with contact to be created and linked to a Organization) Content (please ensure you mask any confidential inf… -
How to get the total work hours in rtfSummary: I have a client who does not enter the hours in OTL. but under payslip they want no of hours(Bi weekly payroll - 80 hrs for 2 week). now I need to customise the…Chetan Madhusudan 3 views 0 comments 0 points Started by Chetan Madhusudan Receivables & Collections
-
Configuration needed for using Dunning Plans. Can Dunning Plans use Scoring too?Summary: Could you please advise the steps needed for using Dunning Plans as collection method. Is this based on days overdue only or we could use Scoring too? Content (…
-
How to do the Import AutoInvoice process in AR with multiple lines in a single invoice?Summary: After importing the Autoinvoice, an error appears as shown below: "Each line must have a unique combination of INTERFACE_LINE_ATTRIBUTE1-15 and INTERFACE_LINE_C…
-
Is it possible to derive Separate Accounting line in AR invoice based on the discount amount in SO?Summary: Is it possible to derive Separate Accounting line in AR invoice based on the discount amount in SO? Content (please ensure you mask any confidential information…Saravanan Veeraragavan 14 views 3 comments 0 points Most recent by Saravanan Veeraragavan Receivables & Collections -
How to remove other primary address in customer data management?Summary: We have a customer record with 3 addresses marked as primary. We are unable to set the actual primary address as the primary address due to this. Is there a way…mary.claire.s.recio 3 views 0 comments 0 points Started by mary.claire.s.recio Receivables & Collections
-
Best Practices for Managing Customer Refunds and Credit Memos in ReceivablesHello team, While testing Receivables, I encountered several cases where customer overpayments or refunds needed to be processed. What’s the best practice to handle refu…
-
Why are dates derived from the Rule Start Date even when the Derive Date checkbox is unchecked?Derive Date Checkbox not working as expected in Imported Transaction. Issue: We are facing an issue with the Derive Date checkbox functionality while importing transacti…Mohna Thorani 10 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Collections Preferences - what is the use of 'Dunning Delivery Using Email'Summary: What is the use of the 'Dunning Delivery Using Email - Dunning Letter Template/Email Body' in the Collections Preferences? Is it used by Strategies or Dunning P…
-
Deactivate Receipt Reserval Category Types that are not usedHi, We would like to deactivate receipt reversal types that are not used. Is it possible? Regards
-
Receipt method is not defaulting from customer bill to siteReceipt method is not defaulting to AR manual transaction from customer bill to site. we setup payment method at customer bill to site & primary check box is enabled.Siva Manjunath 12 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Query to fetch end date in custom audit reportWe have created a custom audit report that shows new and old values based on audit tables on external bank accounts. The problem is that if we end date the bank account …
-
Is there now an API to set Debit Memos as Incomplete after AutoInvoice Import?Summary: I asked this same question in 2024 and, at that time, there was no supported API to set Debit Memos as “Incomplete” after importing them through the AutoInvoice…Wilson V Lauer 8 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to create a dispute with a credit memo but without auto applying to the original invoiceSummary: We need to create a dispute for an invoice with a credit memo (as usual), but not auto applying the credit memo to the original invoice. Content (please ensure … -
How to configure Dispute based CM approval to route the Approvals to a Custom Approval GroupSummary: Would like to know the steps to configure BPM, so that Disputes Approval can be routed to an Approval Group. Content (please ensure you mask any confidential in…Dhiren_AVALARA 4 views 1 comment 0 points Most recent by Matt Lennon - Terillium Receivables & Collections