Receive General Ledger Budget Service

Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Financial Predefined Transaction Services | Receive General Ledger Budget Service

This service is in the WmOAFIN1227 package and has the following fully-qualified service name: generalLedger1227.intoOA.GLBudget:receiveGLBudget.

This service monitors the GL Budget insert process.

You can use this service to load budgets to the Oracle Applications General Ledger budget interface tables. Use the Budget amounts to:

Upload a budget amount only for current or open budgets.

Upload a budget amount only for open budget fiscal years within a budget. A new budget can be opened using the Define Budgets window in the Oracle Applications General Ledger.

Add new or replace existing Budget amounts.

Upload a budget amount for an existing account that falls within the account ranges assigned to the Budget Organization.

Database Scripts

This service does not require any database scripts.

Supporting Transaction Definitions

This service was built from the configured services defined in the following transaction definitions:

GLBudgetTransactions1227.txp

setGLBudgetTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

The main flow executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (interface tables). It loops over the parent and the child to extract data to flat format.

getSOBVersionEntityId maps SET_OF_BOOKS_ID, BUDGET_VERSION_ID, and BUDGET_ENTITY_ID based on P_BUDGET_NAME and P_BUDGET_ORGANIZATION passed to it. This service is in bizDocMapping.

getGLCodeCombinationId obtains the CODE_COMBINATION_ID based on the GL Accounting Segments and SET_OF_BOOKS_NAME.

setGLBudgetTxn inserts data into the interface table. It extracts data form the IData structure resulted in the bizDocMapping service and puts the data into the interface table in Oracle Applications for GL Budgets Open Interfaces.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

Business Document Structure

This service uses the business document GLBudgetBizDoc. Its structure is as follows:

GL_BUDGET

GL_BUDGET (Maps to GL_BUDGET_INTERFACE)

Field Name	Maps to Column	Description
BUDGET_NAME	BUDGET_NAME	Required. Name of the budget in Define Budget window.
BUDGET_ENTITY_NAME	BUDGET_ENTITY_NAME	Required. Budget organization name in Define Budget Organization window.
FISCAL_YEAR	FISCAL_YEAR	Required. Fiscal year for budgeting.
CURRENCY_CODE	CURRENCY_CODE	Required. Budget currency code.
UPDATE_LOGIC_TYPE	UPDATE_LOGIC_TYPE	Required. Use: R for replace the amount for the budget. A for add amount to the existing amount for the budget.
CODE_COMBINATION_ID
PERIOD_TYPE
DR_FLAG
STATUS
ACCOUNT_TYPE
PERIOD1_AMOUNT through PERIOD60_AMOUNT	PERIOD1_AMOUNT through PERIOD60_AMOUNT	Amounts for a maximum of 60 periods in a fiscal year.
SEGMENT1 through SEGMENT30	SEGMENT1 through SEGMENT30	Segments in the accounting flexfield structure.