Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hi all,

what are the mandatory sql/plsql commands functional consultant need to know, let me know please.....



Hi all, what are the mandatory sql/plsql commands functional consultant need to know, let me know..

Answer / newbie

I would say basic select statement to query some data from base table , knowledge of various types of Joints( Inner/Outer ) , ability to convert data into specific format Like ( YYYY/MM/DD HH:MM:SS ) , truncate , delete

I think if you know these command you should be fine . I think w3schools is a good place to learn it

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Apps Financial Interview Questions

What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

0 Answers   Doyensys,


What are the mandatory accounts that need to be setup in Set of Books?

4 Answers   HCL, Syntel,


How do we depreciate Assets in Oracle Applications?

2 Answers  


What is a Payable Document?

6 Answers   HCL, IBM, Oracle, TCS,


what is the revenue recognization program in ar &what is the difference between aging report and revenue recognization report.

2 Answers   Cognizant,


I have a existing Oracle applicttions and need to bring one of the new business on it. The new business will use GL, AP and FA. We will use existing COA. This business will have 3 sets of books (1- tax book, from April to March; 2- Primary book, from July to June; 3- Reporting book, from July to June); All books will have same currency; HOW DO I TRANSFER DATA FROM PRIMARY BOOK INTO TAX AND REPORTING BOOKS EVERY MONTH? IS THERE ANY STANDARD ORACLE PROCESS WHICH CAN BE SCHEDULED? THE REPORTING BOOK WILL HAVE DIFFERENT DEPRECIATION METHOD SO HOW DO I NOT TRANSFER DEPRECIATION FROM PRIMARY TO REPORTING BOOK AND DO SEPERATE DEPRECIATION IN REPORTING BOOK FOR THE SAME ASSET THAT IS ALSO IN PRIMARY AND TAX BOOK?. HOW DO I APPROACH ON SETTING THESE NEW SETS OF BOOKS? Thank you in advance for your help.

3 Answers   Oracle,


Can it be set that the GL date is the Sale Order date or Ship to Date?

1 Answers  


Hi all, I have setup my AP and created 3 invoice batches which as seen validated yet when i try to make payment i get the following error"APP-SQL - 10006: the date you entered is not an open accounting period." I have opened the calendar for that month yet it giving me this error. Any help will be appreciated.

4 Answers   IBM,


What is receipt class & receipt source pls let me know

2 Answers   Accenture,


Payables Applications Technical Reference Manual

0 Answers  


i want a report for how many operating units in my business group, is this any concurrent request to get this report? plz tel...

1 Answers   Genpact,


what is the difference between balance, account, none (automatic offset methods)?

4 Answers   Cognizant,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)