Question

Migration job for CONTRACT_ITEM fails with an error

  • 21 February 2023
  • 7 replies
  • 76 views

Userlevel 5
Badge +8

When the Migration job is executed, error “ORA-20110: ContractItem.CONSALESVALUEREQD: The Sales Value must have a value since Calculation Type is Sales Value and Calculation Method is Fixed.” occurs.

The purpose of this migration job is to allow us to insert data from the user defined table to contract_item_tab.

 

A similar error has been reported here.

However, the procedure name used in the current example is MIGRATE_SOURCE_DATA and not procedure INSERT_BY METHOD_NEW 

 

IFS Aurena framework version: 22.1.10.20221205084017.0

IFS Aurena client version: 22.1.10.20221205084017.0

 

Kindly assist in identifying the root cause of this error.


7 replies

Userlevel 7

Are you really setting a value in the “Sales Value” column? 

Userlevel 5
Badge +8

Hi @anmise,

 

Yes the value has been set.

 

Best regards,

Devni

Userlevel 7

Hi @anmise,

 

Yes the value has been set.

 

Best regards,

Devni

I think you might need to set REVENUE_VALUE_ADJ as well and maybe even Sales Value Contract Currency and Sales Value Company Currency. Are you setting those too?

Userlevel 5
Badge +8

Hi @anmise,

 

Yes those values have been set as well.

Please check the attached <Attribute String>.

 

Best regards,

Devni

Userlevel 7

Hi @anmise,

 

Yes those values have been set as well.

Please check the attached <Attribute String>.

 

Best regards,

Devni

Do you have values in the following fields? 
Company
Sales Part Site
Item Sales Currency
Item Cost Currency
Cost rate factor
Mark Up
Planned start date

Userlevel 5
Badge +8

Hi @anmise,

 

Apart from the above, are there any other fields that should have values in order to avoid the error?

 

Best regards,

Devni

Userlevel 5
Badge +8

Issue was resolved by adding a value for column 'COMPANY' when uploading the CSV to Migration Job SC_50_CONTRACT_ITEM_L

Reply