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 APRIL 13, 2021
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: next
...
STEPS:
1. Run Create Material Transaction API
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 |