My Oracle Support Banner

SA_RULES_TOTAL_UPLOAD_JOB Falied with ORA-00923 Error for French Setup as Primary Language (Doc ID 3021563.1)

Last updated on MAY 10, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 to 24.0 [Release 24.0]
Information in this document applies to any platform.

Goal

SA_RULES_TOTAL_UPLOAD_JOB FAILED IN UAT WHEN SARTEXP_SA_ERROR_CODES.DAT HAD DATA

Using SA_RULES_TOTAL_EXTRACT_JOB POM job in Stage, sartexp_20240318170754.zip file was created. In this file, sartexp_sa_error_codes.dat had data. When this zip file was imported in UAT using SA_RULES_TOTAL_UPLOAD_JOB, it failed to upload.

Steps To Recreate:

1. Manually created an entry in SA_ERROR_CODES with single quote embedded in ERROR_DESC, REC_SOLUTION and SHORT_DESC for error_code='INVLD_SACT' and committed it.

2. Exported rules and totals using SA_RULES_TOTAL_EXTRACT_JOB.

3. sartexp_20240322193415.zip -> sartexp_sa_error_codes.dat shows:

MERGE INTO SA_ERROR_CODES SEC
USING (SELECT 'INVLD_SACT' AS ERROR_CODE,'Invalid''d Customer Attribute Type.' AS ERROR_DESC,'TR' AS TARGET_FORM,'C' AS TARGET_TAB,'Choose''s a Customer Attribute Type from the list.' AS REC_SOLUTION,'N' AS STORE_OVERRIDE_IND,'Y' AS HQ_OVERRIDE_IND,'Y' AS REQUIRED_IND,'Invalid'd customer attribute type' AS SHORT_DESC,'POP_UP_REPLACE' AS MASS_RES_POP_UP_TYPE,'SA_CUST_ATTRIB' AS ERROR_FIX_TABLE,'ATTRIB_TYPE' AS ERROR_FIX_COLUMN FROM DUAL) SEC2
ON (SEC.ERROR_CODE = SEC2.ERROR_CODE)
WHEN NOT MATCHED THEN
INSERT (ERROR_CODE,
ERROR_DESC,
TARGET_FORM,
TARGET_TAB,
REC_SOLUTION,
STORE_OVERRIDE_IND,
HQ_OVERRIDE_IND,
REQUIRED_IND,
SHORT_DESC,
MASS_RES_POP_UP_TYPE,
ERROR_FIX_TABLE,
ERROR_FIX_COLUMN)
VALUES (SEC2.ERROR_CODE,
SEC2.ERROR_DESC,
SEC2.TARGET_FORM,
SEC2.TARGET_TAB,
SEC2.REC_SOLUTION,
SEC2.STORE_OVERRIDE_IND,
SEC2.HQ_OVERRIDE_IND,
SEC2.REQUIRED_IND,
SEC2.SHORT_DESC,
SEC2.MASS_RES_POP_UP_TYPE,
SEC2.ERROR_FIX_TABLE,
SEC2.ERROR_FIX_COLUMN);

4. Notice that SA_RULES_TOTAL_EXTRACT_JOB is not escaping single quotes correctly for SHORT_DESC - 'Invalid'd customer attribute type' AS SHORT_DESC.

5. When you run this SQL, it fails with below error:

Error at Command Line : 2 Column : 293
Error report -
SQL Error: ORA-00923: FROM keyword not found where expected
00923. 00000 - "FROM keyword not found where expected"
*Cause:
*Action:

 

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!


In this Document
Goal
Solution
References


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