Skip to main content

When migrating project, I want to make use of the Project ID Generation Rules. I leave the project ID in the migrate source job blank, category 1 is filled, Generation rules have been set up for given category 1. All other values are catch all.

Still nothing happens when running the migration. So I was wondering which API to call to set the api in the defaul value of the project id, so it would generate the id when migration job runs.

Anyone an idea which api to call? I would prefer to know the parameters as well, although less important for now.

BTW: rule works perfect when entering a project via the project definition form

Hi @eqbstal 

I used the method PROJECT_ID_NUMBER_API.Generate_New_Project_id to generate a new project_id based on the rules and also stored the old project id from the legacy system and the new generated project id in a conversion list.

I did this for IFS Applications 10 and should also work for IFS Cloud.

 

/Jens

@eqbstal the procedure that generates the project id is PROJECT_ID_NUMBER_API.Generate_New_Project_Id();

See below the procedure signature with the required parameters:

PROCEDURE Generate_New_Project_Id (
   project_id_    IN OUT NOCOPY VARCHAR2,
   company_       IN VARCHAR2,
   program_id_    IN VARCHAR2,
   category1_id_  IN VARCHAR2,
   category2_id_  IN  VARCHAR2);

 

@Jens Liked your answer best as it also gives feedback on how to use it in another way and maybe a list for the customer to have an idea where went what.

@Marcel.Ausan In the end I will use your info.

Thank you both.

In the migration job I needed the project id to pop up in the corresponding field, so I used the default value with the following:

PROJECT_ID_NUMBER_API.Get_Next_Temp_Project_Id (

company_ IN VARCHAR2,

program_id_ IN VARCHAR2,

category1_id_ IN VARCHAR2,

category2_id_ IN VARCHAR2)

This is a function, so it will return a value, where as the PROJECT_ID_NUMBER_API.Generate_New_Project_Id() will only generate, but not return the value.

Reply


Terms & ConditionsCookie settings