Thursday, August 21, 2014

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
 
 

No comments:

Post a Comment