When using the command ‘Copy Customer’ on page/Customer/Form we get error message ‘ORA-20121: CustOrdCustomer.INSERT: Field [CONSOL_RENTAL_IVC_SERIAL] in Customer may not be specified for new objects.’Any idea how to prevent having this error?We are running on 23R2.

Error when Copy Customer

When using the command ‘Copy Customer’ on page/Customer/Form we get error message ‘ORA-20121: CustOrdCustomer.INSERT: Field FCONSOL_RENTAL_IVC_SERIAL] in Customer may not be specified for new objects.’

Any idea how to prevent having this error?

We are running on 23R2.

Page 1 / 1

HI There,

It’s hard to predict the reason without debugging the code :)

But I saw few possible reasons that can cause the issue in IFS codebase.

Issue can happen due to several things in the code of Cust_Order_Customer_API

Several parts were fixed by ifs in these versions - 24R1 GA, 24R2 EA, 23R2 SU6 ( found this on KB0056204)

But one of my colleagues found out a missed correction even after 24R1 which is in Check_Update___ method .and we are going to report it to IFS

If you are SU4 or SU5 , Try to get to SU6 , If the issue permits most probably you have the same issue as us .

@Chamaka Wimalarathne thank you for the update!

Hi @LevOrjanM & @Chamaka Wimalarathne , Is this issue resolved? We get the same error while trying to migrate customer order customers using the data migration manager. Cloud version is 24R2. Thanks for your response and input.

@ifhamabdeen it’s working fully for our customer after moving to 23R2 SU14.

@LevOrjanM Can you please let me know if the ‘RENTAL’ component is installed in the environment and also which value did you use for the field CONSOL_RENTAL_IVC_SERIAL?

Enumeration values for this field are:

ConsolRentalIvcSerial

DB-values <==> Client-values :

YES <==> Yes
NO <==> No
SPECIFIED ON COMPANY <==> Specified on Company

Thank you!

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded