Skip to main content
Question

Migration job for CONTRACT_ITEM fails with an error

  • February 21, 2023
  • 7 replies
  • 109 views

Forum|alt.badge.img+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

  • Superhero (Employee)
  • 1471 replies
  • February 21, 2023

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


Forum|alt.badge.img+8

Hi @anmise,

 

Yes the value has been set.

 

Best regards,

Devni


  • Superhero (Employee)
  • 1471 replies
  • February 21, 2023
Devni Panduwawala wrote:

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?


Forum|alt.badge.img+8

Hi @anmise,

 

Yes those values have been set as well.

Please check the attached <Attribute String>.

 

Best regards,

Devni


  • Superhero (Employee)
  • 1471 replies
  • February 21, 2023
Devni Panduwawala wrote:

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


Forum|alt.badge.img+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


Forum|alt.badge.img+8

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings