My Oracle Support Banner

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:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References


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