You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to open Inquire on Detail Balances

in General Ledger & Intercompany

Hello,
We are currently implementing Oracle Fusion for a client and are facing an issue in General Accounting. Users are unable to open the Inquire on Detail Balances page. When accessing this task, the page fails to load and an application error is displayed.

Steps to reproduce:
1. Navigate to General Accounting > Period Close
2. From the Tasks panel > Inquire on Detail Balances

The following error message is encountered by the users:
• ADFC-10001: cannot instantiate class 'oracle.apps.financials.generalLedger.inquiry.balances.ui.bean.EssDebBalancesBean'

• JBO-27122: SQL error during statement preparation. Statement:SELECT AccountGroupsEO.ACCOUNT_GROUP_ID, AccountGroupsEO.USER_GUID, AccountGroupsEO.ACCOUNT_GROUP_NAME, AccountGroupsEO.ACCESS_SET_ID, AccountGroupsEO.DESCRIPTION, AccountGroupsEO.LAST_UPDATE_DATE, AccountGroupsEO.LAST_UPDATED_BY, AccountGroupsEO.CREATION_DATE, AccountGroupsEO.CREATED_BY, AccountGroupsEO.LAST_UPDATE_LOGIN, AccountGroupsEO.DEFAULT_FLAG, AccountGroupsEO.COMPARISON_OPTION_CODE, AccountGroupsEO.SCENARIO, AccountGroupsEO.OBJECT_VERSION_NUMBER, AccountGroupsEO.TIME_OPTION_CODE, AccountGroupsEO.CHART_OF_ACCOUNTS_ID, AccountGroupsEO.CALENDAR_ID, AccountGroupsEO.INFOLET_TYPE_CODE, AccountGroupsEO.DERIVE_LEDGER_FLAG, AccountGroupsEO.ACCESS_LEVEL_CODE FROM GL_ACCOUNT_GROUPS AccountGroupsEO WHERE USER_GUID = (SELECT user_guid FROM per_users WHERE username = :BindByUserName AND active_flag = 'Y') AND INFOLET_TYPE_CODE = :BindTypeCode AND CALENDAR_ID = :BindByCalId AND CHART_OF_ACCOUNTS_ID = :BindByCoaId ORDER BY AccountGroupsEO.DEFAULT_FLAG DESC, AccountGroupsEO.ACCOUNT_GROUP_NAME

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!