JDEDB_COMMIT_MANUAL, JDEDB_COMMIT_AUTO, and Transaction Processing Boundaries

Purpose of Document

The purpose of this document is to give users possible debug means for Transaction Processing. Note that the list of Business Functions listed in this document is inexhaustible.

Table of Contents:

Overview
Syntax
Transaction Processing in EnterpriseOne
List of BSFN which has MANUAL COMMIT
List of BSFNs which have AUTO COMMIT
Representation in JDEDEBUG log
Representation in DB Connection string
Example of AUTO COMMIT
Summary

Overview:

Deadlock: Refer to <Document 1228683.1> E1: DB: Case Study on Deadlocks in EnterpriseOne Applications
Transaction Processing: Refer to <Document 1208208.1> E1: DB: Transaction, Transaction Processing, Commit and Rollback
Transaction Processing Boundaries: Refer to <Document 625535.1> E1: 40: Transaction Processing in EnterpriseOne Distribution Applications

Syntax

Syntax:
idJDBReturn = JDB_InitUser((HENV) lpBhvrCom->hEnv, &hUser, (JCHAR *)NULL, JDEDB_COMMIT_AUTO);
JDEDBReturn = JDB_InitUser( (HENV) lpBhvrCom->hEnv, &hUser, _J("B4302830"), JDEDB_COMMIT_MANUAL );

JDB_InitUser initializes a user and registers the user within the JDB environment identified by the ipBhvr. The user handle that is returned from the API will identify all operations within the JDB environment. A user is usually an application or business function and is a method of grouping database requests from the same application together.
In addition, the user indicates the commitment mode for all the database operation that will take place. This means that all the database operations by the user will be associated with the same commitment mode.
Please do not use the manual commitment mode unless you absolutely have to.
Refer JDB_InitBhvr() API
Paired API is JDB_FreeUser() API

Parameters:

Parameter	I/O	Notes
lpBhvr	Input	Valid environment handle pointer
hUser	Output	Valid User Handle (via InitBhavior)
szApp	Input	Valid string pointer of active application or NULL
nCommitMode	Input	1. JDEDB_COMMIT_AUTO if transaction are to be committed automatically 2. JDEDB_COMMIT_MANUAL if transactions are to be committed manually

Return Value:

Return Value	Description
JDEDB_PASSED	Return value if this succeeds
JDEDB_FAILED	Return value if this fails

Note:

Example of code to implement MANUAL COMMIT

eJDBReturn = JDB_InitBhvr(lpBhvrCom, &hUser,(JCHAR*)NULL,
                                 JDEDB_COMMIT_AUTO); /* which returns &hUser */

   eJDBReturn = JDB_InitUser((HENV) lpBhvrCom->hEnv, &hUserManual, (JCHAR*)NULL,
                            JDEDB_COMMIT_MANUAL); /* another pointer &hUserManual is returned which enable boundary */

There is another commit mode JDEDB_COMMIT_SFU (Select For Update) which is commonly used through SelectKeyedForUpdate API. However E1 does not specify it explicitly in making database connection.

Transaction Processing in EnterpriseOne

Refer to:

<Document 1320968.1> E1: DB: Listing of Applications with Transaction Processing by EnterpriseOne Release
<Document 1208208.1> E1: DB: Transaction, Transaction Processing, Commit and Rollback
<Document 1265902.1> E1: BSFN: Master Business Function in EnterpriseOne

Notes:

How to set JDB_InitUser() in calling a certain business function from interactive application
Transaction Processing and transactional Master business function are tightly related with each other

List of BSFN which has MANUAL COMMIT
Transaction Processing can be turned on from an application in calling system function or setting it through form properties. Below lists routines to fire MANUAL COMMIT when calling routing does not have Transaction Processing process. Most of the routines written here are:

Called by application listed in Transaction Processing
Critial Update for tightly related tables
Higher integrity needed
Business Functions created for batch process
Not a Master Business Function (MBF)
3rd party interface (inbound/outbound/RTE/XML and so on)

Product Code	Object Name	Function Name (Description)	Table Related	Parent DLL/What For/Major Application with MBF
03B	B03B0019	VoidNSFReceipt (F03B13 Void/NSF Receipt)	F03B11, F03b13, F03B14, F03B40	(CFIN) Refer to <Bug 12593031> - Added condition to check if called from netting function then no need to initialize handle for transaction processing since the netting is already done in transaction processing and this function will come under its transaction boundary. Applications calling this BSFN (not through OK button clicked): P03B0001 - Speed Receipts Entry P03B102 - Standard Receipt Entry P15103 - RE Standard Receipt Entry cf., B03B0138/B03B0149 - F03B13 Maintain Receipt Header/F03B14 Maintain Receipt Detail
03B	B03B0230	BatchInvoiceProcessorCFunction (Batch Invoice Processor C Function)	F03B11Z1, F0911Z1	(CFIN) Called by R03B11Z1A - Batch Invoice Processor - C Function
03B	B03B0240	NettingEntryForAR (Netting Entry for Accounts Receivable)	Tables for AR and AP transaction	(CFIN) This function is to call MBF for AR and AP Called by P03B455 - AR/AP Netting Example: lpdsB03B0240Uber->idJDBReturn = JDB_InitUser((HENV) lpBhvrCom->hEnv, &lpdsB03B0240Uber->hUserManual, _J("P03B455"), JDEDB_COMMIT_MANUAL);
00	B03B0260	ARAPNettingRollback (AR/AP Netting Rollback)		(CFIN) To Rollback above BSFN B03B0240
03B	B03B0501	KnownInvoiceMatchWithAmount (Known Invoice Match With Amount)	F03B13, F03B13Z1, F03B14	(CFIN) Called by R03B50D - Known Invoice Match With Amount
04	B0400033	NettingEntryForAP (Netting Entry for A/P)	Tables for AR and AP transaction	(CFIN) Corresponding BSFN for B03B024
04	B0404110	BatchVoucherCacheRead (Batch Voucher Processor Cache Read Function)	F0411Z1 F0911Z1	(CFIN) Called by R04110ZA - Batch Voucher Processor Report
09	B0900260	ComputeAdvancedVariableNumerator (Compute Advanced Variable Numerator)	F0010, F0013, F0025, F09UI123, F09123, F09123A, F48S84, F52G02, F0006, F0902, F01131M	(CFIN) Called by R09123 - Compute Advanced Variable Numerator
09	B0900601	MoveBankStatementFile (Move Bank Statement File)	F09610, F09611	(CFIN) Called by R09600 - Process Automatic Bank Statement
09	B0900602	ProcessSwiftFormat (Process Swift Format)	Same with B0900601	(CFIN) Same with B0900601
09	B0900621	ProcessGLAccountReconciliation (Process GL Account Reconciliation)	F03B11, F03B14, F0411, F0413, F0414, F0911, F0911R	(CFIN) Called by R09150 - G/L Account Reconciliation
31B	B31B682	ErrorRecoveryProcessing (Error Recovery Processing)	F31B33, F31B70, F31B91, F31B10	(CWIM) Called by P31B68 - Reverse Operations
31B	B31B684	Init_Reverse_Blend_Transactions (Initialize Reverse Blend Transactions)	F31B66, F31B13, F31B70, F31B91	CWIM
40G	B40G1100	ReceiptPriceAdjustmentProcess (Receipt Price Adjustment Process)	F43126, F4316, F4311, F43121	(CDIST) Called by P4074 - Check Price and Availability, R45620 - Reprice Procurement/Receipts
41	B4101810	ProcessF41021WFRecords (Process F41021WF Records)	F41021WF, F41021	(CINV) To rollback data from F41021 when a certan inventory transaction hits COMMIT FAIL error. It rollback (update) F41021 based on data from F41021WF. That is, when COMMIT is success then data from F41021WF gets deleted otherwise data from F41021WF will be remained. This function can be called any application which may update F41021 Refer to <Document 625445.1> E1: 40: Manual Rollback Process of Item Location (F41021) File
42W	B4277712	AllocationCommitSalesOrder (Allocation Commit Sales Order)	F427UI02	(CDIST) R4277701 - Auto Fulfillment for Fulfillment
42W	B4277720	ClearReleaseFromAllocationCache (Clear Release from Allocation Cache)	F4211, F49211	(CDIST) R4277703 - Release from Fulfillment
42W	B4277762	CleanupFMEntryResources (Cleanup Fulfillment Management Entry Resources)	F4101, F4102	(CDIST) R4277704 - Fulfillment Management Entry
42W	B4277790	LoadBalanceAutoFulfillment (Load Balance Auto Fulfillment)	F4277710, F4211	(CDIST) R4277711 - Load Balance Auto Fulfillment
43S	B4302830	CreateInvoiceHeaderDetail (Create Invoice Header and Detail)	F4313, F4314	(CDIST) Called by P4313 - POFLIP
43B	B4305500	ProcessProgressPaymentsfromCM (Process Progress Payments from CM)	F4311T, F4310X, F0411X, F51006X, F5311X, F5311, F4311 F51010	(CDIST) Called by R4314CM - Process Progress Payment CM
40R	B40R0630	RemoveOldDemandWrapper (Remove Old Demand Wrapper)	Not in Use	CDMDSCH
49	B49T0010	ProcessSalesFreightRequest (Process Sales Freight Request)	F4201, BV49T211	(CTRAN) R49T10 - Sales Freight Request Export R49T30 - Sales Order Confirmation Export
49	B49T0020	CompleteTranspoArrangedProcess (Complete Sales Transportation Arranged Processing)	BV49T20A, BV49T211B, BV49T211C, BV49T211D, F0101	(CTRAN) R49T20 - Sales Transportation Arranged Import
49	B49T0025	TransporationArrangedXMLParser (Transporation Arranged XML Parser)	F49T20	CTRAN
49	B49T0040	CompleteTranspoConfirmProcess (Complete Sales Transportation Confirmation Processing)	F49T40	(CTRAN) Called by R49T40 - Sales Transportation Confirmation
49	B49T0400	TranspConfirmationXMLParser (Transportation Confirmation XML Parser)	F49T40	CTRAN
49	B49T0600	processInboundVoucherXML (Process Inbound Voucher XML - Trans Planning)	XML Interface	CTRAN
49	B49T0710	CleanupProcurementFreightRequest (Cleanup Procurement Freight Request)		(CTRAN) Called by R49T100 - Procurement Freight Request
53	B5300030	ProcessChangeRequestsfromCM (Process Change Requests from CM)	F53101, F51006X, F5311X, F5311CM, F4310X, F4311, F41010	(CAEC) Called by R5310CMI - CM To E1 Process Change Request

Notes:

Any xxxEndDoc MBF (Master Business Function) called with 'Transaction Processing' ON at Post OK button clicked (and Button Clicked - Asynch event) are not listed above because the application level API will set COMMIT_MANUAL.
A full list of applications can be found in <Document 1320968.1> E1: DB: Listing of Applications with Transaction Processing by EnterpriseOne Release.
Transaction Processing is tightly related with MBF. Refer to <Document 1265902.1> E1: BSFN: Master Business Function in EnterpriseOne

The BSFNs below are related to upgrade /installation /package. Since this document explains transactions from the application level, it does not ellaborate details on BSFNs:

Product Code	Object Name	Function Name (Description)	Parent DLL
01RS	B01RS103	OBACustomerMaster (OBA - Customer Master)	CALLOBA
01RS	B01RS104	OBASupplierMaster (OBA - Supplier Master)	CALLOBA
01RS	B01RS105	OBATaxAuthorities (OBA Tax Authorities)	CALLOBA
01RS	B01RS106	OBAPaymentTerms (OBA Payment Terms)	CALLOBA
01RS	B01RS107	OBATaxRateAreas (OBA - Tax Rate Areas)	CALLOBA
01RS	B01RS108	OBATaxRules (OBA Tax Rules)	CALLOBA
01RS	B01RS109	OBACurrencyCodes (OBA Currency Codes)	CALLOBA
01RS	B01RS110	OBARoles (OBA - Roles)	CALLOBA
01RS	B01RS12L	OBAAutomaticAccountingInstF0012 (OBA Automatic Accounting Inst F0012)	CALLOBA
01RS	B01RS301	OBAShopFloorCalendars (Shop Floor Calendars)	CALLOBA
01RS	B01RS409	OBADistributionMFGAAIF4095 (OBA Distribution MFG AAI F4095)	CALLOBA
01RS	B01RS505	OBAEmployees (OBA - Employees)	CALLOBA
01RS	B01RS901	OBAAccountMasterF0901 (OBA Account Master F0901)	CALLOBA
H95	B956311A	DeleteRDJobRecords (Delete Report Definition Job_Output_Delivery records)	COBJLIB
H96U	B9894004	ConfigurePackageManifest (Configure Package Manifest)	CINSTALL

Notes:

MANUAL COMMIT is very expensive but in return, it maintains a higher integrity among tables
In case you want to exclude update/delete a certain table outside transaction, implement AUTO COMMIT

List of BSFNs which have AUTO COMMIT

Below is a list of EnterpriseOne business functions that are important because the routines set below are listed tables to set Outside Transaction Processing Boundaries. This implementation is important to prevent Deadlock in a single process. Table Cursor will be released after the close table. Most of BSFNs defined here are:

Sub-routine of MBF (Master Business Function)
Frequently accessed by multiple processes
Update of control table (Next Numbering)
Possible deadlock
Integrity is not main concern

Product Code	Object Name	Function Name (Description)	Table Related	Parent DLL/What For/Major Application with MBF
03B	B03B0501	KnownInvoiceMatchWithAmount (Known Invoice Match With Amount)	F03B13, F03B13Z1, F03B14	(CFIN) Refer to MANUAL COMMIT section This function open hUser in auto commit mode so the fetches are not adversely affected by the updates happening in the called external functions
04	X04131	RetrieveNextPaymentID (F0413 Get Next Payment ID)	F0413	(CFIN) To get UKID against F0413 against F00022 Example: JDBReturn = JDB_InitUser( (HENV) lpBhvrCom->hEnv, &hUser, _J("X00022"), JDEDB_COMMIT_AUTO );
05A	B0800028	GetCacheParameters (Get Cache Parameters)		(CFND) For this example, JDB_InitUser() replaces JDB_InitBhvr(), so this is not related with outside transaction processing boundaries.
00	X0010	X0010GetNextNumber (X0010 - Get Next Number)	F0002, F00021, F0005	(CALLBSFN) cf., X00023 (F00023GetDistributedNextNumber_T) which is called by X0010 when you are using using distributed next numbers (i.e., MOBILE CLIENT). 1. JDB_FetchKeyedForUpdate() 2. JDB_UpdateCurrent()
00	B0000122	PostToF0902 (F0902 Update Account Balances)	F0902, F0911	(CALLBSFN) In general, this function can take longer time to commit which can be called from Procurement for example. So it is crucial to put this function outside transaction processing boundaries.
09	B0900621	ProcessGLAccountReconciliation (Process GL Account Reconciliation)	F03B11, F03B14, F0411, F0413, F0414, F0911, F0911R	(CFIN) This function initialize hUser for Auto and Maunal, the former is for fetch data and the latter is for update F0911/F0911R.
34	B3401580	MRPParallelAddSubsystmTriggerRec (MRP, Parallel Add Subsystem Trigger Records)	F3420, F4102, F986113	(CMFG) This function can be called in your running MRP (R3482/R3483) when Parallel Processing on. Since the data source of F986113 is server map data source (e.g., SVM910.F986113) it is necessary to call AUTO COMMIT
34	B3401590	MRPParallelManagingSemaphoreLoc (MRP,Parallel-Managing Semaphore Lock)	F3420	(CMFG) Same with B3401580
34A	B34A1320	CallOPWorkOrderBusinessService (Call OP Work Order Business Service)		(CMFG) For interface
34A	B34A1370	CallOPSalesOrderBusinessService (Call OP Sales Order Business Service)		(CMFG) For interface
40R	B40R0960	AddCUMRequiredDetailRecord (Add CUM Required Detail Record)	F40R121	CDMDSCH
40R	B40R0980	CheckDemandHeaderForAutoCreation (Check Demand Header Record For Auto Creation)	F40R10	CDMDSCH
00	X00022	GetNextUniqueKeyID (Get Next Unique Key ID)	F00022 F950411	(CALLBSFN) This function returns Unique Key ID against table specified from F00022. Update rotuine is same with X0010 which gets the last row and return row ID then update next UKID immediately based on Row ID retruned.
31	B3100170	SetNetChangeFlag (Set Net Change Flag)	F4102	(CMFGBASE) Refer to <Bug 13490757>: DATABASE RECORD LOCK UPDATING NET CHANGE FLAG MRPC ON PURCHASE ORDER AND PARTSLIST Refer to <Document 1050946.1> E1: 34: F4102.IBMRPC - NetChangeFlag (Flag - Net Change) FAQ
41	X41LOT	AssignLotNumber (F0002 Get Next Lot Number)	F0002	(COPBASE) When Lot Number (LOTN) has to be assigned based on 4 digits next number. <Bug 10925165>: PERFORMANCE PROBLEM/LOT ASSIGN - SAR: 8092288 - InitUser - Put user a separate transaction boundary than the hUser received with InitBhvr.
41	XF41021	GetItemLocationRecords (Get Item Location Records)	F41021, F4101, F41021WF, F0005	(COPBASE) Table F41021 is to be accessed frequently through Distribution and Manufacturing module for Inventory Transaction. So we implement AUTO COMMIT in getting data from F41021 to enhance performance and minimize blocking during Edit Line process in a certain MBF
41	XT4111Z1	F4111ClearDetailStack (F4111 Delete Work File)	F41021, F41021WF	(COPBASE) Only for internal function IXT4111Z1_UpdateF41021 which can insert data into F41021WF and update F41021 through Inventory Transaction via F4111EndDoc to avoid any possible locking and to have better performance. Applications affected: P4112, P4113, P4114, P4116, P4205, P4312, P43250, R42800, J43A0010, P31113, P31111, P41413 Refer to <Document 625445.1> E1: 40: Manual Rollback Process of Item Location (F41021) File
41	B4101370	F41021UpdatePrimaryLocation (F41021 Update Quantities in Primary Location)	F41021	(CINV) This function is to update quantity buckets from F41021 so this function put update of F41021 always outside Transaction Processing Boundaries in Inventory Transaction 1. JDB_SelectKeyedForUpdate() 2. JDB_FetchForUpdate()
41	B4101630	InventoryRealTimeWrapperFunction (Inventory Real Time Wrapper Function)		(CINV) RTE Interface not to put additional burden to EnterpriseOne
41	XF41021P	UpdateF41021PrimaryLocationQtyOT (F41021 Update Primary Location Quantities for OT orders)	F41021, F41021WF	(CINV) Subset of XF41021
42	B4200370	CommitSalesOrderToInventory (F41021 Update Order Commitment to Inventory)	F41021, F4102, F41021WF, F0005	(CDIST) To set the table F41021 at outside transaction processing during inventory commitment process in Sales
40	B4002060	CacheHandlerPrefX01 (Cache Handler Preference - Payment Terms)	F40070, F40071, F40072, F40073, F40300R, F40301, F40301R, F40302, F40302R, F40303, F40303R, F40304, F40304R, F40305, F40305R, F40306, F40307, F40308, F40308R, F40309, F40309R, F40310, F40310R, F40311, F40311R, F40312, F40312R, F40313, F40313R, F40314, F40314R, F40315, F40315R, F40316, F40316R, F40318, F40318R, F40320, F40329, F40330, F40331, F40332, F40333, F40334, F40338, F40339, F40341, F40341R, F40344, F40344R, F40345, F40345R, F40347, F40347R, F40349, F40349R, F40350, F40UI17, F42UI11	(CDIST) To prevent possible deadlock when Advanced Pricing is ON Refer to <Bug 10926015>: EXCLUDE PREFHISTORYCACHEHANDLE - SAR: 8101623
42B	B4205310	DeletePendingReleaseBlanketWF (Delete Pending Release Work File F42216 WF)	F42116, F42116WF	(CSALES) Since F42216WF is workfile we need to minimize possible deadlock and have better performance
42W	B4277701	CalcOrderScore (Calculate Order Score)	F4009, F4277750	(CDIST) Do not put in transaction processing for I4277701_Retrieve_Basic_Score which fetches data
42W	B4277720	ClearReleaseFromAllocationCache (Clear Release from Allocation Cache)	F4211, F49211	(CDIST) Set manual commit hUser for use in doing table updates for transaction processing but set auto commit hUser for fetching data from F4211/F49211
43	B4000930	UpdateF4102MRPNetChg (F4102 Update MRP Net Change)	F4102	(CDIST) Refer to <Bug 11007632>: ETO DEADLOCK BY PO RECEIPT - SAR: 8925493 Refer to <Document 1050946.1> E1: 34: F4102.IBMRPC - NetChangeFlag (Flag - Net Change) FAQ
46	B4600820	R46171ManageSubsysTriggerRecs (R46171 Manage Parallel Subsystem Trigger Records)	F4600, F986113	(CWARE) When yout set parallel processing for R46171 this function can be called. Since it accesses server map table F986113 (different data source), do not commit manual.
46	B4601450	F4625GetLabelNNRange (F4625 Get Label Serial Number Range)	F4625	(CWARE) To get F4625.NN1
46L	B46L0060	F46L011GetLPNextNumber (Get License Plate Next Number)	F46L011	(CWARE) To get next number from F46L011 1. JDB_FetchKeyedForUpdate() 2. JDB_UpdateCurrent()
46R	B46R0110	AddEPCSerialNumberRecord (Add EPC Serial Number Record)	F46R030	(CWARE) Refer to <Bug 10910470>: TP FOR R46151 AND R46474 - SAR: 7917794
49	B4900231	F49170GetLoadNextNumberLock (Get Load Next Number with Lock)	F49170, F4960	(CTRAN) 1. JDB_FetchKeyedForUpdate() against F49170 to get F49170.nnn001 2. Check whether above value is in use from F4960 3. Add 1 4. JDB_UpdateCurrent()

Miscellaneous BSFNs with AUTO COMMIT:

Product Code	Object Name	Function Name (Description)	Parent DLL
00	B8000002	DeleteAllRowsFromTable (Delete All Rows From Table)	CALLBSFN
00	B8000007	FreeInputOutputEnvHandles (Free Input Output Env Handles)	CALLBSFN
01RS	B01RS12L	OBAAutomaticAccountingInstF0012 (OBA Automatic Accounting Inst F0012)	CALLOBA
H79	B7900021	F98306AccessPO (F98306 Access Processing Option Translation Text)	CTRANS
H79	B7900022	F986101_ValidateOCM (F986101 ValidateOCM)	CTRANS
H79	B7900023	F79760_RDA_Update_F98760 (F79760 Report Design Aid Update F98760 BLOB)	CTRANS
H79	B7900040	ExtractFDASpec (Exract FDA Spec from BLOB)	CTRANS
H87	BCUSTSCO	CustomPriorityErrors (Custom Priority Errors)	CCUSTOM
32	B893201P	MaintainSubsystemTableF3296Drive (Maintain Subsystem Table F3296 Driven)	CTC
89	B98950A	CheckAndDeleteBadGDRecords (Check and delete GD records with no GF records)	CRUNTIME
89	B8932002	CfgManagingOfSemathoreLock (Config. Managing Of Semathore Lock)	CTC
89	B8932003	RecreateERP9ConfigTables (Recreate ERP9 Config. Tables)	CTC
89	B8932004	GetCfgTCAuditTableInfo (Get Cfg TC Audit Table Info)	CTC
90CA	B8900022	PerformX00022NNUpdate (Perform X00022 Next Numbering Update)	CALLBSFN
90CA	B89X0010	UpdateNextNumber (Update Next Numbering For CRM Migration to EOne 8.11)	CALLBSFN
90CA	B90CA892	MigrateFileToMediaObject (Function To Migrate File To Media Object)	CALLBSFN
90CE	B90CE033	IsVerity (Is Veirity)	CALLBSFN
H90	B9000100	FindWorkflowSystemFunctionsInER (Find Workflow System Functions In ER)	CWRKFLOW
H90	B98800N	CheckERChangeForF98811 (Check ER Change For F98811)	CWRKFLOW
H90	B99WFDEM	WFDemoComputeLineMargin (Workflow Demo Compute Line Margin)	CWRKFLOW
H91	B91400A	ConvertOneTableToXML (Convert Specs for One Table to XML)	CTOOL
H92	B9800010	AppendBsFnToArray (Append Business Function To Array)	CTOOL
H92	B9800260	GenerateCFromER (Create C Source and Header)	COBJLIB
H92	B98220C	BGIsF4802PopulatedForSection (BG Is F4802 Populated for Section)	COBJLIB
H95	B91501	FindDupSpecBegin (Load Duplicate Specs For Object)	CTOOL
H95	B91VLDT	ValidateERbasedOnObjectType (ValidateERbasedOnObjectType)	CTOOL
H95	B98223	ExtractAllowedActions (Extract Allowed Actions)	COBJLIB
H95	B98231B	CopyF98230 (Copy F98230 Information)	COBJLIB
H95	B9000AA	ChangeIndex (Change Index)	COBJLIB
H95	B98226	CopySCMPathConfig (Copy SCM Path Configuration by Pathcode)	COBJLIB
H95	B9500165	StripRTF (Strip RTF)	CCORE
H95	B0009502	DoesControlExist (Does Control Exist)	CALLBSFN
H96P	B9600470	AddObjectsToReadme (Add Objects To Readme)	CINSTALL
H96P	B9600490	AreAnyEnhancementsEnabled (Are Any Enhancements Enabled)	CINSTALL
H96U	B9800401	ConfigureDefaultODBCDataSource (ConfigureDefaultODBCDataSource)	CINSTALL
H96U	B9894004	ConfigurePackageManifest (Configure Package Manifest)	CINSTALL
98	B98MOCNV	ChangeDecimalKey (Change Decimal Key	CALLBSFN

Notes:

By putting update of a certain table outside transaction processing boundaries which may enable you to avoid deadlock at the cost of no rollback option
Some table (e.g., F41021) may have applications to enable you rollback in your hitting Commit Fail error either automatically or manually
The list above does not contain system level Auto Commit (codes which belongs to System Folder)
If any of the above tables show cause/victim of tables listed above, check for available ESUs

Representation in log:

AUTO COMMIT:

Entering JDB_InitUser with (AUTO commit mode)
Entering JDB_BeginTransaction (UserHandle 276F1008)
Exiting JDB_BeginTransaction with Success (UserHandle 276F1008)
Exiting JDB_InitUser with Success (UserHandle 276F1008)
Entering JDB_OpenTable(Table = F4102)

MANUAL COMMIT:

ghEnv is set as current hEnv
Entering JDB_InitUser with (MANUAL commit mode)
Entering JDB_BeginTransaction (UserHandle 2AC5E9D0)
Starting Commit Point No : 1 for Transaction ID : 1568115466_3312_360_398249464
Exiting JDB_BeginTransaction with Success (UserHandle 2AC5E9D0)
Exiting JDB_InitUser with Success (UserHandle 2AC5E9D0)

Representation in DB Connection:

ORACLE DBInitCon envr=0481ED38 conn=0D237450 den60202jems M (JDEUSR@gsc910) V112 Unicode=Y (srvrusers=1) 7
ORACLE DBInitCon envr=0481ED38 conn=0D237450 den60202jems A (JDEUSR@gsc910) V112 Unicode=Y (srvrusers=1) 7

0481ED38: envrHand
0D23745: connHand
den60202jems: szHost
M/A: cCommitType (if JDEDB_COMMIT_AUTO TRUE then 'A' else 'M')
JDEUSR: szUser
gsc910: szDB
V112: versionNum
UniCode=Y: cUnicode
1: numActive
7: dballConnectCount

Example of AUTO COMMIT in actual transaction

This scenario is specific to shipment confirmation for ST/OT orders and same issue can occur when there are more than 2 different modules involved for inventory transaction. Detailed information on MRPC (Net Change Flag) can be found in <Document 1050946.1> E1: 34: F4102.IBMRPC - NetChangeFlag (Flag - Net Change) FAQ. Note that callstack (which performanceworkbench.exe can generate) described below is a simplified routine. If possible try these steps:

Capture CallObject Kernel log (namely JDEDEBUG log)
Analyze the bugs using the Performance Workbench tool. Refer to <Document 747328.1> EnterpriseOne Performance Workbench - for details on using this tool.

Level	Object						Others
0	P4205/R47500 - Shipment Confirmation						Depends on E1 release the result from R47500 can be different because this issue can be specific to MANUAL COMMIT
1		ShipConfirmEndDoc					N4200790 (Shipment Confirmation End Document) When this function gets called with 'Transaction Processing' ON
2			F4211GetShipmentInfo				B4200920 (F4211 Get Shipment Info) This function is to get Sales Order information after shipment confirmation
3				F4311OrderIntegrity			B4201310 (F4311 Order Integrity) This function gets called through Table Trigger in F4211 to maintain integrity between ST and OT
4					F4311EndDoc (A)		XT4311Z1 (F4311 End Document) This function is to commit Purchase Order in maintaining integrity between ST/OT
5						SetNetChangeFlag (a)	B3100170 (F4102 Update Net Change Flag) This is to update F4102.MRPC against To B/P
2			UpdateF4102MRPNetChg (b)				B4000930 (F4102 UPdate MRP Net Change) This is to update F4102.MRPC against From B/P
3				F4312EndDoc (B)			XT4312Z1 (F43121 End Document) This function can be called when you activate In Transit Accounting through processing option of P4205
4					UpdateF4102MRPNetChg (c)		B4000930 (F4102 Update MRP Net Change) This is to update F4102.MRPC against To B/P

Notes:

Same thing can be explained when PO receipt has to issue inventory for manufacturing part for project order and so on
Both B3100170 and B4000930 never issue update statement when as-is f4102.mrpc = '1'

To fix this issue, apply the bugs below if applicable:

<BUG 11007632> - ETO DEADLOCK BY PO RECEIPT - SAR: 8925493 which sets update of F4102.mrpc for B4000930 - UpdateF4102MRPNetChg (F4102 Updata MRP Net Change)
<BUG 13490757> - DATABASE RECORD LOCK UPDATING NET CHANGE FLAG MRPC ON PURCHASE ORDER AND PARTSLIST
Since above routines are calling both SetNetChangeFlag and UpdateF4102MRPNetChg both bugs need applying

SUMMARY

It is important to mimize any loss in your daily business by understanding the following:

Transactions
Transaction Processing
Commits
Rollbacks
How to minimize issue