Commit Fail

[aweismille]

We have had a rash of commit fails that are NOT in P42210... why? The inventory does not show in F41021, but the inventory is commited to an order, and cannot be relieved from F4111. We have had to use SQL to get the inventory back into F41021.

 

[azklasse]

There are numerous posts in the Peoplesoft solution center regarding commit fails. Next numbers & a duplicate unique key id for F4111 is a large culprit as well as bad data in the item master, item cost, or item branch files. I have seen User Grid Overrides cause this to happen in earlier releases on OneWorld. If one User is the culprit, it could not hurt to delete all of their custom grid tabs & then reenter them.

One last idea ... if you have session time outs set, this could be the culprit. The commitments are done as a background job when you exit some of the inventory programs. If you process large sets of transactions (100+) then perhaps the process is not finished before the user gets signed out.

There is a commitment recovery program P42210 which does reset the quantities for you. There used to be a really good knowledge document about this program. I think there is a UDC table that has to be set to turn this on.

Heather

 

[Aarto]

Hi all!
The UDC to check is 00/AT
Here's an extract from the knowledge document

--- snip ---
The Item Location (F41021) table is purposely excluded from all transaction sets due to record locking concerns. If an application that uses Transaction Processing also updates the Item Location (F41021) there may be occasions when a Item Location (F41021) record is written or updated even though the rest of the transaction was rolled back. A Tools enhancement is planned for a future release to provide real time rollback. In B7332 and prior the Item Location (F41021) must be manually corrected. In Xe a new workfile F41021WF was added to capture commitment information in case of a transaction failure. The user can then rollback commitments via the F41021 Commitments Recovery (P42210) or F41021 Commitments Recovery (R42210) applications. This functionality can be enabled by switching UDC 00/AT ROLL special handling code form ‘0’ to ‘1’. Please refer to the related documents below for more information. PeopleSoft recommends the rollback process be enabled for all clients that use inventory applications.

--- snip ----

 

[Gergely_Pongracz]

Hi,
what you write about F41021 and transaction processing is quite interesting... It explains many things.
Do you happen to know how it is switched off? Some table-related definition or one by one in business funcion coding?
Regards:
Gergely Pongrácz
e-Best, Hungary