...
The quick answer is: you must reload your data in production so it goes through certification again. To do this: take the MI MD records and reload them into the SD table in Production.
...
| Code Block |
|---|
INSERT into SEMARCHY_DEMO_MDM.SD_CUSTOMER (
B_LOADID /* Semarchy specific data fields */
,B_CLASSNAME
,B_PUBID
,B_SOURCEID /* Customer system fields */
,CUSTOMER_NAME /* Data fields */
,TOTAL_REVENUE
,INPADDRESS
,INPPOSTAL_CODE
,INPCITY
,INPCOUNTRY
,F_ACCOUNT_MANAGER
)
SELECT
v_load_id /* B_LOADID - v_load_id is a variable declared earlier */
,'Customer' /* B_CLASSNAME - Entity name. Found in MDM Workbench UI. */
,B_PUBID /* B_PUBID - Publisher ID mapped to B_PUBID in SD table to track source systems. */
,B_SOURCEID /* B_SOURCEID - mapped to B_SOURCEID in SD table. */
,CUSTOMER_NAME /* Data fields */
,TOTAL_REVENUE
,INPADDRESS
,INPPOSTAL_CODE
,INPCITY
,INPCOUNTRY
,F_ACCOUNT_MANAGER
FROM SEMARCHY_DEMO_MDM.MIMD_CUSTOMER
/* Add a clause to filter records */
-- WHERE MIMD_CUSTOMER.CUSTOMER_ID = ?? |
...
| Code Block |
|---|
create or replace procedure SEMARCHY_DEMO_MDM.RELOAD_CUSTOMER_LOAD
AUTHID CURRENT_USER AS
v_load_id int;
v_batchid int;
v_submit_load_ok boolean := TRUE;
BEGIN
v_load_id := SEMARCHY_DEMO_REPOSITORY.INTEGRATION_LOAD.GET_NEW_LOADID (
'CustomerMDM' /* Data Location Name. Case sensitive. Found in MDM Workbench UI. */
,'MANUAL_ETL' /* Informational. Describes the process or program doing the load. */
,'Test to reload master records' /* Informational. Describes the load. */
,'MANUAL_ETL_USER' /* User initializing the load. (Not found in MDM Workbench UI.) */
);
BEGIN
INSERT into SEMARCHY_DEMO_MDM.SD_CUSTOMER (
B_LOADID /* Semarchy specific data fields */
,B_CLASSNAME
,B_PUBID
,B_SOURCEID /* Customer system fields */
,CUSTOMER_NAME /* Data fields */
,TOTAL_REVENUE
,INPADDRESS
,INPPOSTAL_CODE
,INPCITY
,INPCOUNTRY
,F_ACCOUNT_MANAGER
)
SELECT
v_load_id /* B_LOADID - v_load_id is a variable declared earlier */
,'Customer' /* B_CLASSNAME - Entity name. Found in MDM Workbench UI. */
,B_PUBID /* B_PUBID - Publisher ID mapped to B_PUBID in SD table to track source systems. */
,B_SOURCEID /* B_SOURCEID - mapped to B_SOURCEID in SD table. */
,CUSTOMER_NAME /* Data fields */
,TOTAL_REVENUE
,INPADDRESS
,INPPOSTAL_CODE
,INPCITY
,INPCOUNTRY
,F_ACCOUNT_MANAGER
FROM SEMARCHY_DEMO_MDM.MIMD_CUSTOMER
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
dbms_output.put_line('Encountered error ORA-00001. You attempted to insert non-unique records into the SD table.');
v_submit_load_ok := FALSE;
WHEN OTHERS THEN
dbms_output.put_line('Encountered an error while inserting into the SD table');
v_submit_load_ok := FALSE;
END;
IF v_submit_load_ok THEN
v_batchid := SEMARCHY_DEMO_REPOSITORY.INTEGRATION_LOAD.SUBMIT_LOAD (
v_load_id
,'INTEGRATE_DATA' /* Must exactly match a defined integration job. Found in MDM Workbench UI. */
,'MANUAL_ETL_USER' /* Must exactly match the value of the User used in GET_NEW_LOADID above. */
);
ELSE
SEMARCHY_DEMO_REPOSITORY.INTEGRATION_LOAD.CANCEL_LOAD( v_load_id, 'MANUAL_ETL_USER' );
END IF;
END;
/
/* Run the procedure like this (it takes no parameters) */
exec SEMARCHY_DEMO_MDM.CUSTOMER_LOAD;
|
...