CAMT053 How to Handle Duplicate Transaction Codes with different XML Family Code

Summary:

We are configuring CAMT053 bank statements for Natwest Bank and we are still continuing to use BAI2 for other banks.

I have hit a couple of issues.

1. There are duplicate transaction codes with different Domain, Family, Subfamily code combinations. Oracle will only allow you to create one transaction code with the same name and so I don't know how we can handle this in Oracle.

For example, Transaction Code FMSC appears twice, once with XML FAMILY CODE of MCOP (Credit) and once with XML FAMILY CODE OF MDOP (Debit)

How can we create these in Oracle?

2. Some transaction codes that have been provided by the bank are shared with existing transaction BAI2 codes.