PJB: ORA-06502: Numeric or Value Error: Running Generate Revenue With Contract Range (Doc ID 2021614.1)

Last updated on JUNE 29, 2015

Applies to:

Oracle Fusion Project Billing Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Manage Project Contracts-Manage Project Contract Revenue

Generate Revenue process ends up in an error when running with BU and date parameters. Process completes successfully when running by single contract. Process fails even by running with contract range.

Reported Error
pjb.plsql.pjb_revenue_generation_pkg.get_eligible_reg_contracts: The sql failure : ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: Bulk Bind: Truncated Bind
pjb.plsql.pjb_revenue_generation_pkg.Revenue_Main_process : Exception : User-Defined Exception
pjb.plsql.pjb_revenue_generation_pkg.Revenue_Main_process : Unexpected Error
pjb.plsql.pjb_revenue_generation_pkg.Revenue_Main_process : User-Defined Exception »

Replication Steps
1. Run Generate Revenue with BU, Billing Type and the Dates
    OR
    Run Generate Revenue with BU, Billing Type,Dates and Contract Range.

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