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

Last updated on JULY 26, 2024

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