My Oracle Support Banner

Unable to Process RUN_SQL or BEGIN_RUN_SQL Commands via MNT Files in XOCS as Function Has Been Disabled (Doc ID 2976728.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle Retail Xstore Office Cloud Service - Version 22.0 to NA [Release 22.0 to No Release]
Information in this document applies to any platform.

Symptoms

REPORTED ISSUE
-------------------------------------------------------
When attempting to process Voucher information via DataLoader in Xstore Office Cloud Service, the "RUN_SQL" and "BEGIN_RUN_SQL" commands present in .MNT files are failing to process due to the functionality being "Disabled".

ERROR CODES/MESSAGES
-------------------------------------------------------
The RUN_SQL action has been disabled for DataLoader
The BEGIN_RUN_SQL action has been disabled for DataLoader

REPLICATION STEPS
-------------------------------------------------------
Steps used to schedule deployment of the .MNT files via Xadmin (these files include the above commands)

a. In Xadmin navigate to Deployment > File Upload > and here upload your file
b. After that schedule deployment by navigating to Home > File Upload > Schedule Deployment where you add:
i. Deployment Name: 00_IT_105410__20230816_051894 Upload 2023-09-04 22:05:48 (it is prepopulated)
ii. Organization Node: *:*
iii. Download Priority: End of Day
c. Click OK
d. In “Review Deployment Schedule” click “Deploy”

BUSINESS IMPACT
-------------------------------------------------------
This impacts the business by not performing the required functionality that DataLoader provides to the operator.

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!


In this Document
Symptoms
Cause
Solution


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