AutoInvoice Error: Parameter Customer (Party) Name > 50 Characters Produces Fetch Error (Doc ID 839680.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Report:ARXAGCW.RDF - Aging - 7 Buckets - By Amount Report
Report:ARXAGE.RDF - Aging - 4 Buckets Report
Report:ARXAGMW.RDF - Merged Aged Trial Balance Report (180 chars)
Report:ARXAPRCF.RDF - Automatic Receipts Awaiting Confirmation
Report:ARXASR.RDF - Account Status Report
Report:ARXBDP.RDF - Bad Debt Provision Report
Report:ARXCBH.RDF - Billing History
Report:ARXCCS.RDF - Customer Credit Snapshot
Report:ARXCHR.RDF - Credit Hold Report
Report:ARXCPH.RDF - Receipt Analysis - Days Late
Report:ARXCTA.RDF - Adjustment Approval Report
Report:ARXNROPN.RDF - Notes Receivable Report
Report:ARZACS.RDF - Automatic Clearing for Receipts
Report:RAXCBR.RDF - Commitment Balance Report
Report:RAXCUS.RDF - Customer Listing - Summary
Report:RAXIIR.RDF - Incomplete Invoices Report
Executable:RAXMTR - Autoinvoice Master Program
Executable:RAXTRX - Autoinvoice Import Program


Symptoms

Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice: Master Program (RAXMTR) Errors And 'No Data Found' Issues > Note 839680.1

When running AutoInvoice or other Oracle Receivables concurrent programs / reports which accept a Customer Name parameter, if customer name entered is more than 50 characters, one of the following errors is raised:

APP-FND-01030: Value <xxx> is longer than its maximum length of 50 characters

APP-FND-01564: ORACLE error 24345 in fdlget

The same issue is raised in many Receivables concurrent processes/reports, such as the following:

Note: The list below is to document reports/concurrent processes that may encounter this issue. Some of the items listed below do not have patches available yet.


Concurrent Programs:

  • Automatic Clearing for Receipts
  • Dunning Letter Generate (Called by Dunning Letter Print)
  • List deductions transferred from TA
  • TA to DMS : Deductions transfer process
  • Statement Generation Program
  • Automatic Clearing for Receipts
  • Generate Late Charge ( Child Program)
  • Refresh specific customer data in AR transaction summary tables.
  • Autoinvoice Master Program

Reports:

  • Dunning Letter Reprint - Historical Receivables Only
  • Publish Actual Receipt
  • Publish Transaction Check
  • Other Receipt Applications Report
  • Publish Receipt Forecast
  • Publish Sales Register
  • Unapplied and Unresolved Receipts Register
  • Aged Trial Balance - 7 Buckets - By Deduction Assigned-To
  • Aged Trial Balance - 7 Buckets - By LOB
  • Deduction Transaction Detail Report
  • List of Deductions transferred from DMS
  • High Volume Receipt Entry Report
  • List deductions transferred from TA
  • Preview deductions to be transferred from TA
  • Aging - 4 Buckets Report
  • Aging - 7 Buckets - By Amount Report
  • Aging - 7 Buckets - By Account Report
  • Aging - 7 Buckets - By Collector Report
  • Aging - 7 Buckets - By Salesperson/Agent Report
  • Aging - 7 Buckets Report
  • Transactions Awaiting Consolidation
  • Automatic Receipts Awaiting Confirmation
  • Account Status Report
  • Bad Debt Provision Report
  • Billing and Receipt History
  • Applied Receipts Exceptions Register
  • Billing History
  • Customer Credit Snapshot
  • Credit Hold Report
  • Customer Credit Usage Snapshot
  • Receipt Analysis - Days Late
  • Adjustment Approval Report
  • Customer Relationships Listing
  • Disputed Invoice Report
  • Discount Projection Report
  • Projected Gains and Losses Report
  • Journal with GL Details Report
  • Notes Receivable Report
  • Reversed Notes Receivable Report
  • Other Receipt Applications Report - DIRECT RXI
  • Past Due Invoice Report
  • Receipt Journal Report
  • Tax Exempt Customer Report
  • Automatic Clearing for Receipts
  • Commitment Balance Report
  • Commitment Balance Report (Summary/Detail)
  • Customer Listing - Summary
  • Sales Journal By Customer
  • Incomplete Invoices Report
  • RX-only: Actual Receipt
  • RX-only: Transaction Check
  • RX-only: Transaction Register
  • Rx-Only: Other Receipt Applications Report
  • RX-only: Receipt Forecast
  • RX-only: Sales Register
  • RX-only: Unapplied and Unresolved Receipts Register
  • Cross Currency Exchange Gain/Loss Report

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms