WIP MOVE TRANSACTION INTERFACE VALIDATION FAILS
(Doc ID 1055465.1)
Last updated on FEBRUARY 03, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document