My Oracle Support Banner

Processes Uploaded Mobile Data Program Hangs When Deleting From ASG_AUTO_SYNC_TRANIDS (Doc ID 1504892.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Mobile Field Service - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.2


The 'Processes Uploaded Mobile Data' program is hanging on this statement:

DELETE FROM ASG_AUTO_SYNC_TRANIDS WHERE USER_NAME = :B2 AND UPLOAD_TRANID

and the blocker session is firing query:

SELECT "INVENTORY_ITEM_ID","ORGANIZATION_ID","INVENTORY_NAME","DESCRIPTION","ENA
BLED_FLAG","START_DATE_ACTIVE","END_DATE_ACTIVE","PRIMARY_UOM_CODE","SERVICE_ITE
M_FLAG","SERVICEABLE_PRODUCT_FLAG","MATERIAL_BILLABLE_FLAG","RETURNABLE_FLAG","M
TL_TRANSACTIONS_ENABLED_FLAG","SERV_REQ_ENABLED_CODE","SERIAL_NUMBER_CONTROL_COD
E","LOT_CONTROL_CODE","INVENTORY_ASSET_FLAG","PURCHASING_ENABLED_FLAG","INTERNAL
_ORDER_ENABLED_FLAG","INTERNAL_ORDER_FLAG","PURCHASING_ITEM_FLAG","RESTRICT_SUBI
NVENTORIES_CODE","COMMS_NL_TRACKABLE_FLAG","STOCK_ENABLED_FLAG","ATTRIBUTE1","AT
TRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTR
IBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","AT
TRIBUTE14","ATTRIBUTE15","ATTRIBUTE_CATEGORY","CONTRACT_ITEM_TYPE_CODE","RECOVER
ED_PART_DISP_CODE","REVISION_QTY_CONTROL_CODE","RESTRICT_LOCATORS_CODE","LOCATIO
N_CONTROL_CODE","LIST_PRICE_PER_UNIT","INVENTORY_NAME_UPPER",DMLTYPE$$ FROM "CTM
$CSM_MTL_SYSTEM_ITEMS" WHERE CLID$$CS =


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Processes Uploaded Mobile Data concurrent.

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.