GL budget interface

GL budget interface

Budget interface lets you load budget data from external sources into Oracle
Applications.

Pre-requisites:

• Set of Books
• Flex field Value sets
• Code Combinations

Interface tables:

• GL_BUDGET_INTERFACE

Base tables:

• GL_BUDGETS
• GL_BUDGET_ASSIGNMENTS
• GL_BUDGET_TYPES

Concurrent program:

• Budget Upload

Validations:

• Check if CURRENCY_CODE is valid.
• Check if SET_OF_BOOKS_ID is valid.
• Check if BUDGET_ENTITY_NAME (budget organization) is valid.

Important Columns:
Some important columns that need to be populated in the interface tables:
GL_BUDGET_INTERFACE:

• BUDGET_NAME NOT
• BUDGET_ENTITY_NAME
• CURRENCY_CODE
• FISCAL_YEAR
• UPDATE_LOGIC_TYPE
• BUDGET_ENTITY_ID
• SET_OF_BOOKS_ID
• CODE_COMBINATION_ID
• BUDGET_VERSION_ID
• PERIOD_TYPE
• DR_FLAG
• STATUS
• ACCOUNT_TYPE
• PERIOD1_AMOUNT to PERIOD60_AMOUNT
• SEGMENT1 to SEGMENT30