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 |