AsSequence Is Not Getting Updated When Sequence Is Used.
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.
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.
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