WIP MOVE TRANSACTION INTERFACE VALIDATION FAILS (Doc ID 1055465.1)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.