<\/p>\n
<\/p>\n
SET serveroutput on;
\nDECLARE
\nl_user_name VARCHAR2(100) ;
\nl_user_id NUMBER;
\nl_resp_id NUMBER;
\nl_adj_rec OZF_FUND_UTILIZED_PVT.utilization_rec_type;
\nl_return_status VARCHAR2(1);
\nl_msg_count NUMBER;
\nl_msg_data VARCHAR2(2000);
\nl_utilization_id NUMBER;
\nBEGIN<\/p>\n
BEGIN
\nselect responsibility_id
\ninto l_resp_id
\nfrom fnd_responsibility_vl
\nwhere responsibility_key = ‘OZF_USER’;
\nEXCEPTION
\nWHEN OTHERS THEN
\nl_resp_id := NULL;
\nEND;<\/p>\n
FND_GLOBAL.apps_initialize (user_id => 1234 — change this value
\n, resp_id => l_resp_id, — Oracle trade management user
\nresp_appl_id => 123 — Oracle Trade management
\n);
\nFND_PROFILE.put (‘FND_AS_MSG_LEVEL_THRESHOLD’, FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
\nFND_MSG_PUB.initialize;<\/p>\n
l_adj_rec.adjustment_type_id := 402;
\nl_adj_rec.utilization_type := ‘ADJUSTMENT’;
\nl_adj_rec.adjustment_desc :=’Adjustment from Public API’;
\nl_adj_rec.fund_id := 10001; — fund_id
\nl_adj_rec.amount := 15;
\nl_adj_rec.plan_curr_amount := 15;
\nl_adj_rec.adjustment_date := ’19-DEC-2013′;
\nl_adj_rec.gl_date := ’19-DEC-2013′;
\nl_adj_rec.exchange_rate_date := ’19-DEC-2013′;
\nl_adj_rec.component_type := ‘OFFR’;
\nl_adj_rec.component_id := 29400;
\nl_adj_rec.plan_type := ‘OFFR’;
\nl_adj_rec.plan_id := 29400; — qp_list_header_id
\nl_adj_rec.product_level_type := ‘PRODUCT’;
\nl_adj_rec.product_id := 165954; — inventory_item_id
\nl_adj_rec.currency_code := ‘USD’;
\nl_adj_rec.plan_currency_code := ‘USD’;
\nl_adj_rec.fund_request_currency_code := ‘USD’;
\nl_adj_rec.cust_account_id := 1046; — max(cust_account_id) FROM ozf_funds_utilized_all_b.
\nl_adj_rec.billto_cust_account_id := 1046;
\nl_adj_rec.org_id := 81;<\/p>\n
OZF_FUND_UTILIZED_PVT.create_utilization (
\np_api_version => 1.0
\n,p_init_msg_list => fnd_api.g_false
\n,p_commit => fnd_api.g_false
\n,p_validation_level => fnd_api.g_valid_level_full
\n,x_return_status => l_return_status
\n,x_msg_count => l_msg_count
\n,x_msg_data => L_MSG_DATA
\n,p_create_gl_entry => fnd_api.g_false
\n,p_utilization_rec => l_adj_rec
\n,x_utilization_id => l_utilization_id
\n);<\/p>\n
dbms_output.put_line( ‘ l_utilization_id ‘||l_utilization_id);<\/p>\n
dbms_output.put_line(‘Create_Fund_Adjustment returns ‘ || l_return_status);
\nIF l_return_status <> ‘S’ THEN
\nFOR i IN 1..l_msg_count
\nLOOP
\ndbms_output.put_line(SUBSTR(fnd_msg_pub.get(p_msg_index => i, p_encoded => ‘F’), 1, 254));
\nEND LOOP;
\nROLLBACK;
\nELSE
\nCOMMIT;
\nEND IF;
\nEXCEPTION
\nWHEN OTHERS THEN
\ndbms_output.put_line(‘exception in creating adjustment’);
\nROLLBACK;
\nEND;<\/p>\n
<\/p>\n
— Select * from OZF_FUNDS_UTILIZED_ALL_B where utilization_id = 11240; –l_utilization_id
\n— Navigation to view the Budget Adjustment
\n— Oracle Trademanagement User -> Funds -> Search for the Budget -> Checkbook -> There you can see the increment in Earned\/utilized amount<\/p>\n","protected":false},"excerpt":{"rendered":"
SET serveroutput on; DECLARE l_user_name VARCHAR2(100) ; l_user_id NUMBER; l_resp_id NUMBER; l_adj_rec OZF_FUND_UTILIZED_PVT.utilization_rec_type; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_utilization_id NUMBER; BEGIN BEGIN select responsibility_id into l_resp_id from fnd_responsibility_vl where responsibility_key = ‘OZF_USER’; EXCEPTION WHEN OTHERS THEN l_resp_id := NULL; END; FND_GLOBAL.apps_initialize (user_id => 1234 — change this value , resp_id => l_resp_id, […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[503],"tags":[530,226,227,228],"class_list":["post-4706","post","type-post","status-publish","format-standard","hentry","category-om-api","tag-api","tag-budget","tag-create_utilization","tag-ozf_fund_utilized_pvt"],"yoast_head":"\n