My Oracle Support Banner

W_RTL_PROMO_IT_LC_DS.dat File Is Not Loading to the Staging Table (Doc ID 2998374.1)

Last updated on JANUARY 18, 2024

Applies to:

Oracle Retail Demand Forecasting Cloud Service - Version 23.2 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

After loading a W_RTL_PROMO_IT_LC_DS.dat file in RAP, records are not inserted to the staging table but no errors or rejections are displayed.

The W_RTL_PROMO_IT_LC_DS.dat.ctx is:

#TABLE#W_RTL_PROMO_IT_LC_DS#
#DELIMITER#,#
#DATEFORMAT#YYYYMMDD#
#REJECTLIMIT#0#
#RECORDDELIMITER#\n#
#IGNOREBLANKLINES#false#
#SKIPHEADERS#1#
#TRIMSPACES#rtrim#
#TRUNCATECOL#false#
#COLUMNLIST#
PROMO_ID
OFFER_ID
PROD_NUM
ORG_NUM
ORG_LEVEL
REWARD_ID
COND_ID
OFFER_TYPE_ID
MERCH_LEVEL
MERCH_ID
MERCH_CLASS
MERCH_SUBCLASS
DIFF_ID
SUPPLIER_SITE
BRAND
REWARD_TYPE
REWARD_AMOUNT
DATASOURCE_NUM_ID
INTEGRATION_ID
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.