ERROR

When attempting to run the Payables Open Interface Import, the following error occurs:

ERROR
—————
ZX_PRODUCT_TYPE_NOT_EFFECTIVE
This Product Type Code is not valid on the transaction date

SOLUTION

To implement the solution, please execute the following steps:

Step 1. Download and review the readme and pre-requisites for Patch:13814064:R12.ZX.B.

Step 2. Ensure that you have taken a backup of your system before applying the recommended patch.

Step 3. Apply the patch in a test environment.

Step 4. Confirm the following file versions:

$ZX_TOP/patch/115/import/US/zxvmlu.ldt 120.107.12010000.9

You can use the commands like the following:
strings -a $ZX_TOP/patch/115/import/US/zxvmlu.ldt|grep ‘$Header’

Step 5. Retest the issue.

Step 6. Migrate the solution as appropriate to other environments.

Reference: (Doc ID 1438286.1) Error During Payables Open Interface Import – This Product Type Code is Not Valid on the Transaction Date