Generating an online bill fails for an account with multiple SA's sharing an SP (Doc ID 609112.1)

Last updated on APRIL 14, 2025

Applies to:

Symptoms

Generating an online bill for an account with multiple Service Agreements sharing an Service Point fails.  

Further investigation shows that the routine which obtains the generic characteristic value (CIPTCHVN.cbl) may fail when the same routine is invoked multiple times, without doing any proper initialization in between.  

The reason is that the generated dynamic SQL, unnecessarily, gets an extra character.  This extra character will initially be spaces, but may not be if it is invoked successively without a proper initialization.

For this particular case, the characteristic value of an SP is obtained, successively.  The first SQL leaves a non-blank character which is picked up in the next call.  Thus, an SQL error gets generated because the SQL is not recognized.

Changes

Cause

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