My Oracle Support Banner

Revenue Contingency Analyzer Program Completing In Error ORA-06502 ORA-06512 ORA-20001: APP-AR-11526 (Doc ID 2757585.1)

Last updated on MARCH 15, 2021

Applies to:

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

Symptoms

Revenue Contingency Analyzer concurrent program (Shortname: ARREVSWP) is completing in error.

The log file is showing:


ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.AR_REVENUE_MANAGEMENT_PVT", line 6314
ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ORA-0

The FND debug collected is showing

ar.plsql.arp_auto_accounting.assemble_code_combination 1  ccid= -1
ar.plsql.arp_auto_accounting.assemble_code_combination 1  concat_segs= 001.XXX.XXXXX.XXXXX.XXXX.XXXXXX
ar.plsql.arp_auto_accounting.assemble_code_combination 1  interim_tax_ccid=
ar.plsql.arp_auto_accounting.assemble_code_combination 1  interim_tax_concat_segs=
ar.plsql.arp_auto_accounting.flex_manager.end 2 arp_auto_accounting.flex_manager()- 25-FEB-21 05:14:18
ar.plsql.arp_auto_accounting.flex_manager 1 process_line:  Failure count : 1
ar.plsql.arp_auto_accounting.flex_manager 1  p_failure_count=1
ar.plsql.arp_auto_accounting.do_autoaccounting_internal.end 2 arp_auto_accounting.do_autoaccounting_internal()- 25-FEB-21 05:14:18
ar.plsql.arp_auto_accounting.do_autoaccounting_internal 1  p_failure_count=1
ar.plsql.arp_auto_accounting.do_autoaccounting_internal 1  raising no_ccid
ar.plsql.arp_auto_accounting.do_autoaccounting_internal 1 earn_or_unearn: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.earn_or_unearn()+
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 4 Earn_Revenue: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.Earn_Revenue()+
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 1 RME encountered an ERROR with RAM!
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 1  p_customer_trx_id      : 30936729
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 1  p_customer_trx_line_id : 192154500
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 1 Error Reported By RAM API:
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4 APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ar.plsql.AR_Revenue_Adjustment_PVT.Earn_Revenue 1 OTHERS: adjust_revenue
ar.plsql.&GENERIC_TEXT 1 ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ar.plsql.&GENERIC_TEXT 4 EXCEPTION: OTHERS: periodic_sweeper
ar.plsql.&GENERIC_TEXT 1 "ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at ""APPS.AR_REVENUE_MANAGEMENT_PVT"", line 6314
ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)"
fnd.src.process.fdpwrt.fdpwrt.log_write 3 "ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at ""APPS.AR_REVENUE_MANAGEMENT_PVT"", line 6314
ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ORA-0"


 

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation
: Control > Requests > Run

  1. Submit Revenue Contingency Analyzer concurrent program

Changes

 

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
Changes
Cause
Solution
References


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