Total Pageviews

Showing posts with label Oracle Apps Technical Interview Question. Show all posts
Showing posts with label Oracle Apps Technical Interview Question. Show all posts

Thursday, 27 May 2021

Oracle Apps Technical Interview Question : Workflow

 


Workflow

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

 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.


FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...