Modifying the initialization file and installation parameters for the GL process trace log

After installing Databridge (Oracle), you must modify an Oracle initialization file to generate a trace log for the GL feed in the R5GLPROCTRACE table.

Note: You need to modify the initialization file only if installing the Journal Post Transaction.

If you are installing Databridge (SQL Server), you only need to modify the $BTRACE and $LTRCDIR installation parameters as documented in step 8. You do not need to complete any of the remaining steps in this section.

To modify the initialization file and installation parameters for the GL Process Trace Log:

Locate the INITxxx.ORA file, where 'xxx' is the Oracle SID for the Infor EAM instance being used. This file can usually be found in the 'DBS' directory where Oracle is installed, e.g., …\DBS\INITxxx.ORA.

Note: The INITxxx.ORA file might be located in other directories in addition to the directory in the example above. Search the entire Oracle directory structure to verify that other occurrences of the INITxxx.ORA file do not exist.
Open the file in a text editor.
Locate the UTL_FILE_DIR parameter and enter the trace directory path, e.g., C\:TEMP.
Save and exit the file.
Shutdown and restart the database server to implement the changes.
Open Infor EAM.
Select Administration > Security > Install Parameters.

Specify this information:

Install Parameter: Select the $BTRACE and $LRTCDIR installation parameters, and then define them according to the following examples and descriptions:

Parameter	Value	Description
$BTRACE	Y/N	Indicates whether the trace flag is turned on Y or YES = Yes; N or NO = No For the GLFEED trace, you must set $BTRACE to YES and enter the file location specified for the $LTRCDIR parameter. The file location specified for $LTRCDIR must be the file location specified for the UTL_FILE_DIR parameter in the INIT.ORA file for the database instance. You must enter the database name within the INIT.ORA file. For example, if the database name is D77, you must name the INIT.ORA file as INITD77.ORA. Note: If the directory path is not located in the INIT.ORA file, you must add the directory path to INIT.ORA. Then you must shutdown and restart the database to enable the directory path.
$LTRCDIR	C:\TEMP:\ or C:\ORACLE\PLSQL\TEMP\	Identifies the trace directory if Infor EAM is installed locally

Click Save Record.