Online Transactions For Expense Destination or Unordered Receipts Stuck In RTI Pending Status In LCM Org (Doc ID 1265253.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Symptoms

Find in LCM as a Service / Black box Organization

Expense purchase orders cannot be received as records remain stuck in
rcv_transactions_interface table with

The issue only exists if  'RCV: Processing Mode' is set to On-line

Landed Cost Management is not applicable for Purchase Orders with Expense destination
so receipt transactions should be processed as standard receipts in Non LCM Organizations.

The same problem also occurs for Unordered Receipt
(since PO lines do not already exist, system works like if we were in the context of non LCM enabled lines in an LCM enabled organization).

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

1. Organization is LCM enabled as Landed Cost Management as a service / Blackbox
Setup / Organizations / Organizations
LCM Enabled flag = yes
In mtl_parameters table LCM_ENABLED_FLAG = Y

Receiving options
'Pre-Receiving in LCM' flag is not checked
In rcv_parameters table PRE_RECEIVE = N

2. Purchase Orders / Purchase Orders
Create and approve Purchase order with expense item
In po_line_locations_all table
LCM_FLAG null

In po_distributions_all
DESTINATION_TYPE_CODE EXPENSE

3. Set 'RCV: Processing Mode' profile option to On-line

4. Receiving / Receipts
Receive purchase order with expense destination type

5. Receiving / Transaction Status Summary
See 1 record with
Processing Mode = On-line
Transaction Status = Pending

In rcv_transactions_interface table see
TRANSACTION_TYPE RECEIVE
PROCESSING_STATUS_CODE PENDING
PROCESSING_MODE_CODE ONLINE
PROCESSING_REQUEST_ID NULL
TRANSACTION_STATUS_CODE PENDING
DESTINATION_TYPE_CODE EXPENSE

6. Create and approve purchase order with inventory destination type
Receive purchase order
Receiving / Transaction Status Summary
See 1 record with
Processing Mode = Batch
Transaction Status = Pending

In rcv_transactions_interface table see
TRANSACTION_TYPE RECEIVE
PROCESSING_STATUS_CODE LC_PENDING
PROCESSING_MODE_CODE BATCH
TRANSACTION_STATUS_CODE PENDING
DESTINATION_TYPE_CODE INVENTORY

6. Change RCV: Processing Mode to Immediate or Batch
Receiving / Receipts RCVRCERC form
Receive purchase orders
Receiving Transaction Processor is run and completes successfully
for expense or inventory destination

Changes

Cause

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