AnsweredAssumed Answered

Determining the next value in sequence for sub-object

Question asked by Christine.Takeuchi on Apr 3, 2013
Latest reply on Nov 30, 2015 by navzjoshi00
Is there a way to find out the next value in the autonum sequence for a sub-object? I'd like to call that from my custom procedure in Oracle.

I tried using this command CMN_ID_SP('APRP', V_ID), but it is returning the value for the PRNOTE autonum sequence instead of the sequence for my sub-object.

Thanks in advance for any helpful tips!