Creating Material Transactions Using Api GME_API_PUB.create_material_txn - Error: java.sql.SQLException: connection closed: next (Doc ID 2275608.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
API Issues

Symptoms

When running Create Material Transaction API, the following error occurs as seen in GME debug log:

ERROR
-----------------------
GME_transactions_PVT.PROCESS_TRANSACTIONS:After calling INV_TXN_MANAGER_PUB.process_transactions l_return= -1 x_return_status= S x_msg_data = Ex.. in processTrxBatch ..:java.sql.SQLException: Connection close: next
Entering api GME_COMMON_PVT.log_message
FROM LOG_MESSAGE FND_GENERIC_MESSAGE/MESSAGE/Ex.. in processTrxBatch ..:java.sql.SQLException: Connection close: next//////////
Exiting api GME_COMMON_PVT.log_message
GME_transactions_PVT.PROCESS_TRANSACTIONS:UNEXPECTED:User-Defined Exception
GME_API_PUB.SAVE_BATCH:Return status from process_transactions U
return from save batch withU
GME_API_PUB. CREATE_MATERIAL_TXN - Return E
Msg (1) --> Ex.. in processTrxBatch ..:java.sql.SQLException: Connection close: nex
t

...


STEPS:

1. Run Create Material Transaction API

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