Error Occurs When Executing RTLUASIL.KSH Batch: 'ORA-12154: TNS:could not resolve the connect identifier specified' (Doc ID 2165966.1)

Last updated on JULY 28, 2016

Applies to:

Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

Users see the following error when running the Retail Insights RTLUASIL.KSH batch:


Steps to Recreate:

  1. Run RTLUASIL.KSH W_PRODUCT_DS

    (or) 
  1. Run RTLUASIL.KSH for any staging table with special enclosing characters in the data files. This will invoke PACK_SIL_RetailUniversalAdapterLoad.xml.
  2. The scenario loads the data with enclosing characters instead of ignoring them.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms