My Oracle Support Banner

GMSMBUPB: GMS_BUDGET_PUB. ADD_BUDGET_LINE API Completes In Error - 20001--ORA-20001: Error occurred while validating the Budget Entry Method (Doc ID 2861003.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Grants Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The award budget API is not working as expected and fails with the error.

Gms_Budget_Pub.Add_Budget_Line Api Error => -'20001--ORA-20001: Error occurred while validating the Budget Entry Method'

Gathering the fnd_log of the API shows the internal error  - GMS_ENTRY_METHOD_IS_INVALID

Steps to Reproduce
---------------------
Execute the GMS_Budget_Pub.Add_Budget_Line API
Providing all required inputs


DECLARE    

    x_str                           VARCHAR2(1000) := NULL;
    x_main_err_stg           VARCHAR2(4000) := NULL;
    l_errbuff                       VARCHAR2(240);
    l_retcode                     VARCHAR2(240);
    x_err_code                  NUMBER := NULL;
    x_count                       NUMBER := 0;
    x_err_stage                 VARCHAR2(240) := NULL;
    x_err_stack                 VARCHAR2(240) := NULL;
    l_awardnum                 VARCHAR2(30) := <AWARD_NUMBER>;
    l_projectnum                VARCHAR2(30) := <PROJECT_NUMBER>;
    p_calling_module          varchar2(255) := 'GMS';
    l_award_id                   number;
    l_project_id                  number;
    l_task_id                      number;          
    wf_status                    VARCHAR2(240):= NULL;

    v_tab gms_award_pub.personnel_type := gms_award_pub.personnel_type ();
    v_excptn gms_award_pub.personnel_excp_type := gms_award_pub.personnel_excp_type ();
    v_return_status VARCHAR2(1);
    v_success_cnt NUMBER := 0;
    v_error_cnt NUMBER := 0;
    i BINARY_INTEGER := 0;
    v_result VARCHAR2(25);
    verrormessage VARCHAR2(1500);
    vmessage VARCHAR2(1500);
    ncount NUMBER;  

gms_budget_pub.add_budget_line(
         1.0
        , x_err_code
        , x_err_stage
        , x_err_stack=> x_err_stack
        , p_commit => 'T'
        , p_init_msg_list => 'T'
        , p_pm_product_code  => 'GMS'
        , p_project_id => l_project_id
       -- , p_project_number => ''
        , p_award_id => l_award_id
       -- , p_award_number => 'AWARD NUMBER'
        , p_budget_type_code => 'AC'
--        , p_task_id => l_task_id
      --  , p_task_number => '1'
      --  , p_resource_alias => 'MISCELLANEOUS OPERATING '
      --  , p_resource_list_member_id =>
        , p_budget_start_date => '01-JUL-2005'
        , p_budget_end_date  => '30-JUN-2022'
      --  , p_period_name => 'Jan-22'
        , p_description => 'TESTING ADD LINE'
        , p_change_reason_code => 'New Line Increase'
        , p_raw_cost => 0   <This should be NULL>
        , p_burdened_cost => 18645
        , p_quantity => 0    <This should be NULL>
        , p_unit_of_measure => 'Hours'
        , p_track_as_labor_flag => 'Y'
        , p_pm_budget_line_reference => gms_budget_pub.g_pa_miss_char
        , p_attribute_category => gms_budget_pub.g_pa_miss_char
        , p_attribute1 => gms_budget_pub.g_pa_miss_char
        , p_attribute2 => gms_budget_pub.g_pa_miss_char
        , p_attribute3 => gms_budget_pub.g_pa_miss_char
        , p_attribute4 => gms_budget_pub.g_pa_miss_char
        , p_attribute5 => gms_budget_pub.g_pa_miss_char
        , p_attribute6 => gms_budget_pub.g_pa_miss_char
        , p_attribute7 => gms_budget_pub.g_pa_miss_char
        , p_attribute8 => gms_budget_pub.g_pa_miss_char
        , p_attribute9 => gms_budget_pub.g_pa_miss_char
        , p_attribute10 => gms_budget_pub.g_pa_miss_char
        , p_attribute11 => gms_budget_pub.g_pa_miss_char
        , p_attribute12 => gms_budget_pub.g_pa_miss_char
        , p_attribute13 => gms_budget_pub.g_pa_miss_char
        , p_attribute14 => gms_budget_pub.g_pa_miss_char
        , p_attribute15 => gms_budget_pub.g_pa_miss_char
        , p_raw_cost_source => gms_budget_pub.g_pa_miss_char
        , p_burdened_cost_source => gms_budget_pub.g_pa_miss_char
        , p_quantity_source => gms_budget_pub.g_pa_miss_char
       );

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.