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
