G-Invoicing SYSTEM ID Update

 -- profile option for G-Invoicing Service Host at site level

spool /tmp/ECC_post_clone_steps.log

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('IGT_HOST','qa.ws.igt.ram.gov','SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

/

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM1' where ORG_ID=81;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM2' where ORG_ID=1290;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM3' where ORG_ID=3977;

update apps.IGT_SYSTEM_IDS set system_id='SYSHHSRAM4' where ORG_ID=2937;

commit;

update apps.IGT_SSL_CONTEXT_INFO set KEYSTORE_PATH='/u01/install/CUSTOM/ginvoicing/hhsginvoicing.pfx',

TRUSTSTORE_PATH='/u01/install/CUSTOM/ginvoicing/hhsginvqaserver.jks',

IGT_SCHEMA_ORDER_PATH='/u01/install/CUSTOM/ginvoicing/Order_2_3/accounting/Order.xsd',

IGT_SCHEMA_PERF_PATH='/u01/install/CUSTOM/ginvoicing/Performance_2_1/accounting/Performance.xsd';

commit;

spool off;