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 laterOracle 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! |