Lookup for INI.txt File

You must define a lookup for the ini.txt file from Open Format.

To define ORA_JEIL_INI_DATA_FILE_INFO, follow these steps:

1. Navigate to Setup and Maintenance and select the Manage Standard Lookups.
2. Define these values:
   • Lookup Type: ORA_JEIL_INI_DATA_FILE_INFO
   • Meaning: Open Format for Israel Initialization Data File Information.
   • Description: Indicates the general ledger journal categories that you’re going to exclude them from being exported in the Open Format audit report. Indicates additional information used by the Open Format for Israel: Initialization Data File process.
   • Module: Reporting for Israel.
   • Lookup Configuration:
     • Level: User
     • REST Access Secured: Secure

To generate the right INI.txt file to get it validated, follow these steps:

1. Navigate to Setup and Maintenance and select the Manage Standard Lookups.
2. Search for and select the ORA_JEIL_INI_DATA_FILE_INFO lookup.
3. Define these lookup codes:

Lookup Code/Display Sequence	Enabled	Meaning	Tag	Reference Field in INI file	Example Values
1	Yes	Software Registration Number	Enter the value to be printed in file	1006	34002
2	Yes	software name	Enter the value to be printed in file	1007	Oracle ERP Cloud
3	Yes	software version	Enter the value to be printed in file	1008	R13
4	Yes	software manufacture id	Enter the value to be printed in file	1009	512200502
5	Yes	software manufacture name	Enter the value to be printed in file	1010	Oracle Corporation
6	Yes	software_type	Enter the value to be printed in file	1011	2
7	Yes	Type of software	Enter the value to be printed in file	1013	xxxxxxxxx
8	Yes	Account Type	Enter the value to be printed in file	1014	1
10	Yes	Language Code	Enter the value to be printed in file	1028	IL
11	Yes	Character set	Enter the value to be printed in file	1029	UTF-8
12	Yes	Compress Program	Enter the value to be printed in file	1030	zip
14	Yes	Branch information	Enter the value to be printed in file	1034	0

Processing happens based on the combination of a ledger and the related legal entity for a specific date range, which may span within a financial year or across financial years.

This table lists the parameters for the ORA_JEIL_INI_DATA_FILE_INFO lookup:

Parameter Name	Description	Type	Default Value
Ledger	The list should be restricted to ledgers (primary, secondary or reporting) based on the security roles and privileges for the user. Also, the list will only include ledgers with ILS currency. To derive the list of values, VVO is used.	LOV	If the user has access to only one ledger, it is defaulted. If user has access to multiple ledgers - the first one in ascending order is defaulted.
Legal Entity	The list should be restricted to legal entities based on the security roles and privileges for the user and based on their association with the ledger chosen. To derive the list of values, VVO is used. The LOV when opened should show one column while displaying search result – legal entity.	LOV	If the user has access to only one legal entity, it is defaulted. If user has access to multiple legal entities - the first one in ascending order is defaulted.
Start Date	The date from which the processing for the ‘Open Format for Israel: Files Generation’ begins. The start date should always be equal to or smaller than the end date. The date range can span either within or across financial years. Format used should be as per user preference set.	Calendar LOV	First day of the last closed period before the current system date’s month. If it is the first open ledger period, then use the first day of the latest open period.
End Date	The date on which the processing for the ‘Open Format for Israel: Files Generation’ ends. The end date should always be equal to or greater than the start date. The date range can span either within or across financial years. Format used should be as per user preference set.	Calendar LOV	Last day of the month before the current system date’s month. If it is the first open ledger period, then use the last day of the latest open period.

Note: For all above parameters, Required field is set to Yes.

If the default for any parameter is changed, then all the dependent parameters should also see change in values.

The LOV for the Ledgers includes apart from the column with the ledger name, the primary ledger associated with the depicted ledger and the currency of the primary ledger.