Deliver Transaction With Project Info In RCV_TRANSACTIONS Creates Records In MMT Without Project / Task (Doc ID 1588580.1)

Last updated on JULY 14, 2023

Applies to:

Symptoms

PO receipt transactions are showing Transfer to Project field as "Not applicable".

In fact, the project references are not there on these transactions in MTL_MATERIAL_TRANSACTIONS table hence they are "Not applicable".

Project and Task information are in the PO distribution details and also in RCV_TRANSACTIONS tables.

Expected behavior
Expect PO Deliver transactions (that have TASK_ID and PROJECT_ID populated in RCV_TRANSACTIONS table) to generate in MTL_MATERIAL_TRANSACTIONS table a record with TASK_ID and PROJECT_ID populated.

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

Example:
1. Enter a Purchase Order with project / task
In  PO_DISTRIBUTIONS_ALL  table PROJECT_ID and TASK_ID are filled

 Identification sql:

Select * from mtl_material_transactions
where rcv_transaction_id in ( select transaction_id from RCV_transactions where
project_id<>0 and task_id<>0
and transaction_type='DELIVER')
And project_id is null
And task_id is null;

Cause

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