Receivables - EBS (MOSC)

MOSC Banner

You cannot update column created_by_module_ When trying to Reactivate Site use

edited Apr 30, 2020 5:06AM in Receivables - EBS (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center