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

Last updated on JANUARY 03, 2023

Applies to:

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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.