Error during Upload Credit Memo in Manage AutoInvoice Lines Spreadsheet You must enter a valid credit reason (AR-856405) (Doc ID 3024766.1)

Last updated on MAY 28, 2024

Applies to:

Symptoms

 Error is seen while updating ReasonCode or ReasonCodeMeaning field in Manage AutoInvoice Lines Spreadsheet to import the Credit Memo

ERROR
----------

You must enter a valid credit reason (AR-856405) 

STEPS TO REPRODUCE

-------------------------

1) Navigation - Setup and Maintenance > Manage Receivables Lookups
2) Query for Lookup Type = CREDIT_MEMO_REASON 
3) Define a Lookup Code and Meaning and make sure that Enabled is checked and End date is not entered
4) Lets take an example of using Lookup Code with Meaning= Wrong product and Lookup Code=WRONG PRODUCT
*** The value is only for demo purpose.
5) Open Manage AutoInvoice Lines Spreadsheet (ManageAutoInvoiceLines.xlsx) and enter ReaonCodeMeaning= Wrong product 
6) Click on Upload . Status Viewer shows Error = You must enter a valid credit reason (AR-856405) 
Status column shows value = Update failed

Cause

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