Oracle GL Budget Interface

 How to create Budget using GL_BUDGET_INTERFACE table in Oracle General Ledger

 

BUSINESS VALIDATIONS

 

FISCAL_YEAR IS NOT NULL

 

 

VALIDATE CODE COMBINATIONS

 

SELECT gcc.code_combination_id
INTO x_ccid
FROM gl_code_combinations gcc
WHERE gcc.segment1 = p_segment1
AND gcc.segment2 = p_segment2
AND gcc.segment3 = p_segment3
AND gcc.segment4 = p_segment4
AND gcc.segment5 = '000'
AND gcc.segment6 = '00000';
           

PERIOD_AMOUNT IS NOT NULL  

      

 

DERIVE BUDGET_VERSION_ID FOR BUDGET_NAME 

 

SELECT budget_version_id
INTO r_budget_line.budget_id
FROM gl_budget_versions
WHERE budget_name = p_budget_name;
                  

DERIVING BUDGET_ENTITY_ID FOR  ENTITY NAME   

 

SELECT budget_entity_id
INTO r_budget_line.entity_id
FROM gl_budget_entities
WHERE NAME = p_entity_name;

 

              

INSERT INTO GL_BUDGET_INTERFACE

--p_budget_int_row is cursor created on budget temp table

 

INSERT INTO gl_budget_interface
                        (budget_name,
                         budget_entity_name,
                         currency_code,
                         fiscal_year,
                         update_logic_type,                        
                         segment1,
                         segment2,
                         segment3,
                         segment4,
                         segment5,
                         segment6,
                         period1_amount,
                         period2_amount,
                         period3_amount,
                         period4_amount,
                         period5_amount,
                         period6_amount,
                         period7_amount,
                         period8_amount,
                         period9_amount,
                         period10_amount,
                         period11_amount,
                         period12_amount,
                         period13_amount,
                         last_update_date,
                         last_updated_by)
VALUES (       p_budget_int_row.budget_name,
                         p_budget_int_row.entity_name,
                         p_budget_int_row.currency_code,
                         p_budget_int_row.fiscal_year,
                         'R',  --A for add , R for replace                       
                         p_budget_int_row.business_unit,
                         p_budget_int_row.entity,
                         p_budget_int_row.cost_centre,
                         p_budget_int_row.ACCOUNT,
                         p_budget_int_row.icp,
                         p_budget_int_row.c4,
                         NVL(p_budget_int_row.period1_amount,0),
                         NVL(p_budget_int_row.period2_amount,0),
                         NVL(p_budget_int_row.period3_amount,0),
                         NVL(p_budget_int_row.period4_amount,0),
                         NVL(p_budget_int_row.period5_amount,0),
                         NVL(p_budget_int_row.period6_amount,0),
                         NVL(p_budget_int_row.period7_amount,0),
                         NVL(p_budget_int_row.period8_amount,0),
                         NVL(p_budget_int_row.period9_amount,0),
                         NVL(p_budget_int_row.period10_amount,0),
                         NVL(p_budget_int_row.period11_amount,0),
                         NVL(p_budget_int_row.period12_amount,0),
                         NVL(p_budget_int_row.period13_amount,0), SYSDATE,
                         fnd_profile.VALUE ('USER_ID')
                        );

 

Upload a budget:

1. Navigate to the Upload Budget window.

General Ledger Super User Responsibility

Budgets> Enter > Upload

2. Enter the Budget and Budget Organization that will receive the uploaded budget amounts. You can upload budgets for all of your budget organizations by entering the name of your general,all–inclusive budget organization.

3. Choose Upload.

General Ledger submits a concurrent process to upload budget information from the GL_BUDGET_INTERFACE table.

4. Review the Budget Spreadsheet Upload Execution Report for the status of your uploaded budget information.

 

Base Table: GL_BUDGETS