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 JULY 10, 2020

Applies to:

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

Symptoms

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 11.2.0.4 to 12.1.0.2.)
 

ERROR
-----------------------
[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

STEPS
-----------------------
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 11.2.0.4 to 12.1.0.2

2.Attempt to retrieve data from view/ table

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

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 R12.AR.B: No files found.
 3. Recommended Patches
 4. Solution Steps
References


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