E1: 42: 47: All Sales Order Entry Programs Fail for One Address Book Number (AN8) with Asynchronous Error and Database Write Fails /Transaction Cannot Be Committed Error - P4210/P42101/R47011 (Doc ID 2909873.1)

Last updated on NOVEMBER 22, 2022

Applies to:

Symptoms

All Sales Order (SO) Entry programs fail and are unable to create, edit/update existing/new orders (Interactive Sales Order Order Entry and EDI Inbound 850 - P4210/P42101/R47011). For the P4210/P42101, the order looks like it saves but it cannot be found upon re-inquiry. For the R47011, the programs are unable to finish.

Errors
P4210/ P42101 - Sales Order Entry

• Asynchronous error
  • Transaction Cannot be Committed - Database write fails the order looks like it saves but it cannot be found upon re-inquiry.
  • The jddebug.log shows: P4210 Entry ending F4211FSEndDoc Asynchronous BSFN
• R47011 - EDI Inbound 850 does not complete and fails.
  • The logs show: The database is failing to process an update. The information would be similar to the below excerpt. The program fails on the Customer Master table (F03012) and address number (AN8) = 51xxxxxx.

UPDATE PRODDTA.F03012 SET AIACL=3000000.000000,AIDFIJ=116092,AIDLIJ=122315,AIDLP=122314,AIAD=0.000000,AIAFCP=0.000000,AIAFCY=0.000000,AIASTY=540207013.000000,AISPYE=1121230799.000000,AIAHB=0.000000,AIALP=-104713.000000,AIABAM=0.000000,AIABA1=0.000000,AIAPRC=12613712.000000,AIURAT=0.000000,AIURDT=0,AIAMCR=0.000000,AIUSER='JDEJZ',AIPID='B0100024',AIUPMJ=122319,AIUPMT=140157.000000,AIJOBN='Kxxxxxxx' WHERE (AIAN8 = 51xxxxxx.000000 AND AICO = '00000' )

Steps to Duplicate
-----------------------
1. Create or update a sales order from P4210, P42101 or create from R47011.
2. The orders end with Asynchronous error and database write fails and receive a Transaction Cannot be committed error.
3. The R47011 is unable to complete.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.