AsSequence Is Not Getting Updated When Sequence Is Used.

(Doc ID 2257525.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.2.0.0 and later
Information in this document applies to any platform.

Goal

1- In v10, there are sequences named EffectiveDateID and TranslationUpdatedGMT. What they are used for?

2- When invoking a sequence, the sequence integer is fetched using the store proc ASC_NEXTSEQUENCEINTEGER.  
In Oracle Database, the store procedure doesn’t update the table AsSequence but only the sequence DDL object (referencing by DataBaseSequenceName)
Please provided additional information on this process.

Solution

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