TXN_SOURCE_ID Column Value Is NULL In MTL_TXN_REQUEST_LINES In R12 (Doc ID 2067348.1)

Last updated on DECEMBER 02, 2016

Applies to:

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

Goal

Users Migration from 11i to R12.1.3

WMS Putaway rule created which uses two Expressions.

Problem: In 11i, both SQL statements found in Seq 20 and 30 work successfully. Moving to R12.1.3 the SQL expression used in Seq 20 works successfully, but the SQL expression in Seq 30 does not.
SQL expression used in Seq 20 retrieves data for Internal Requisition receipts. This works in R12 the same as it did in the 11i instance.

The SQL expression used in Seq 30 does not return the expected value. Examination of the underlying data indicates that the value passed for mptdtv.txn_source_id is not being populated in the R12 view. This data is populated in the 11i version.

Solution

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