Bulk Import Though ERP Cloud Adapter Fails when FileName is not mapped (Doc ID 2266654.1)

Last updated on OCTOBER 24, 2018

Applies to:

Symptoms

Bulk import fails when FileName parameter is not mapped.

When attempting to import BAI2 format bank statement into ERP Cloud the following error occurs.

ERROR
-----------------------
### <ics_server1> <[ACTIVE] ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <005JlvO0PQwA9T3_RlP5id0001b00000d5>
#### <ics_server1> <[ACTIVE] ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <005JlvO0PQwA9T3_RlP5id0001b00000d5> Fault Code : env:Server
Fault String : JBO-FND:::FND_CMN_SYS_ERR: FND-2An application error occurred. Your help desk was notified.
Fault Details :

  FND:::FND_CMN_SYS_ERR
  JBO-FND:::FND_CMN_SYS_ERR: <MESSAGE><NUMBER>FND-2</NUMBER><TEXT>An application error occurred. Your help desk was notified.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>
  SEVERITY_ERROR
  
  oracle.apps.fnd.applcore.messages.ApplcoreException

 ]]>>

The logs contain following entries.

[2017-05-11T21:02:02.133+00:00] [ics_server1] [TRACE] [] [oracle.soa.adapter]
[tid: [ACTIVE].ExecuteThread: '30' for queue: 'weblogic.kernel.Default
(self-tuning)'] [userId: <anonymous>] [ecid:
005JoN_Z^rIA9T3_Rld9id0007aK0000H_,1:30274:13] [APP: Service Bus JCA
Transport Provider] [oracle.soa.tracking.FlowId: 2800023]
[oracle.soa.tracking.InstanceId: 40168] [oracle.soa.tracking.SCAEntityId:
30251] [composite_name: WriteAppend!2.0] [FlowId:
0000LjtKL5y2JR65vN5EiX1OmPFV00006k] [SRC_CLASS:
oracle.cloud.connector.impl.DefaultLoggingServiceImpl] [SRC_METHOD: logDebug]
integration payload===<nstrgmpr:importBulkData
xmlns:nsmpr5="http://xmlns.oracle.com/cloud/adapter/erp/CallERPCloud_REQUEST" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/CallERPCloud_REQUEST/types" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/"
xmlns:nstrgdfl="http://xmlns.oracle.com/cloud/adapter/osc/bulkdataimport/types"
xmlns:types="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"
xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0"
xmlns:tns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/">[[
<nstrgdfl:importBulkData>
<nsmpr7:ICSFile
xmlns:nsmpr7="http://xmlns.oracle.com/cloud/ics/file/v1/types">

<nsmpr7:FileReference>file:/BankStatement.zip@_@WSbxnzuJH+8PcvUXGmDVA32ETaAp7X
hDA9gl6JRJgqiFceGjVxy3PX2kY/JAl4Ho</nsmpr7:FileReference>
</nsmpr7:ICSFile>
</nstrgdfl:importBulkData>
</nstrgmpr:importBulkData>
.
]]

Changes

Cause

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