previous

OBI EXTERNAL FILE DIRECTORY Application Setting

Group.  OBI

Type.  Setting

Application.

OBI

PMS

S&C

ORS

Description. This is the Oracle Directory which specifies the path where files for External import will be stored (related to external file import from the POS to Opera).

Internal Name. OBI_EXT_FILE_DIRECTORY

Property Determination.

Activation / Inactivation Rules. 

 

Available Values.

The options listed are user-defined folders in the Shared Drive where the POS data files will be saved for import. This can be any name or structure. To set up the path, create a base path and directory. For example:

  • Base path = \\BISERVER\Transfer\OBI\POS. This will be the folder where all imported files will be stored. Please note that the Oracle Database needs to have permission to read, write to this Shared Folder.
  • Add this directory to your DBA directories in Opera. Go to Utilities> Opera SQL >. Run the below code. Replace \\biserver\transfer\OBI\POS.with your path.

    DECLARE

    v VARCHAR2(200);

    BEGIN

    v := Obi_Ext_p.Create_Ext_Directory('EXT_FILE_DIR', '\\BISERVER\Transfer\OBI\POS');

    END;

  • Verify that the Oracle Directory Object 'EXT_FILE_DIR' is created by running the Query below:

    select * from dba_directories

     

OWNER

DIRECTORY NAME

DIRECTORY PATH

SYS

EXT_FILE_DIR

\\BISERVER\transfer\OBI\POS

 

Add On Licenses/Country Specifics.

 

Other Application Settings.

<none>

Affected Areas

Menus / Screens / Fields.

OBI>Answers>POS Subject Area

Reports & Report Forms.

<none>

Permissions.

<none>

Notes.