An Auto-Sequence Project Number Is Not Populating Into New Projects Created Via Project Creation Business Process (Doc ID 2732884.1)

Last updated on OCTOBER 21, 2022

Applies to:

Symptoms

Project number sequences are not populating into the Project Shell Detail form in the production environment, however this same functionality seems to be working as expected in the stage environment. When using a Project Creation BP to create a new Project/Shell, the expectation is that a specific number sequence will be generated and populated into the "Project Number" field in the Project Shell Details. This has been configured in the setup so that the number sequence can be reset back to 0000. Thus, at the beginning of a fiscal year the number will be <Fiscal Year><number sequence beginning with 0000> or 20190000 for example. Recently when it was reset to 0000 it worked as expected in Stage, but not in Production, the project number continued to increase in production with the prior fiscal year in the first four digits.

EXPECTED BEHAVIOR
-----------------------
After resetting the number sequence to 0000, new Project/Shells created via Project Initiations BP should be getting Project Number of <fiscal year><0000>.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Unifier Administrator resets the numbering sequence for Project/Shells numbering to 0000 in Stage and Production.
2. Log into Production environment.
3. Navigate to Company Workspace > User Mode > Company Level Business Process log > ProjectCreateBP > +Create to create a new record.
4. Fill in the remainder of the required fields and click ‘Submit’.
5. A new Project/Shell is created with a Project Number, but it is not in the expected sequence... the new project # is just the next number in the sequence from the prior fiscal year.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.