Oracle Retail Knowledge Base

4 Prepare for Conversion

4 min read

Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

Click the Generate Templates button to download the templates. The generated templates will be moved to object storage from where you can download them using the Merchandising File Transfer Service. While downloading the templates, use dataconversion/outgoing as the object storage (OS) prefix.

There will be one file per table that can be supported in the conversion and each file will contain details on:

  • File naming pattern

    • For example, the naming pattern for the DEPS table is defined as deps*.dat. The * in the name can be replaced by a number (such as deps1.dat, deps2.dat) or just left off, depending on your conversion plans.

    • If the filename does not match the pattern it will be ignored and will not be picked for loading.

  • Column sequences

    • Your data files must follow the sequence of the columns specified in the template. If any column data is to be left as null, then it should be present, but just left blank.

  • Data type and length of each column in the table, including a short description of the columns and table

  • Whether the column is mandatory

  • Primary key for the table, along with any foreign or unique keys and any check constraints

Note

This file is generated based on the Merchandising data model and only the validations aligned with the Merchandising data model are listed. The business-level validations are not called out.

Escaping comma iol corp corp tH te te 1 1015, Lighting, 109 d0,1,0,304,35,53.8462,,C,C,1,1,Nyr¢5 2 1016,Kitchen Hm prymnt,1000,701,1,0,304,15,17.6471,,C0,C,1,1,Nea0, 3.1017, Bathroom, 1/00, 702,1,0,304,15,17.6471,,C,C,1,1,N,,,, 4 10dd18,Windows\, Doors,101,830,1,0,304,30,42.8571,,€,C,1,1,N,y,, 5 1019, Lawn, Garden, 103,830,1,0,304,45,81.8182,,C,C,1,1,N,,, 6 1020,Tools,635,700,1,0,305,55,122.2222,,C,C,1,1,Nee4, 7 1d0021,Hardware, 635,701,1,0,305,6w0,150,,C,C,1,1,Nyey, & 1022, Plumbing, 635, 702,1,0,305,45,81.8182,,C,C,1,1,Nyo4, § 1023, Heating/Cooling, 1000,700,1,0,305,65,185.7143,,C,C,1,1,N,,,, 10 1024,Hardware Services, 1000,701,1,0,305,10,11.1111,,€,C,1,1,N,,,, 11 1025, Dogs, 1000, 702, 1,0, 306,25, 33.3333,,C,C,1,1,N,.,, 12 1026,Cats,1000,840,1,0,306,25, 33.3333,,C,C,1,1,N,0,,306,25, 33.3333,,C,C,1,1,N,0,, 33.3333,,C,C,1,1,N,0,, 13 1027, Birds,1000, 840,1,0,306,25,33.3333,,C,C,1,1)Nenee 14 1028, EngineParts/Filters,1000,8.Q00E+45,1,0,307,45,81.9182,,C,C,1111,1,N,,., EngineParts/Filters,1000,8.Q00E+45,1,0,307,45,81.9182,,C,C,1111,1,N,,., 15 1029,Exhaust, Emission, 610,845,1,0,307,45,81.8182,,C,C,1,1,N,,, 16 1030,Tires, Wheel Care,610,845,1,0,307,45,81.8182,,C,C0,1,1,N,,, 17 1031,Music,5,700,1,0,308,35,53.8462,,C,C,1,1,Ny¢¢, 18 1032,Books Reference*,1000,701,1,0,308,45,81.8182,,C,C,1,1,Niy04 15 1033,Newspaper Magazine, 1000, 702,2,7,308,10,11.1111,,C,R,0,1,N,,,, 702,2,7,308,10,11.1111,,C,R,0,1,N,,,, 20 1034, Video/DVD, 1000, 700,1,0,308,20,25,,C,C,1,1,N,5., 21 103s5,Games/Software,1000,701,1,9,308,20,25,,C,C,1,1,Nee0, 22 1036. Plush. 1000, 702.1.0,309.55,122.2222,.C0,.C.1.1.N… 702.1.0,309.55,122.2222,.C0,.C.1.1.N…

noted in the “Converting Non-Merchandising Solutions” section, there are other methods that should be used for seeding downstream systems, if needed, after Merchandising conversion. To disable MFQUEUE triggers leverage the DISABLE_PUBLISHING_TRIGGERS task in the System Administration screen. This task will disable all MFQUEUE publishing triggers. Details on how to do this can be found in the “Task Execution Engine” section of this document.

Once the data conversion is completed, you will need to re-enable the triggers and also ensure that the converted data is properly readied for future publication, so that it is sent as an update (or delete) rather than create. Based on your Merchandising data integration to downstream systems, enable the required triggers by executing ENABLE_TRIGGER task in the System Administration screen. See the “MFQUEUE Triggers” section in the appendix for the list of triggers.

Finally, to prepare your data for future publication, records must be loaded into PUB_INFO tables for these entities with the published indicator set to Y. In the cases where the converted entities do not have a separate publishing table and published indicator resides in the merchandising table itself, the indicator should be marked as Y (published). To initialize Merchandising publishing tables, execute the INIT_PUBLISHING task in the System Administration screen. It will populate PUB_INFO tables as necessary and sets the published indicator to Y for the converted entities.

Golden Gate Replication

It is strongly recommended you choose an environment to use for conversion that does not need replication by Golden Gate, as disabling Golden Gate before data conversion and restarting the services after import is completed is an extensive process involving efforts from both, you and Oracle Cloud Operations team. However, in case your data conversion environment does have Golden Gate replication enabled, it should be disabled for data conversion processes , including all mock runs, to progress at maximum throughput. For this, you are required to log an SR with Oracle Cloud Operations team. After completion of data conversion, Golden Gate replication can be turned back on.

In this guide

  • 8 Task Execution Engine — Merchandising Cloud Services Data Conversion Implementation Guide · shares DISABLE_PUBLISHING_TRIGGERS, ENABLE_TRIGGER, INIT_PUBLISHING, PUB_INFO

Graph View

Backlinks