You cannot update column created_by_module_ When trying to Reactivate Site use
Hi All,
I'm trying to reactivate some site use and it is throwing below error :
"You cannot update column created_by_module."
If I try to Comment out "P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_V2_API'; " then it is throwing below error
“Column created_by_module must have a value”
Could you please suggest what exactly needs to be done??
CREATE OR REPLACE PROCEDURE xxpq_activate_bill_site_use( p_err_flag OUT VARCHAR2, p_err_msg OUT VARCHAR2)AS CURSOR cur_sites ISSELECT DISTINCT HCAS.CUST_ACCT_SITE_IDFROM APPS.HZ_PARTIES HP, APPS.HZ_PARTY_SITES HPS, APPS.HZ_CUST_ACCOUNTS HCA, APPS.HZ_CUST_ACCT_SITES_ALL HCASWHERE hp.party_id =hps.party_id AND hps.party_id=hca.party_idand hp.party_type = 'ORGANIZATION' and hp.party_number = '283470'and hps.party_site_number = '1224518'AND HCAS.ORG_ID=81AND hcas.status='I'; CURSOR cur_site_uses(p_cust_acct_site_id NUMBER) IS SELECT site_use_id,object_version_number FROM apps.hz_cust_site_uses_all WHERE cust_acct_site_id = p_cust_acct_site_id and site_use_code in ( 'SHIP_TO','BILL_TO'); l_return_status VARCHAR2 (1);l_msg_count NUMBER;l_msg_data VARCHAR2 (2000);l_msg_index_out NUMBER;P_CUST_SITE_USE_REC hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;--p_object_version_number number(10);l_object_version_number number;l_site_use_id number;BEGIN FOR rec_sites IN cur_sites LOOP OPEN cur_site_uses (rec_sites.cust_acct_site_id); FETCH cur_site_uses INTO l_site_use_id,l_object_version_number; CLOSE cur_site_uses; P_CUST_SITE_USE_REC.site_use_id:= l_site_use_id; P_CUST_SITE_USE_REC.status:= 'A'; P_CUST_SITE_USE_REC.cust_acct_site_id := rec_sites.cust_acct_site_id; --P_CUST_SITE_USE_REC.SITE_USE_CODE := 'SHIP_TO'; P_CUST_SITE_USE_REC.CREATED_BY_MODULE