My Oracle Support Banner

Unable to Select Data from AR_CUSTOMER_ACCOUNTS View After Database Upgrade to 12C and EBS Upgrade to 12.2.8 (Doc ID 2672407.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Receivables - Version 12.2.8 and later
Information in this document applies to any platform.


On : 12.2.8 version, Reports for Applications Technology
Unable to Select Data from/ Run Reports Against the AR_CUSTOMER_ACCOUNTS View after 12C and 12.2.8 Upgrade from 12.2.6 to 12.2.8 and Database Upgrade from to

[Error] Execution (9: 35): ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "APPS.FND_DATE", line 149

The issue can be reproduced at will with the following steps:
1. Upgrade from version 12.2.6 to 12.2.8 and Database version from to

2.Attempt to retrieve data from view/ table

The issue has the following business impact:
Due to this issue, users cannot run reports based on this view/Table


To view full details, sign in with your My Oracle Support account.

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

In this Document
 1. Bug Summary
 2. Fixed Files
 R12.AR.B: No files found.
 3. Recommended Patches
 4. Solution Steps

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