Deferred Revenue Transfer to Revenue Account Completes with Error - ORA-06512: APPS.AR_REVENUE_ADJUSTMENT_PVT (Doc ID 2009566.1)

Last updated on DECEMBER 07, 2015

Applies to:

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

Symptoms

You are running the Deferred Revenue Transfer to Revenue Account and receive the following error:

ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model AR_Revenue_Adjustment_PVT.dists_by_model() ra.ccid291723
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model AR_Revenue_Adjustment_PVT.dists_by_model() final ccid291723
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model Setting RSD back from 01-MAR-15 to 03-NOV-14
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model c3_rec.gl_date : 03-NOV-14
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model c4_rec.gl_date is same as c3_rec.gl_date.Ignore this row for update
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model c4_rec.gl_date : 30-DEC-14
ar.plsql.AR_Revenue_Adjustment_PVT.dists_by_model earn_or_unearn: Unexpected error ORA-01403: no data found at AR_Revenue_Adjustment_PVT.earn_or_unearn()+
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue Earn_Revenue: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.Earn_Revenue()+

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.AR_REVENUE_ADJUSTMENT_PVT", line 916
ORA-01403: no data found

The business users are not able to transfer revenue from deferred account to revenue.

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