Transaction Processing jde.docx
- 文档编号:26448110
- 上传时间:2023-06-19
- 格式:DOCX
- 页数:12
- 大小:71.05KB
Transaction Processing jde.docx
《Transaction Processing jde.docx》由会员分享,可在线阅读,更多相关《Transaction Processing jde.docx(12页珍藏版)》请在冰豆网上搜索。
TransactionProcessingjde
SolutionID:
200782187
DateLastRevised:
07/13/2007
Title:
TransactionProcessinginEnterpriseOneDistributionApplications
Abstract:
ThepurposeofthisdocumentistoprovideanoverviewofTransactionProcessingandhelpdiagnoseTransactionerrorsinDistributionapplicationswhereTransactionProcessingisenabled. Thesamemethodologycanalsoapplytoanynon-distributionapplicationswhereTransactionProcessingisenabled.
TableofContents
Introduction
DistributionApplicationsWhereTransactionProcessingisEnabled
KeyTerms
Transaction
TransactionBoundary
Commit
Rollback
Overview
TransactionProcessing
TransactionFailureErrors
GraphicalOverview
AdditionalConsiderations
WebClientsinXeandERP8
F41021Exclusion
OCMMappings
Performance
KnownIssuesandResolutions
JDENETTimeoutSetting
AddingAdditionalLinesinShipmentConfirmation(P4205)
RandomTransactionErrorsWhenProcessingLogicontheServer
RandomTransactionErrorsinDistributionApplications
WebClientTransactionErrorswhenProcessingLargeTransactions
DiagnosingTransactionErrors
TestingTransactionProcessingEnabledApplications
Introduction
ThepurposeofthisdocumentistoprovideanoverviewofTransactionProcessingandhelpdiagnoseTransactionerrorsinDistributionapplicationswhereTransactionProcessingisenabled. Thesamemethodologycanalsoapplytoanynon-distributionapplicationswhereTransactionProcessingisenabled.ThispaperassumesthereaderhasgeneralknowledgeofOracleEnterpriseOneCNCarchitectureandRDBMS.
BacktoTop
DistributionApplicationsWhereTransactionProcessingisEnabled
NA=NotAvailable
N=NotEnabled
Y=Enabled
Application
Description
Xe
ERP8
8.9
8.10
8.11
8.11SP1
8.12
P4112
InventoryIssues
Y
Y
Y
Y
Y
Y
Y
P4113
InventoryTransfers
Y
Y
Y
Y
Y
Y
Y
P4114
InventoryAdjustments
Y
Y
Y
Y
Y
Y
Y
P4116
InventoryReclassifications
Y
Y
Y
Y
Y
Y
Y
P4205
ShipmentConfirmation
Y
Y
Y
Y
Y
Y
Y
P4210
SalesOrderEntry
N
N
N
Y
Y
Y
Y
P42101
SalesOrderEntry
NA
NA
NA
NA
Y
Y
Y
P42117
BackorderRelease
Y
Y
Y
Y
Y
Y
Y
P4310
PurchaseOrderEntry
Y
Y
Y
Y
Y
Y
Y
P4312
PurchaseOrderReceipts
Y
Y
Y
Y
Y
Y
Y
P4314
VoucherMatch
Y
Y
Y
Y
Y
Y
Y
P43250
ReceiptRouting
N
N
Y
Y
Y
Y
Y
P43291
LandedCosts
Y
Y
Y
Y
Y
Y
Y
BacktoTop
KeyTerms
Transaction
AtransactionisalogicalunitofworkthatiscomprisedofoneormoreSQLstatementsandperformedonthedatabasetocompleteacommontaskandmaintaindataconsistency.Transactionstatementsarecloselyrelatedandperforminterdependentactions.Eachstatementperformspartofthetask,butallarerequiredforthecompletetask.
TransactionBoundary
Datainterdependenceisdefinedbyatransactionboundary.Atransactionboundaryencompassesallofthedataelementsthatcompriseatransaction.Atransactionboundarymightincludeonlydataelementsonasingleform,multipleforms,oracalltotheMBFEndDoc.
Commit
Acommitisanexplicitcommandtothedatabasetopermanentlystoretheresultsofatransaction.Thisisthesuccessfulendofatransaction.
Rollback
Arollbackisanexplicitcommandtothedatabasetocanceltheresultsofatransaction.Anyfailureofaninsert,update,ordeletewithinatransactionboundarywillcauseallrecordactivitywithinthattransactiontorollback.Ifnofailureshaveoccurredattheendofthetransaction,acommitisdoneandtherecordsbecomeavailabletootherprocesses.
BacktoTop
Overview
TransactionProcessing
TransactionProcessingisaJDEBasemiddlewarefunctionthatensuresrelateddataisaddedtoordeletedfromthedatabasesimultaneously,thuspreservingdataintegrityinanapplication.TheapplicationcanthenrequestthedatabasemanagementsystemtobufferthedatabaseoperationsuntiltheapplicationexecutesaspecificcommandviaJDEBaseAPI’s toperformtheupdatesrequestedwithinthetransaction.Databaseoperationsthatarenotpartofthetransactionupdatethedatabaseimmediately.InTransactionProcessingdataisnotwrittentothedatabaseuntilacommitcommandisissued.Whenthishappensdataispermanentlywrittentothedatabase.
Forexample,ifatransactioncomprisesdatabaseoperationstoupdatetwodatabasetables,eitherallupdateswillbemadetobothtables,ornoupdateswillbemadetoeithertable.Thisguaranteesthatthedataremainsinaconsistentstateandtheintegrityofthedataismaintained.
IfTransactionProcessingisoninanapplication,updatedrecordscannotbeseenuntilanupdatehasbeencommittedtothedatabase.Onlyprocesseswithinthattransactioncanaccessrecordsinthetransactionsetuntilthetransactioniscomplete.
Note:
ForfurtherinformationonTransactionProcessingpleaseseetheToolsDevelopmentVolume1manualforyourrespectiverelease.
TransactionFailureErrors
TransactionerrorswillonlyoccurinapplicationswhereTransactionProcessingisinitiated.ItisimportanttorememberthataTransactionerrorisnottheactualproblembutisthesymptomofadatabaseorenvironmentalproblem.JDEBaseinconjunctionwiththeRuntimeEngineissuestheTransactionerror.
WindowsClient
WebClient
Firsterror:
Seconderror:
GraphicalOverview
ThefollowingdiagramisagraphicaloverviewofTransactionProcessing.TheInventoryAdjustments(P4114)applicationisusedfortheexample.
BacktoTop
AdditionalConsiderations
WebClientsinXeandERP8
WebClientsinXeandERP8havelimitedsupportofTransactionProcessing.NoTransactionerrorwillbeissuedbytheapplication;thereforetheuserwillnotknowthatonehasoccurred.
ToactivateTransactionProcessingforWebclientsthefollowingchangesmustbemade.
JAS.ini:
[TRANSACTIONS]
TransactionLogging=TRUE
TransactionLog=C:
\JDEdwards\JAS81\EA_JDEdwards_1.ear\webclient.war\logs\Transactions.log
ReapInterval=5
MaxAge=10
HTMLClient.ini:
**Uncommentthefollowinglineandchangetotrue**
TransactionProcessingEnabled=TRUE
ItemLocation(F41021)Exclusion
TheItemLocation(F41021)tableispurposelyexcludedfromalltransactionsetsduetorecordlockingconcerns.IfanapplicationthatusesTransactionProcessingalsoupdatestheItemLocation(F41021)theremaybeoccasionswhenanItemLocation(F41021)recordiswrittenorupdatedeventhoughtherestofthetransactionwasrolledback. PleaseseeSolutionID200782095forfurtherdetails.
OCMMappings
WhenprocessinglogicontheserverinaWindowsthinclient,makesureOCMmappingsarecorrect.Anexampleofthiswouldbea“W”environment.BusinessfunctionssharedependenciessoOraclerecommendedmappingsshouldbefollowedatalltimes.Deviationfromtheseisnotsupported.
Performance
TherearesomeperformanceissuestoconsiderwhenusingapplicationsthatareTransactionProcessingenabled.SinceallrecordswithintheTransactionProcessingboundaryarelockeduntiltheentireprocesscompletes,otherapplicationsmayhavetowaituntilaneededrecordisfreed.Thisisnotanissuefornewrecordsthatarebeinginsertedintothedatabasebutisanissuewithrecordsthatarebeingupdated.TaketheAdjustments(P4114)forexampleandrefertothegraphicaloverviewabove.NoticethattheItemBranch(F4102)andItemCost(F4105)recordswillbeupdated.Ifauserweretoperforma900-lineadjustmentusingdifferentitemsforeveryline,thenforabriefperiodoftime900ItemBranch(F4102)andItemCost(F4105)recordswouldbelocked.Ifthesystemwasslowandittooksometimetocompletetheprocess,otherapplicationstryingtoaccessthesameItemBranch(F4102)andItemCost(F4105)recordswouldhavetowaituntiltherecordswerefreed.Theotherapplicationmayseemtoslowdownorevenstopforashortperiodoftime.
Herearesometipstominimizeperformanceissues.
1.TrytolimitthenumberoflargetransactionsinTransactionProcessingenabledapplications.
2.IfAverageCostisnotbeingused,disableAverageCostUpdatebyremovingTransactionProcessingenabledapplicationsfromUDCtable40/AV.ThiswilllimittheupdatestotheItemCost(F4105)table.
3. PleasenotethatmanyapplicationsupdatetheItemBranch(F4102)tablewithMRPauditinginformation.AvoiddoinglargeAdjustments,Issues,orTransfersofheavilyuseditemsduringpeakhours.Thiswilllimitlockingof ItemBranch(F4102)records.
BacktoTop
KnownIssuesandResolutions
JDENETTimeoutSetting
Whenprocessinglogicontheserver(WTSenvironment)itisimportantthisvalueissetcorrectly.Thedefaultvalueis60seconds.Adjustthistimeasnecessarydependingonbusinessprocess.Thisisthetime,listedinsecondsforclientstoattempttoconnecttoservers.ItalsodesignatesthetimeaclientwillwaittoreceiveaJDENetmessagebackfromtheserver.ForexampleauserlogsintoWPD7333andgoesintoShipConfirm(P4205)anorderwithseveralhundredlines.UserclicksOKbuttonandtheShipConfirmMBFEndDociscalled.JDENetsendsamessagetotheservertoprocesslogiconakernel.Duetotheamountofdataontheorderandothervariablesitcouldtakeafewminutestoprocess.Ifthevalueissetto60,whichisthedefault,theprocesscouldtimeoutbeforecompletingcausingaTransactionerror.SeeJDE.logerrorexamplebelow.
JDE.INI:
[NETWORKQUEUESETTINGS]
UBEQueue=QB7333
UBEPriority=5
PrintImmediate=FALSE
SaveOutput=TRUE
InstallSpecs=Y
JDENETTimeout=120
AddingAdditionalLinesinShipmentConfirmation(P4205)
WhenrunningShipmentConfirmationANDtheAdditionalLinesItemsscreenforShipmentConfirmation(P4205),arecordlockingissuecanoccur.Please
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Transaction Processing jde