eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Lookup Type: XLA_INITIAL_BALANCE_MSG

Product:	XLA - Subledger Accounting
Meaning:	Error messages for import of initial balances program
Description:	This categorizes the messages used to report errors/warnings encountered in defining the control balance initial balances

Quick Codes

Code	Meaning	Description
IB001	Application_id is NULL	Application_id is NULL
IB002	Application_id cannot have Control Account	Application_id cannot have Control Account
IB003	Ledger_id is NULL	Ledger_id is NULL
IB004	Invalid ledger_id	Ledger_id should belong to either Primary Ledger OR Secondary / ALC Ledgers with Subledger level conversion
IB005	Code_combination_id is NULL	Code_combination_id is NULL
IB006	Invalid Account	Code_combination_id has different Chart of Accounts in gl_code_combinations and gl_ledgers
IB007	Code_combination_id is not a Control Account	Code_combination_id is not a Control Account
IB008	Party_type_code should be either S or C	Party_type_code should be either S or C
IB009	Invalid party_type_code	If party_type_code = S then party_id is not in ap_suppliers or if party_type_code = C then party_id is not in hz_cust_accounts
IB010	Invalid Party Site Id	The party_site_id is not in ap_supplier_sites_all or not in join of hz_cust_site_uses_all and hz_cust_accounts
IB011	Period_name is NULL	Period_name is NULL
IB012	Invalid Period Name	Period_name is not earlier than the minimum period_name for the combination of application_id, ledger_id, code_combination_id, party_type_code, party_id and party_site_id
IB013	Both init_balance_dr and init_balance_cr cannot be NULL	Both init_balance_dr and init_balance_cr cannot be NULL
IB014	Init_balance_dr or init_balance_cr cannot be negative value	Init_balance_dr or init_balance_cr cannot be negative value
IB015	Message_codes should be NULL	Message_codes should be NULL
IB016	Existing_init_balance_cr should be NULL	Existing_init_balance_cr should be NULL
IB017	Existing_init_balance_dr should be NULL	Existing_init_balance_dr should be NULL
IB018	Existing_effective_period_num should be NULL	Existing_effective_period_num should be NULL
IB019	Request_id should be NULL	Request_id should be NULL
IB020	Program_application_id should be NULL	Program_application_id should be NULL
IB021	Program_id should be NULL	Program_id should be NULL
IB022	There should not be multiple rows for same Party Set	There should not be multiple rows in interface table for same combination of application_id, ledger_id, code_combination_id, party_type_code, party_id and party_site_id
IB023	Debit & Credit values for the initial balance cannot be > 0	Both debit and credit values for the initial balance cannot be provided. Please provide either net debit or net credit value for the initial balance
IB024	interface table data should belong to First Period	The data uploaded into the interface table should be for the period(s) for which the FIRST_PERIOD flag is "Yes"
IB025	Intial balances upload Period should be Closed	The period closing status of the Period for which the intial balances are uploaded should be Closed
IB026	Period_name cannot be adjustment period	Period for which the intial balances are uploaded should not be adjustment period
IB027	Initialize Account Set Min(period) for First Period	You cannot initialize balance for this period. You can only initialize the balance for the period that has value "Yes" in the FIRST_PERIOD column of the XLA_CONTROL_BALANCES table