LCM Receipts Are Stuck in PENDING Status on Transaction Status Summary Form

(Doc ID 1058159.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Inventory Management - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts GUIForm:RCVTXVTX.FMB - View Transactions Status GUI
Executable:RCVLCMWS - Landed cost Integration Manager


Symptoms

On R12.1, find LCM transactions intermittently do not process and remain in rcv_transactions_interface with Status LC_PENDING. The unprocessed transactions are listed on Transaction Status Summary form with PENDING status. The records are stuck in rcv_transactions_interface with the following values:

transaction_status_code=PENDING
processing_status_code=LC_PENDING

Subsequent runs of Landed Cost Integration Manager concurrent program do not select the records.

debug log shows the following:
Entering RCV_CALL_LCM_WS.insertLCM22-JAN-2010 01:02:38
No of rows from RSH to be inserted: 4
calling LCM API for RSH
BEGIN(+)
p_int_rec.COUNT: 4
Get value from profile INL_SHIP_TYPE_ID_OI
l_ship_type_id: 1
p_int_rec(i).shipment_header_id: 2443
Get RCV_SHIPMENT_HEADERS info.
l_receipt_num: 64100234
l_ship_to_org_id: 512
l_ship_to_location_id:
l_receipt_num: 64100234
l_vendor_id: 4902
l_vendor_site_id:
l_user_defined_ship_num_code: AUTOMATIC
Get Operating Unit Id
10
l_org_id: 435
Check if the Ship To Organization has been setup in LCM Options
Get Party Id from PO_VENDORS
l_party_id: 10219
Get Taxation Country
l_ship_to_location_code: 641-FLA-Commercial-Primary
l_taxation_country: US
Get Legal Entity
l_legal_entity_id: 23273
l_ship_header_int_id:
l_group_id:
Insert into inl_ship_headers_int table
ORA-01403: no data found
Error: : 100 ORA-01403: no data found
erroredHeaderId: -9999
"ORA-01086: savepoint 'HEADERS' never established
ORA-01403: no data found"
"the error is: -1086 ORA-01086: savepoint 'HEADERS' never established
ORA-01403: no data found"
after calling LCM API for RSH: 4
the error is: 1 User-Defined Exception
Event Name:oracle.apps.fnd.system.exception Event Key:26062006Maximum nested
raise count:100Nested raise count: 0

Cause

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