E-PC: GetNextNumberWithGapsCommit does not work with non-standard SQL table names (Doc ID 1306858.1)

Symptoms

GetNextNumberWithGapsCommit does not work with non-standard SQL table names or PeopleTools tables. It assumes any record it deals with has PS_ added to the front of the record name for its table name.

For example, say there is a Record named GSC_COUNT with a non-standard SQL table name GSC_COUNT. When running GetNextNumberWithGapsCommit on this record, e.g.

&NEXT_NBR = GetNextNumberWithGapsCommit(GSC_COUNT.ACT_SEQ_NBR, 500, 1);

You get the following error:

Notice the SQL statement "UPDATE PS_GSC_COUNT ..."

ERROR
---------------
Oracle: ORA-00942: table or view does not exist
MS SQL: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name

STEPS
---------------
The issue can be reproduced with the following steps:
1. Use GetNextNumberWithGapsCommit with any record that has a non-standard tablename

IMPACT
---------------
Unable to use GetNextNumberWithGapsCommit with any record that has a non-standard tablename, including PeopleTools tables.

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.