Oracle WebCenter Content (MOSC)

MOSC Banner

How can I create and maintain an Automatic Number Control by content Type that needs to be restarted

edited Jun 1, 2017 5:03AM in Oracle WebCenter Content (MOSC) 3 commentsAnswered

Hi,

The customer wants an automatic numbering control by content type that needs to be restarted when the year changes.

I figured I'd create a table to control numbers with fields:

- Control_year = 2017;

- Control_TypeA = 00000;

- Control_TypeB = 00000;

- Control_TypeC = 00000;

If this New Check-in sequence occurs in 2017 (year):

1. first document of type A - AutoNumberFieldValue = 0001/2017 (Control_TypeA + 1, need to update Control_TypeA to 0001);

2. First document of type B - AutoNumberFieldValue = 0001/2017 (Control_TypeB + 1, need to update Control_TypeB to 0001);

3. second document type B - AutoNumberFieldValue = 0002/2017 (Control_TypeB + 1, need to update Control_TypeB to 0002);

4. First document of type C - AutoNumberFieldValue = 0001/2017 (Control_TypeC + 1, need to update the Control_TypeC to 0001);

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