1) How to Migrate Workflow ?
2) What is the Standard Process to Customize Seeded Workflow?
3) How to Customize Seeded Workflow that after patch it wont get remove.
4) How to Analyse Workflow Errors?
5) How to Launch Workflow from PLSQL?
6) Error Tables for Workflow?
7) Have u ever Customized Seeded Workflow and How?
8) How to hide Action History from Notifcations Page?
Ans:- Need to set null to #History Attributes
Oracle Apps Technical Interview Question : PLSQL
1) What is Exception? User Defined Exception
2) Can we write commit in Trigger? How ?
3) Is commit Required to submit request from Trigger?
4) Commit/RollBack, Save Point?
5) Difference between VARRAY and Record Type? Advantage of both?
6) What is object types?
7) What are the attributes of PLSQL Table.
Ans:- .extend, .count, .delete, .prior, .next, .first, .last
8) What is the Difference between ROWType and Record Type?
9) What is Bulk Collect and its exception types, loop
10) What happen when Expception “When Others Then” placed above “When No_Data_Found”?
Ans:- It will Raise Exception.
/* Formatted on 2021/05/27 20:12 (Formatter Plus v4.8.8) */
DECLARE
x_batch_step_rec gme_batch_steps%ROWTYPE;
p_batch_step_rec gme_batch_steps%ROWTYPE;
p_validation_level NUMBER DEFAULT 100;
x_message_count NUMBER;
x_return_status VARCHAR2 (240);
x_message_list VARCHAR2 (240);
BEGIN
fnd_global.apps_initialize (1536, 23326, 553);
p_batch_step_rec.batchstep_no := 11;
p_batch_step_rec.oprn_id := 74087;
p_batch_step_rec.actual_start_date := '01-MAY-21';
p_batch_step_rec.actual_cmplt_date := '03-MAY-21';
-- p_batch_step_rec.BATCH_ID:=466340;
p_batch_step_rec.batchstep_id := 334733;
p_batch_step_rec.actual_step_qty := 3;
gme_api_pub.update_batchstep_qty
(p_api_version => 1.0,
p_validation_level => p_validation_level,
p_init_msg_list => 'F',
p_commit => 'T',
p_org_code => 'KT',
p_batch_no => '20004203'
--,P_ACTUAL_START_DATE='3-MAY-2021'
-- ,p_add =>'N'
,
p_batch_step_rec => p_batch_step_rec,
x_batch_step_rec => x_batch_step_rec,
x_message_count => x_message_count,
x_message_list => x_message_list,
x_return_status => x_return_status
);
COMMIT;
DBMS_OUTPUT.put_line ( x_batch_step_rec.actual_cmplt_date
|| ','
|| x_batch_step_rec.actual_start_date
);
DBMS_OUTPUT.put_line ( 'x_return_status : '
|| x_return_status
|| ' x_message_list: '
|| x_message_list
);
IF x_message_list IS NULL
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END IF;
END;
1) Form Personlization header table
select rule_key,function_name,sequence ,rule_type,enabled,a.*
from fnd_form_custom_rules a
where form_name ='APXINWKB'
2) Form Personalization Action Table
select id, rule_key,function_name,a.sequence ,rule_type,TRIGGER_EVENT, trigger_object,b.*
from fnd_form_custom_rules a ,FND_FORM_CUSTOM_ACTIONS b
where a.ID = b.RULE_ID
and form_name ='APXINWKB'
Windows File rename: How to rename bulk file through CMD mode
1) Open CMD and go to specific directory
2) type below command to display list of files
dir /b
3) Select all files and copy,
4) Paste the file in Excel and build the dos rename syntax as shown below
6) Multiple bulk files renamed
OPM : Query to get Item wise cost in OPM
SELECT ccdv.inventory_item_id, ccdv.organization_id, ccm.cmpnt_group,
SUM (NVL (cmpnt_cost, 0)) costs
--ccm.cost_cmpntcls_code,
FROM cm_cmpt_dtl_vw ccdv,
cm_cldr_mst_v ccmv,
cm_cmpt_mst ccm,
mtl_parameters mp,
org_organization_definitions ood,
gl_code_combinations gcc,
gmf_fiscal_policies gfp
WHERE 1 = 1
AND ccdv.period_id = ccmv.period_id
AND TRUNC (ccmv.start_date) >= :p_start_date
AND TRUNC (ccmv.end_date) <= :p_end_date
AND ccmv.calendar_code = :p_calendar_code
AND ccdv.cost_cmpntcls_id = ccm.cost_cmpntcls_id
AND ccmv.cost_type_id = gfp.cost_type_id
AND ccdv.organization_id = mp.organization_id
AND mp.organization_id = ood.organization_id
AND mp.material_account = gcc.code_combination_id
AND gcc.segment1 BETWEEN :p_child_low AND :p_child_high
AND (:p_business_unit IS NULL OR gcc.segment2 = :p_business_unit)
AND ood.legal_entity = gfp.legal_entity_id
GROUP BY ccdv.inventory_item_id, ccdv.organization_id, ccm.cmpnt_group
OAF : Migration Command
java oracle.jrad.tools.xml.
RTF Template Function and XML method TAG
1) How to use NVL function in RTF template (XML Publisher)
<?xdofx:nvl(RISF_VC_LY,0)-nvl(RISF_VC_AC,0)?>
How to upload GMD Specification validity for Customer
DECLARE
--l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
l_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;
--l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
x_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;
l_return_status CHAR(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
BEGIN
fnd_profile.initialize (2820);
fnd_global.apps_initialize(user_id =>1142,resp_id =>23805 ,resp_appl_id =>552 );
fnd_msg_pub.initialize;
gme_common_pvt.g_error_count := 0;
gme_common_pvt.set_timestamp;
gme_common_pvt.g_move_to_temp := fnd_api.g_false;
--l_customer_spec_vrs.spec_vr_id := NULL;
l_customer_spec_vrs_tbl(1).spec_id :=12416;--- 12420;
-- l_customer_spec_vrs.ORG_ID := 110;
l_customer_spec_vrs_tbl(1).cust_id := 10988;
l_customer_spec_vrs_tbl(1).ship_to_site_id := NULL;
l_customer_spec_vrs_tbl(1).spec_vr_status := 100;--700
l_customer_spec_vrs_tbl(1).delete_mark := 0;
l_customer_spec_vrs_tbl(1).start_date := SYSDATE;
-- l_customer_spec_vrner_id := q.USER_ID;
l_customer_spec_vrs_tbl(1).creation_date := SYSDATE;
l_customer_spec_vrs_tbl(1).created_by := 1133;
l_customer_spec_vrs_tbl(1).last_updated_by := 1133;
l_customer_spec_vrs_tbl(1).last_update_date := SYSDATE;
l_customer_spec_vrs_tbl(1).last_update_login := 1133;
apps.GMD_SPEC_VRS_PUB.CREATE_CUSTOMER_SPEC_VRS
( p_api_version => '1.0'
, p_init_msg_list => apps.FND_API.G_FALSE
, p_commit => apps.FND_API.G_TRUE
, p_validation_level => apps.fnd_api.g_valid_level_full
, p_customer_spec_vrs_tbl => l_customer_spec_vrs_tbl
, p_user_name => 'ALAM'
, x_customer_spec_vrs_tbl => x_customer_spec_vrs_tbl
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
COMMIT;
dbms_output.put_line( l_customer_spec_vrs_tbl(1).spec_id );
dbms_output.put_line('return_status:-----'||l_return_status);
dbms_output.put_line('Msg_Count:--------'|| l_msg_count||','||l_msg_data);
--dbms_output.put_line('Msg_Count:--------'|| l_msg_count);
--dbms_output.put_line('msg_data ---------'||x_msg_data);
--dbms_output.put_line('spec_id-----------'||x_spec);
--dbms_output.put_line('spec_test_id------'||x_spec_tests_tbl);
IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
THEN
FOR i IN 1..FND_MSG_PUB.COUNT_MSG LOOP
l_msg_data := FND_MSG_PUB.get( p_msg_index => i,
p_encoded => FND_API.G_FALSE
);
dbms_output.put_line('The API call failed with error '||l_msg_data);
END LOOP;
ELSE
dbms_output.put_line('The API call ended with SUCESSS status');
END IF;
END;
