Skip to main content

What is Oracle Applications ?????


What is Oracle Applications ?????

Oracle initially launched its application suite with financials software in the late 1980s. The offering as of 2009 extends to supply-chain management, human-resource management, warehouse-management, customer-relationship management, call-center services, product-lifecycle management, and many other areas. Both in-house expansion and the acquisition of other companies have vastly expanded Oracle's application software business.


Oracle Apps ... Is it just the short name of Oracle Applications? may be yes, however this question is an excuse for me to explain to you the evolution of APPS schema.

Previously each module had its own database schema(which we still have). However, a purchasing user (until version 10.6) used to connect to PO schema (by the virtue of the screen being a PO screen).

Hence, if a report or screen of AR ( Oracle Receivables ) module wanted to access a table named PO_HEADERS_ALL, they would then use notation PO.PO_HEADERS_ALL.However, now we have several database schemas(in most cases one schema per module).The tables are still owned by their respective schema, but now we have a central schema named APPS. Oracle ERP simply connects to APPS database schema for all its operations(with a couple of exceptions that are best ignored for now).
Labels:

Comments

Post a Comment

Popular posts from this blog

Query to find concurrent programs associated to Responsibility - Oracle Apps R12

 Query to Find Programs associated to Responsibility SELECT frt.responsibility_name, frg.request_group_name,     frgu.request_unit_type,frgu.request_unit_id,     fcpt.user_concurrent_program_name     FROM fnd_Responsibility fr, fnd_responsibility_tl frt,     fnd_request_groups frg, fnd_request_group_units frgu,     fnd_concurrent_programs_tl fcpt     WHERE frt.responsibility_id = fr.responsibility_id     AND frg.request_group_id = fr.request_group_id     AND frgu.request_group_id = frg.request_group_id     AND fcpt.concurrent_program_id = frgu.request_unit_id     AND frt.LANGUAGE = USERENV('LANG')     AND fcpt.LANGUAGE = USERENV('LANG')     AND fcpt.user_concurrent_program_name = :conc_prg_name     ORDER BY 1,2,3,4
Post a Comment
Read more

Query to find Open PO Periods - Oracle Apps R12

 Query to Find Open PO Periods for Month End Closure SELECT sob.name "Set of Books" ,   fnd.product_code "Product Code" ,   ps.PERIOD_NAME "Period Name" ,   ps.START_DATE "Period Start Date" ,   ps.END_DATE "Period End Date" ,   DECODE(ps.closing_status, 'O','O - Open' ,                             'N','N - Never Opened' ,                             'F','F - Future Enterable' ,                             'C','C - Closed' ,'Unknown') "Period Status" FROM gl_period_statuses ps ,   Apps.GL_SETS_OF_BOOKS sob ,   FND_APPLICATION_VL fnd WHERE ps.application_id      IN (201) -- 101 GL & 201 PO  AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID AND fnd.application_id        = ps.appl...
Post a Comment
Read more

Query for profile options - Oracle Apps R12

 Query for Profile Options Profile’s Enabled at Site Level SELECT fpot.user_profile_option_name, fpov.profile_option_value   FROM fnd_profile_option_values fpov,        fnd_profile_options fpo,        fnd_profile_options_tl fpot  WHERE     fpo.profile_option_id = fpov.profile_option_id        AND fpo.profile_option_name = fpot.profile_option_name        AND fpot.language = 'US'        AND fpov.level_id = 10001                              -- Site Level ID Profile’s Enabled at Application Level SELECT fat.application_name,        fpot.user_profile_option_name,        fpov.profile_option_value   FROM fnd_profile_option_values fpov,        fnd_profile_options fpo,        fnd_profile_options_tl fpot, ...
Post a Comment
Read more