Billing and Revenue Management (MOSC)

MOSC Banner

PROC_CREATE_IDX_DUPCHK end with error due inexistent tablespace

Hi,

During semahore.reg processing, the procedure PROC_CREATE_IDX_DUPCHK is called to upload the new bufferLimit and StoreLimit dates but due the name of the index and tablespace being the same, the procedure fails with error 'Procedure: 'PROC_CREATE_IDX_DUPCHK' execute failed, 'Vendor Error: 959'.'

In order to debug the error we try to put the input values on table and conclude that the name of the index and tablespace are the same.

During the creation of the tables IFW_DUPLICATECHECK the tablespace name used was other a default one ('PIN00').

So the error have to do with this tablespace name that came from pipeline.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center