Configuring Database Changes

Procedure

  1. Navigate to the database.
  2. Run the following scripts from the database.

Result

Note: Use the OrgID of your organization and replace it in the SQL below where it displays <Org ID Here>.
  • Bottler Subscription Rulebase 
    insert into ConfigurationDefinition (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION, ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
VALUES (Mq_Sequence_1.nextval, 'Rulebase', <Brandowner's Org ID Here>, 'N', 'Bottler Subscription', ‘SUBSCRIPTION’, 'Select Subscription.', 'File', 'bottler/rulebase/rbsynchtradingpartner.xml', 'Y', 1, SYSDATE, 1);
COMMIT;
  • BrandOwner Translation Map 
    insert into ConfigurationDefinition 
(ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION,
 ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
VALUES (Mq_Sequence_1.nextval, 'XSLT', <Brandowner's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR', 
'Message Translation.', 'File', 'standard/maps/mpfromcatact26toveloselcinv1.xsl', 'Y', 1, SYSDATE, 1);
COMMIT;
  • VeloselMarketplace Translation Map 
    insert into ConfigurationDefinition 
(ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION, 
ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
VALUES (Mq_Sequence_1.nextval, 'XSLT', <VeloselMarketplace's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR', 'Message Translation.', 'File', 'standard/maps/mpfromcatact26toveloselcinv1.xsl', 'Y', 1, SYSDATE, 1);
COMMIT;
insert into ConfigurationDefinition 
(ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION,
 ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
VALUES (Mq_Sequence_1.nextval, 'XSLT', <VeloselMarketplace's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR', 
'Message Translation to create Response.', 'File', 'standard/maps/mpfromveloselcintoveloselcinrv1.xsl', 'Y', 1, SYSDATE, 1);
COMMIT;
  • VeloselMarketplace Subscription Rulebase 
    insert into ConfigurationDefinition (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION, ACTIVE, MODMEMBERID, MODDATE, MODVERSION) VALUES (mq_sequence_1. nextval, 'Rulebase', <VeloselMarketplace's Org ID Here>, 'N', 'Bottler Subscription', 'SUBSCRIPTION', 'Select Subscription.', 'File', 'bottler/rulebase/rbsynchveloselmarketplace.xml', 'Y', 1, SYSDATE, 1)
COMMIT;
  • VeloselMarketplace Translation Maps (Instance 2)
    • XSL Map for translating CIM CIN to mlXML: 
mpfromveloseltomlxml26v1.xsl
    • XSL Map for translating CIM CIN to CIM CIN Response: mpfromveloselcintoveloselcinrv1.xsl
Note: For simplicity, you can make all the above Subscription Rulebase and Translation Map files globally available as follows:
  • Enter a value '1' instead of <Brandowner's OR VeloselMarketplace's Org ID Here> for column OWNERID
  • Enter a value 'Y' instead of 'N' for column GLOBAL.