My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


On : 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
    Run Generate Revenue with BU, Billing Type,Dates and Contract Range.


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

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