Oracle apps interview type questions


  • Difference between D2k report and apps report?
In d2k reports we can not schedules the program or we can not use exits.we can not give the security that's why any body can run the report.in d2k report we can not run more then one report at a time.

In apps report we can schedules the program or we can use exits and we can give the security by assigning the concurrent to particular request group and responsibility. and we can also run more then one report at  a time by using request set.
  • Difference between 11I and R12  ?
It consist of 3c and it is not concept of MOAC ,in 11I major table such as po_vendors and banks are created in account payable ,AP_INVOICE_LINE_ALL table in finance is not there.

It consist of 4c and it is a concept of MOAC (multi org access control ) in R12 major table changes such as AP_SUPPLIER .banks are created in cash management.AP_INVOICE_LINES_ALL table in finance is there.and it has also sub ledger accounting is there.

  • what is AOL ?
AOL is stand for application object library for oracle applications .AOL is data depository for your oracle applications its keep track of all application object such as user(application) ,responsibilities,menu,application function etc.
  • what is OM ?
It stand for order management drives the order fulfillment process of any business.It capture multiple channel from source including EDI,XML,telesales or web storefronts as part of complete order to cash solution it enables global order promising.
Benefits:- 
→ Improve sale visibility 
→Increase customer satisfaction
→expedite sales cycles 
  • what is TDE ?
It stand for transparent data encryption.basically it enables the data or typically enables the sensitive data such as credit card or social security number.
Benefits:-
→  As a security administrator
→ It helps address security-related regulatory compliance issue.
→ you do not need to create auxiliary tables trigger or views.






Comments

Post a Comment

Popular posts from this blog

Sql If Condition

Image
if condition use and if condition make result set .we are just confirming messages where you want to type and where you want to display .it might to declare local variable and getting some value .either greater then and less then the result will display on the screen on your SQL server . here we observed if statement .you can use as select statement and more .  
Read more

GST AND GST TABLES IN ORACLE APPS

What is GST ? Goods and service tax is an indirect tax throughout India to replace taxes levied by the central and state governments. when goods and service taxes implemented, there will be three kinds of applicable goods and services taxes. CGST Where the revenue will be collected by the central government. SGST Where the revenue will be collected by the state government for intra-state sales. IGST Where the revenue will be collected by the central government for intra-state sales. Below is the comparison between new and old taxes regime TRANSACTION                NEW REGIME                  OLD REGIME                         COMMENTS Sale within  state                 CGST+SGST                     VAT+central excise/service       revenue will                                                                                          tax                                             be shared                                                                                    
Read more
WHAT IS RECORD ? Record is a composite data structure which hold data items of different kinds.Record consist of different fields similar to a row of data base table. 1)table base 2)cursor base record 3)user defined record To create table base or cursor base record we prefer % row type attribute which provide record type to represent a rows in data base table.record can stored rows from data base table or fetch from  cursor variable and cursor. e.g of table base declare v_rc employees.%rowtype; begin select * into v_rc from emolyees where employee_id=100; dbms_output.put_line('employees details:'||'v_rc.last_name||v_rc.first_name||v_rc.salary); end; 2)cursor base record declare cursor c_rec_emp is select last_name,employee_id,salary from employees v_c_r c_rec_emp.%rowtype; begin open c_rec_emp; loop fetch c_rec_emp into v_c_r; exit when c_rec_emp %notfound; dbms_output.put_line('employee datails:'||v_c_r.last_name||v_c_r.employee_id||v_c_r
Read more