What is the Diff between APPS Schema and other Schemas?
Apps schema contains only Synonyms we can't create tables in apps schema, where as other schemas contains tables, & all the objects. Here only we will create the tables and giving grants on created tables. Almost all every time we will connect to apps schema only.
What is meant by Custom Top and what is the Purpose?
Custom Top is nothing but Customer Top, which is created for customer only. we can have multiple custom
tops based on client requirement. It is used to store developed & customized components. Whenever oracle corp applying patches it will over ride on all the modules except custom top. That’s why we will use custom top.
What is the Significance of US Folder?
It is nothing but language specification by default it is in american language. We can have multiple languages folders based on installed languages. from backend we can get it from
select language_code,nls_language from fnd_languages where installed_flag like 'B'
Where did U find the Application short name and basepath names?
select basepath,application_short_name from fnd_application from the backend. From the from end we can get it Navigation Application Developer.-----> Application---->Register The application name we will get from FND_APPLICATION_TL
Where can U find the release version from backend?
SELECT release_name from FND_PRODUCT_GROUPS; ---126.96.36.199 .
What are the Folders we will find below the 11.5.0 Folder?
Can we create Tables in the Apps Schema?
Can we have custom schema when it it required?
yes, we can have custom schema, when we want to create a new table we required custom schema.
What is meant by concurrent Program?
It is nothing but Instance of the execution along with parameters & Incompatables. Here Incompatables nothing but if we are submiting cc programs if any one can be execute in those program , which programs r not imp yet this time we will mention those programs in incompatables tab.
What are the steps we will follow to register Reports as Concurrent Program?
First develop the report & save it in local machine. upload into custom_top/11.5.0/reports/us/ go to system administrator open executable form create executable by mentioning executable method as reports ,executable as report name which was created. go to cc program form create ccprogram by attach executable name in executable section. then attach this ccprogram to request group, Request group to Responsibility.Responsibility to User.
What is meant by Request group?
It is nothing but collection of cc programs.
What is Application Top? What are the types and Purpose?
A) When we connect to the server we will find the top called application top. Under application top we have
It is a language specific folder used to store the G.U.I like reports and forms.
What are mandatory parameters of Procedures and what the use of those?
What is Apps Schema and Schema?
What is Token?
a) Use to transfer values to report builder and it is not case sensitive.
Tell me something about SQL-LOADER.
What is SET-OF-BOOKS?
Tell me what r the Base tables in the AR?
FND USER EXITS:-
What is Value Set?
Form development process?
How does u customize the Reports?
Difference between Bind and Lexical parameters?
what is Flex mode and Confine mode?
What is Place holder Columns?
What is Formula Column?
What is Summary columns?
What is TCA (Trading Community Architecture)?
Difference between Application Developer and System Administrator?
What are Flex fields?
Report registration process?
Define Request Group?
Value Validation Types?
Incompatibility in report registration and Run Alone?