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 laterInformation 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 |