Deliver Transaction With Project Info In RCV_TRANSACTIONS Creates Records In MMT Without Project / Task
Last updated on JUNE 01, 2016
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.
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.
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.
The issue can be reproduced at will with the following steps:
1. Enter a Purchase Order with project / task
In PO_DISTRIBUTIONS_ALL table PROJECT_ID and TASK_ID are filled
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