WIP MOVE TRANSACTION INTERFACE VALIDATION FAILS
Last updated on DECEMBER 06, 2016
Applies to:Oracle Work in Process - Version 12.1 and later
Information in this document applies to any platform.
***Checked for relevance 05-Jul-2015***
When attempting to insert into wip_move_txn_interface, the following error occurs.
failed in organization code/organization ID validation.
The issue can be reproduced at will with the following steps:
INSERT INTO wip_move_txn_interface
It occurs in the wip_move_validator.organization_id procedure, which is called by the WIP Move Transaction Manager.
It checks that the organization_code in the interface record matches a record in the mtl_parameters table, but it applies an UPPER() to the organization_code in interface table, but not in mtl_parameters. Our organization_code is "nic" so the query fails to find a match and flags the record as erred.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms