My Oracle Support Banner

RETL Scripts for AIP - Rmse_Aip_Store_Cur_Inventory.Ksh and Rmse_Aip_Store_Cur_Inventory.Ksh Fail to Execute Successfully (Doc ID 2434769.1)

Last updated on AUGUST 17, 2018

Applies to:

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

Symptoms

RETL scripts for AIP - rmse_aip_store_cur_inventory.ksh and rmse_aip_store_cur_inventory.ksh fail with numerous errors:


Batch name - rmse_aip_store_cur_inventory.ksh
Command Line:- ./rmse_aip_store_cur_inventory.ksh F
Error:

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Message:   ORA-00933: SQL command not properly ended
XOPEN SQL State:  42000
Database Vendor Driver/Source Error Code: 933

Aborting ...


Batch name - rmse_aip_wh_cur_inventory.ksh
Command Line:- ./rmse_aip_wh_cur_inventory.ksh F
Error:

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
Message:   ORA-00936: missing expression
XOPEN SQL State:  42000
Database Vendor Driver/Source Error Code: 936

Aborting ...

Cause

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.