Configuring Database Changes
- Procedure
- Navigate to the database.
- 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.