My Oracle Support Banner

"You cannot update column created_by_module" Error When User Is Trying To Delete the Contact Purpose (Doc ID 3018781.1)

Last updated on APRIL 24, 2024

Applies to:

Oracle iSupplier Portal - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When user is trying to delete a Contact Purpose from the Supplier Contact, the following error occurs:

ERROR
-----------------------
You cannot update column created_by_module

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables Super User Responsibility
2. Go to Suppliers
3. Query the Supplier
4. Go to Contact Directory
5. Find the contact > Update
6. Two contact purposes are displayed
7. Delete Contact Purpose > The line is removed
8. Click Apply
9. Error occurs

Changes

Trading Community Architecture API (Application Programming Interface) validates the created_by_module (if value is passed) and throws error if it is not matching with existing value. It allows update of new value when there is no existing value.

Bug 36301253 - DELETE SUPPLIERS CONTACT PURPOSE ERROR'YOU CANNOT UPDATE COLUMNCREATED_BY_MODULE

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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