Query General Ledger Balance Service

While configuring the queryGLBalanceTxn service, a java.outOfMemory error can occur. Because the database can have so many records, it might be unable to configure the service. One workaround is to use a restricting condition in the query, that is, 1 = 2 so that the service configures successfully. After you have configured this service, remove the restricting condition from your transaction definitions. In addition, update the SQLOut parameters of the service’s transactionRecord in the Designer and remove the restricting condition. (In this example, you remove the 1 = 2 condition.)

Document Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ ID		Not used	Populated from a sequence and used internally in the flow. Contains a null value for queried vendor data.
DOCUMENT_ TYPE		Not used	Use GLBALANCE.
DOCUMENT_ STATUS		Not used	Use QUERY.
SET_OF_BOOKS_ NAME	GL_SETS_OF_ BOOKS	Name	Populated by joining the Set of Books ID with the corresponding ID in GL_SETS_OF_BOOKS table.
ACCOUNT_CODE	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Use Code Combination ID stored in the GL_BALANCES table to join with the Code Combination ID in GL_CODE_ COMBINATIONS_KFV table.
CURRENCY_ CODE	GL_BALANCES	CURRENCY_ CODE
PERIOD_NAME	GL_BALANCES	PERIOD_NAME
ACTUAL_FLAG	GL_BALANCES	ACTUAL_FLAG
BUDGET_ VERSION_ NAME	GL_BUDGET_ VERSIONS	BUDGET_NAME	Joined with the Budget Version ID.
ENCUMBRANCE_ TYPE	GL_ ENCUMBRANCE_ TYPES	ENCUMBRANCE_ TYPE	ENCUMBRANCE_TYPE_ID is joined with GL_BALANCES. ENCUMBRANCE_TYPE_ID.
REVALUATION_ STATUS	GL_BALANCES	REVALUATION_ STATUS
PERIOD_TYPE	GL_BALANCES	PERIOD_TYPE
PERIOD_YEAR	GL_BALANCES	PERIOD_YEAR
PERIOD_NUMBER	GL_BALANCES	PERIOD_NUMBER
PERIOD_NET_DR	GL_BALANCES	PERIOD_NET_DR	Period net debit balance.
PERIOD_NET_CR	GL_BALANCES	PERIOD_NET_CR	Period net credit balance.
PERIOD_TO_ DATE_ADB	GL_BALANCES	PERIOD_TO_ DATE_ADB	Period-to-date ADB balance.
QUARTER_TO_ DATE_DR	GL_BALANCES	QUARTER_TO_ DATE_DR	Quarter-to-date debit balance.
QUARTER_TO_ DATE_CR	GL_BALANCES	QUARTER_TO_ DATE_CR	Quarter-to-date credit balance.
QUARTER_TO_ DATE_ADB	GL_BALANCES	QUARTER_TO_ DATE	Quarter-to-date ADB balance.
YEAR_TO_ DATE_ADB	GL_BALANCES	YEAR_TO_ DATE_ADB	Year-to-date ADB balance.
PROJECT_TO_ DATE_DR	GL_BALANCES	PROJECT_TO_ DATE_DR	Accumulated project debit balance.
PROJECT_TO_ DATE_CR	GL_BALANCES	PROJECT_TO_ DATE_CR	Accumulated project credit balance.
PROJECT_TO_ DATE_ADB	GL_BALANCES	PROJECT_TO_ DATE_ADB	Accumulated project ADB balance.
BEGIN_BALANCE_ DR	GL_BALANCES	BEGIN_BALANCE_ DR	Beginning debit balance.
BEGIN_BALANCE_ CR	GL_BALANCES	BEGIN_BALANCE_ CR	Beginning credit balance.
PERIOD_NET_ DR_BEQ	GL_BALANCES	PERIOD_NET_ DR_BEQ	Period net debit balance, base currency.
PERIOD_NET_ CR_BEQ	GL_BALANCES	PERIOD_NET_ CR_BEQ	Period net credit balance, base currency.
BEGIN_BALANCE_ DR_BEQ	GL_BALANCES	BEGIN_BALANCE_ DR_BEQ	Beginning debit balance, base currency.
BEGIN_BALANCE_ CR_BEQ	GL_BALANCES	BEGIN_BALANCE_ CR_BEQ	Beginning credit balance, base currency.
SUMMARY_ TEMPLATE_ NAME	GL_SUMMARY_ TEMPLATES	TEMPLATE_ NAME	Joined TEMPLATE_ID with GL_BALANCES.TEMPLATE_ID.

Database Script	Description
wm_install_from_glbalance.sql	Runs all the scripts listed below, except the uninstall script.
wm_from_glbalance_vw.sql	Creates the following required view component: WM_GL_BALANCES_QRY_VW
wm_drop_from_glbalance.sql	Uninstalls all components created by wm_install_from_glbalance.sql.