Checking EDI File Folders

This page will document how to check EDI file production and other related topics. CTMS will be used as an example, but this is relevant to any Oracle system.

Requirements

• Access to the systems
• Access to the database
• TNS Names
• FileZilla or other FTP client.
• VPN.
• For some systems, access to the jump box.

Process

Check the EDI for the destination folder.

• For EDI processes, check ctms:EDI Maintenance, which will tell you the destination folder.
• For BI/MIS, check the table mis_extract_header for details see BI Data Extract.

Get the details of the Oracle server from your TNS Names, usually located in C:\oracle\app\product\11.2.0\client_1\network\admin\tnsnames.ora. Note that version and client name can vary, depending on how it is installed on your machine.

In FileZilla:

• Create a new connection in connection manager.
• Set a meaningful name - suggested using the database name i.e. STSTPRD.
• Set the IP address to the IP address of the TNS Name
• Set the username and password to the oracle or your provided username and password. Consult your team for details.
• Connect.
• In the right explorer, paste in the destination directory.
• This will show the produced files.