WIP MOVE TRANSACTION INTERFACE VALIDATION FAILS (Doc ID 1055465.1)

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***



Symptoms

When attempting to insert into wip_move_txn_interface, the following error occurs.

ERROR

failed in organization code/organization ID validation.


STEPS

The issue can be reproduced at will with the following steps:
1.

INSERT INTO wip_move_txn_interface
(last_update_date,
last_updated_by,
last_updated_by_name,
creation_date,
created_by,
created_by_name,
source_code,
process_phase,
process_status,
transaction_type,
organization_id,
organization_code,
wip_entity_id,
wip_entity_name,
primary_item_id,
transaction_date,
fm_operation_seq_num,
fm_intraoperation_step_type,
to_operation_seq_num,
to_intraoperation_step_type,
transaction_quantity,
transaction_uom)
2.
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms