Untitled

In this scenario, we have made modifications to an existing procedure known as PI_PDORIS (schema 163, flow 64). By employing this procedure, we are able to handle cases where the PRODUCTCODE mentioned in the feed file PRXMINVC is not present in our database. In such instances, the procedure appends the prefix 'prxm-' to the given PRODUCTCODE, resulting in the creation of new CLCDs within the CL02I table, provided they are not already present. This enables us to manage the integration of new product codes seamlessly and ensures their availability within our system.