SQL*Loader- BAI2 Has Errors: SQL*Loader-552: Insufficient Privilege To Open File Error,SQL*Loader-509: System error: Permission denied (Doc ID 1667942.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cash Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Bank Statement Load and Import

When attempting to submit the Bank Statement Loader
the following error occurs.

ERROR
-----------------------
SQL*Loader-500: Unable to open file (/var/tmp/May.txt)
SQL*Loader-552: insufficient privilege to open file
SQL*Loader-509: System error: Permission denied
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Submit Requests window.

2. Submit the Bank Statement Loader.



Cause

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 hundreds of Community platforms