APP-FND-01564 INCTCW Failed Due To ORA-03113: end-of-file on communication channel For Sales Order Issue with IB Tracked End Assembly Item (Doc ID 2905401.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Symptoms

While processing Sales Order Issue transaction in Inventory, observe that the Process Transactions Interface Worker program (INCTCW) fails with the following error details:

--ERROR--
INCTCW: Inventory transaction worker
APP-FND-01564: ORACLE error 3113 in inctcw
Cause: inctcw failed due to ORA-03113: end-of-file on communication channel

The SQL statement being executed at the time of the error was: declare l_retstat varchar2 ( 3 ) ;
l_msg_data varchar2 ( 244 ) ; l_msg and was executed from the file 16075364/inv/lib/inctcm.pc.

ORACLE error 3114 in AFPRSR-Resubmit_Time
Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE

Other conditions/observations during the occurrence of this issue are:

• The Data Base PGA memory (monitoring by the DBA) is depleted while the Process Transactions Interface program was running.
• There are items in the sales order which are Manufactured Items (Assemblies).
• These assembly items are setup to be Installed Base tracked (serial instances of the assembly are recorded in Installed Base module).
• The profile option CSI: Explode BOM is set to Yes.
  Please see details of this profile option in the Note - How Installed Base Builds Relationships for ATO, PTO and Standard BOM Items(Doc ID 728009.1)

The following query may help you find items which are assemblies and also are IB Trackable. Unfortunately, there is no single query to validate for bills of material loops.

Cause

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