processing zero record MDM inbound file

[Former Member]

Requirement: There are possbilities of zero records files going through MDIS. We need MDM ignore the record and reach finally in the archive folder. This way an external process which get triggered after an appearance of file in archive will be triggered (regardless of MDM got a zero record file).

How is it possible to accomplish this in MDM?

[Former Member · Accepted solution]

HI Subin,

This is what SKIP setting does when set in import action of Import Manager.

Thanks,

Ravi

[Former Member]

Ravi,

Strangely, MDM is doing a 'Create' instead of 'Skip' for this zero record file and it creates a blank record.

[Former Member]

Hi Subin,

It seems matching field itself is NULL and thus it is creating a NULL.

Set NULL handling for fields and save update after that.

Please retest and come back with findings.

Thanks,

Ravi

[Former Member]

You are spot on Ravi.

matching field is NULL and we tried to set NULL interpretation at 'field' level to Ignore. But even then MDM is not ignoring the blank value (no record passed in the file) and its creating a blank record.

[Former Member]

Hi Subin,

What is the source format you are using here?

If you are using xml you can make the matching field as required thereby avoiding such a scenario.

Thanks,

Ravi

[Former Member]

Ravi,

source format is xml.

and in mdm main table we have made it required for customer number field.

[Former Member]

We may need to write a validation workflow to do a check on blank customer number before inserting.

No other config setting is helping to avoid blank insert.

[Former Member]

Hi Subin,

In the XSD of this source make the KUNNR OR CUSTOMER NO as Required or make min occurs = 1 in xsd.You can even control the length of this element by modifying XSD.That way NULLS would land in structural exceptions.

Otherwise managing them at source is best way.One option can be catching such records at PI level.

I would suggest filtering such records outside MDM.

Thanks,

Ravi

[Former Member]

Thanks Ravi.

Passing blank file for us is a valid business scenario in our end to end context (legacy to SAP job stream) and we dont want MDM to fail or create exception during due to blank file.  So the solution is to have MDM validate the customer number based on workflow and ignore the file and utlimately put in archive folder.

[Former Member]

Hi Subin,

I would suggest rather than selecting and extracting roll backed records from ARCHIVE folder you go for syndicating them to a port.

This blog explains you how to do so -

http://scn.sap.com/docs/DOC-14833

Thanks,

Ravi