f Get Oracle Apps Traning Here: Why call it Apps and not Oracle ERP ?
Main Menu
Techie or Funcy ?
Prerequisites
Training Index   

Interview Qns
Apps Interview Qns
HRMS Interview Qns

COPYRIGHT
This work is licensed under a Creative Commons -NonCommercial 2.5 License.



About Me

Name:
Location: United Kingdom

The desire to be extraordinary is a very ordinary desire. To relax and to be ordinary is really extraordinary

  • Subscribe for Emails

    • Previous Posts

    Tuesday, October 10, 2006

    Why call it Apps and not Oracle ERP ?

    Ever wondered why is Oracle’s eBusiness Suite nicknamed apps?

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

    I started working in Oracle Financials 9 years ago. Those days 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).

    Hence, if Oracle wants to create anew table named PO_HEADERS_ALL, they will do the following

    Step 1. Connect to po/po@XX_DEVDB
    Create table PO_HEADERS_ALL ( ...all columns here )

    Step2. Grant all on po_headers_all to apps ;

    Step 3. connect to apps/apps@XX_DEVDB
    Create or replace synonym PO_HEADERS_ALL for PO.PO_HEADERS_ALL


    By following the above steps, as you can see, APPS schema is able to access PO_HEADERS_ALL without the notation po.po_headers_all


    In Oracle ERP, now we have 100s of schemas, example po, ar, ap, gl etc.

    But the screens, reports, workflows etc in Oracle Applications connect to APPS schema only. Just like saying, ALL ROADS LEAD TO ROME. Here, all schema lead to APPS.

    Hence if you have a pseudo report that joins ap_invoices_all table( in AP schema) to PO_HEADERS_ALL table( in AP schema), you will simply need to do the below once connected to APPS.

    Selelct 'x’ from po_headers_all p, ap_invoices_all a where a.po_Id = p.po_Id

    Note, prior to version 10.6(of Oracle ERP –not database version), one had to do
    Selelct 'x’ from PO.po_headers_all p, AP.ap_invoices_all a where a.po_Id = p.po_Id

    Note: To keep matters simple, I haven’t considered org_Id in this example.
    Org_Id will be covered in one of the following chapters ( have a look at index).

    Moral of the Story is:-
    All the pl/sql packages will be created in APPS Schema
    All the views will be created in APPS Schema
    For each table in individual schema, there will exist one synonym in APPS schema
    Tables are not created in APPS schema.
    Every implementation has at least 1 custom schema, where custom tables are created.
    For each custom table created by you, you will need to create a Synonym in APPS schema
    As a developer, you will either connect to APPS Schema or to the custom schema where you will create new tables.

    Some notes:-
    Custom tables are generally required in Oracle ERP because:-
    1. You wish to create a custom screens ( your own screen to capture some info) for a functionality that is not delivered by Oracle
    2. Pre-Interface tables ( Interface will certainly be discussed in one of the latter chapters)
    3. Temp processing
    4. Staging of data for third party extract interfaces….and much more

    posted by Anil Passi at 4:24 PM

    Comments on "Why call it Apps and not Oracle ERP ?"

     

    Blogger pravin said ... (9:44 PM) : 

    hi,
    I Have heard that sap and oracle are competetors .

    Is it true or both of them have completely different products.

    Thanks
    Pravin

     

    Blogger Anil Passi said ... (11:31 PM) : 

    Indeed, both are different products with similar modules that are designed differently. Just like Apps uses Forms & pl/sql, SAP uses its own propriety programming language named ABAP

    Thanks
    Anil

     

    Blogger Atul Kumar said ... (8:32 AM) : 

    Hi Anil,
    First of all very good post .

    One suggest . Comments are in very light colour so tough to read.

    Tough to find comments link on your post .

    Rest your posts rocks.

    How about applsys schema , its almost same as apps but if apps is already there why one more schema applsys .

    Become Apps DBA

     

    Blogger Anil Passi said ... (8:43 AM) : 

    Hi Atul,

    APPS Schema is not meant to have any tables in it. Hence Oracle has APPLSYS schema which has all the tables for FND, AD & Workflow objects.

    Thanks,
    Anil Passi
    PS: I will sort something about my comment section, thanks for pointing this out . I generally use Firefox, where the text size appear to be OK.
    But I guess most of my readers use Internet Explorer just like you, hence a very valid point.

     

    Anonymous Anonymous said ... (1:49 AM) : 

    what if I have tables in apps schema ? is it a bad thing ?

    thanks,
    Florin Barbalau

     

    Blogger Anil Passi said ... (2:31 AM) : 

    You should not create table in APPS Schema. It does no harm though, but just not a good practice.

    You must be having a custom schema which is where your table must be created.

    Your steps will be:-

    1. Connect to custom schema, say its named xxsch
    2. create table xxx_table_001
    3. grant all on xxx_table_001 apps;
    4. connect to apps
    5. create or replace synonym xxx_table_001 for xxsch.xxx_table_001

    Note: You must create the following in APPS Schema
    1. PL/SQL Packages, procedures
    2. Views
    3. Synonyms

    Tables and sequences will be created in your custom schema

    Thanks
    Anil Passi

     

    Anonymous Anonymous said ... (1:23 PM) : 

    Awesome Anil. First of all i would like to thank you for ur support in creating this website.

    ORACLE has some pre-defined rules which we will follow while implementing oracle apps. if you want it to be executed in a right way without any problems, then you need to follow these standards...

     

    Anonymous Anonymous said ... (6:44 PM) : 

    Awesome information for beginners.

     

    Anonymous Anonymous said ... (2:25 AM) : 

    thanks for your reply Anil. there is one thing which I don't understand very well : there are some screens where the name is case sensitive. for example I go in Concurrent Program Executable window and I press F11 then I enter in the field "Execution File Name" a name like file% and I press CTRL+F11 but I would not get File as an answer. There are other screens where the search it is not case sensitive. How do I know when is case sensitive and when it is not ?

    thanks,

     

    Blogger Anil Passi said ... (2:36 AM) : 

    I have uploaded the answer to your question on below link

    How to Find if Query on Field is Case Insensitive

     

    Anonymous Anonymous said ... (8:20 AM) : 

    Hi Anil,

    U r just awesome, Cant say more than that to appreciate ur effort.

    Also, Just want to tell one more important point to comment on custom stuff. Someone said that why cant we create tables in APPS schema. You can do it, doesnt do any harm. You can customize oracle standard reports and forms or watever. but the reason why we dont do and why we create a separate custom schema is when we go for upgrade from one version to another version, everything get overwritten with the oracle standard ones and your custom ones that you created are gone. If you create all the custom objects and put it in a separate schema, then the DBA will take care such that while upgrading he will create and migrate all the custom objects to the new version.

    I dont know whether i am clear in giving the explanation, but if you did understood the reason, its great.

    Thanks
    Aman

     

    Blogger Anil Passi said ... (8:34 AM) : 

    Hi Aman

    Thanks for citing the reasons for not creating tables in APPS Schema.
    You are bang on Target.

    However a few things I would like to add:-
    1. The reasons cited by you apply to the below too:-
    a. Registering custom Conc Programs against Custom Applications.
    b. Registering custom Conc Program Executables against Custom Applications.
    c. Registering Custom Lookup Types against Custom Applications.
    d. Registering Custom Responsibilities against Custom Applications(HR can be exception, as some feature cease to work with Custmo Applications).
    e. Registering Flexfields against Custom Applications.

    2. These days, during upgrades, Oracle does not wipe out the complete APPS Schema to replace it with new sets of objects. Changes to APPS Schema during upgrade are incremental these days. Reason being that Oracle themselves advice us to cerate custom views and packages in APPS Schema.
    However, as you mentioned, Oracle holds the right to wipe out APPS Schema and replace it with new sets of Objects.

    Thanks for sharing your knowledge Aman, much appreciated.

    Thanks
    Anil Passi

     

    Anonymous Anonymous said ... (1:44 AM) : 

    Hello Anil,

    thanks. very clear; i guess there is no way to to make a search case insensitive when this property is false ?
    in your last comment you say something about
    Registering custom Conc Program Executables against Custom Applications. I saw that this screen is based on FND_EXECUTABLES_FORM_V which is created in APPS schema. What would be a best practice regarding a future upgrade ? Should we import the records from this table in the new upgraded OracleApps ?

    thanks

     

    Blogger Anil Passi said ... (2:24 AM) : 

    Hi Florin

    Oracle will pgrade all the existing values in FND_EXECUTABLES_FORM_V to the next version....

    Although, I am yet to know how this will work during Fusion upgrade.

     

    Anonymous Anonymous said ... (3:47 AM) : 

    ok. then what are you trying to say with :
    "
    However a few things I would like to add:-
    1. The reasons cited by you apply to the below too:-
    " ? I think that you cannot move the FND_EXECUTABLES_FORM_V table in another schema and as you said Oracle will upgrade this table to the next version. that means we don't have to worry about Registering custom Conc Program Executables against Custom Applications with regard to APPS schema ? I don't see what is the connection between what you say and the "best practice" to not create tables in APPS.

    and is there a simple way to see the last comments because now there are many articles ?

    thanks

     

    Blogger Anil Passi said ... (4:03 AM) : 

    Hi Florin,

    1. Yes, Oracle will upgrade the data in FND_EXECUTABLES_FORM_V to the next version. I confirm that this happens. Oracle does not delete data from table FND_EXECUTABLES.
    2. Depending upon which Application your Custom Form is registered against, your fmx file will be in the Corresponding Application Top Directory on Server.
    So, here is the deal.
    You register your form against AR and not against say XXAR application.
    During Upgrade, Oracle can delete all executables in $AR_TOP/forms/US, and hence you will loose your executable. But Oracle will never delete files from $XXAR_TOP/forms/US.
    If you register your custom Form executable with AR application, then during upgrade your Executable may be lost, even though the data in FND_EXECUTABLES is retained.

    Regardless of what Oracle will do or will not do, it is advised that you register all your custom programs against Custom Application. This was highlighted in this article itself, and also has been highlighted by other readers. Please trust that statement, although I appreciate your questions because you are trying to work out why Oracle preaches what it preaches.

    Its like saying....if sole thief in your town calls you up in morning saying that he won't rob your house...it does not mean you leave your house unlocked. The standard practice is to lock & secure it, because thief reserves the rights of robbing your house. And similarly Oracle reserves the right to purge table FND_EXECUTABLES and rebuild it. They usually do not purge this table during upgrade, but still we must follow the standards preached by Oracle.

    Thanks for your feedback on Comment. I will try to add a menu item which will navigate straight to the comments.

    Cheers,
    Anil Passi

     

    Blogger Anil Passi said ... (4:18 AM) : 

    Hi Florin,

    Another thing...as you said best practice states that "Tables must not be created in APPS Schema".
    This is correct.

    FND_EXECUTABLES_FORM_V is a view on top of table FND_EXECUTABLES.
    FND_EXECUTABLES is owned by APPLSYS schema.

    There is no contradiction between the best practice and the actual implementation. Tables must not & are not created in APPS schema.

    Views, Synonyms can be created in APPS Schema though, and this includes your custom views and custom synonyms.

    Thanks
    Anil Passi

     

    Anonymous Anonymous said ... (4:34 AM) : 

    ok. the example with the fmx is good but there is no connection between the fmx and the:
    a. Registering custom Conc Programs against Custom Applications.
    b. Registering custom Conc Program Executables against Custom Applications.
    c. Registering Custom Lookup Types against Custom Applications.
    d. Registering Custom Responsibilities against Custom Applications(HR can be exception, as some feature cease to work with Custmo Applications).
    e. Registering Flexfields against Custom Applications.

    all this are stored in tables that finally reside as you said in APPLSYS schema tables. if Oracle want to purge this base tables then we are not protected in any way. or we are ?

    if there is no table in APPS (Oracle view tables are also in another schema - APPLSYS) then it means that Oracle will not try to delete tables in APPS ?!

    why we are allowed to create procedures and views in APPS and not tables ? what is the difference ? beacause thinking at upgrade there is no difference between this type of objects ?

    thanks. i will try to make this the last question.

     

    Blogger Anil Passi said ... (4:57 AM) : 

    REMEMBER: Oracle reserves the right to delete AOL tables and rebuild AOL tables for all data under Std Applications.

    Your questions are in bold.
    They may not have executed their rights during previous upgrade cycles, but they reserve the right for doing so.

    There is no connection between the fmx and the Registering custom Conc Programs against Custom Applications.
    The link between Program and Application is via the executable.
    However also, what if you have a profile option defined against a Custom Application?
    If your conc program is not defined within Custom Application, fnd_profile will not return the correct value.
    Hence I say, please trust the what Oracle preaches for standard practice.

    b. Registering custom Conc Program Executables against Custom Applications.
    Same as above

    c. Registering Custom Lookup Types against Custom Applications.
    The primary key on table fnd_lookup_values is a combi of LOOKUP_TYPE & VIEW_APPLICATION_ID.
    Hope this answers...

    d. Registering Custom Responsibilities against Custom Applications(HR can be exception, as some feature cease to work with Custmo Applications).
    Again, it is the profile option sensitiveness.

    e. Registering Flexfields against Custom Applications.
    That is if you design and build new Flexfields. Out of the box Flexfields are pre-delivered in custom application.


    all this are stored in tables that finally reside as you said in APPLSYS schema tables. if Oracle want to purge this base tables then we are not protected in any way. or we are ?
    Oracle will purge the data in APPLSYS tables only if they want to loose all their existing customers. So they won't do it, trust them.

    if there is no table in APPS (Oracle view tables are also in another schema - APPLSYS) then it means that Oracle will not try to delete tables in APPS ?!
    There is no such thing called view tables! It is either a table or a view.

    why we are allowed to create procedures and views in APPS and not tables ? what is the difference ? beacause thinking at upgrade there is no difference between this type of objects ?
    Good question. But when you run concurrent programs, regardless of those being custom written or standard, Oracle connects to Apps schema to execute them.


    thanks. i will try to make this the last question.
    Not a problem, you can keep asking, unless you are clear on your queries.


    As a thumbrule, anything that contains data, will not be in APPS Schema.
    Package, View, Synonyms are either executable codes or references to data.

     

    Anonymous Anonymous said ... (5:52 AM) : 

    there is no way to to make a search case insensitive when the property is false ?

    I think I didn't explain well what it is not clear to me :
    in your reply to Aman you talk about things which finally reside in tables in APPLSYS. All the data for custom programs , etc goes to Oracle tables in APPLSYS.

    Aman was talking about creating tables in APPS.what is the link between what Aman was saying and your reply because you say : "The reasons cited by you apply to the below too" ?

    "There is no such thing called view tables! It is either a table or a view."
    YES -> I was talking about the tables on which the view is based/constructed.

    thanks

     

    Blogger Anil Passi said ... (6:13 AM) : 

    there is no way to to make a search case insensitive when the property is false ?
    Try doing so by using Forms Personalization. See the screenshot on the Link


    Aman was talking about creating tables in APPS.what is the link between what Aman was saying and your reply because you say : "The reasons cited by you apply to the below too" ?
    Aman said in theory you can do whatever you want, but that is not a good practice. He is correct in saying so, I 100% agree with Aman.


    "There is no such thing called view tables! It is either a table or a view."
    YES -> I was talking about the tables on which the view is based/constructed.
    No worries, I understand now, I wanted to ensure that there is no misconception.

     

    Blogger pravin said ... (4:46 AM) : 

    hi Anil,

    can u tell me what is form interface and web interface in apps?

    Thanks
    Pravin

     

    Blogger Anil Passi said ... (4:56 AM) : 

    Hi Pravin

    All the interfaces in Oracle Apps are web based interfaces.

    Even a D2k form is run through the browser, although a plugin called Jinitiator is used that is like a applet that runs within browser. Within that applet the D2k form runs.

    All new development in Oracle Apps is now taking place using OAF (Java Based Framework).
    But in Fusion, even OAF will cease to exist, but something similar will be used.

    My guess is that in Fusion UI will be based on :-
    1. ADF with Faces
    2. DHTML based pages similar to the technology used by Peopletools.

    Either way, Oracle will ensure that Fusion UI is as close as possible to Web 2.0

    Thanks
    anil passi

     

    Anonymous Anonymous said ... (10:54 PM) : 

    Hi anil can you publish a topic on Interface in oracle apps

     

    Anonymous Anonymous said ... (11:57 AM) : 

    Is there any way to distinguish the custom objects (schema, tables, veiw, procedures, triggers, forms, reports, ppl, etc) against the standard Oracle Apps Objects ??

    Dipen

     

    Blogger Anil Passi said ... (12:20 PM) : 

    Hi Dipen

    Your implementation must be having some naming standards.

    Hence your Views, synonyms & packages that reside in APPS Schema will have a specific naming convention of prefix.

    For tables, these will be in your custom schema.

    THanks,
    Anil

     

    Anonymous Anonymous said ... (5:49 PM) : 

    Hi anil,
    i have created a custom table in custom schema .granted rights and created synonyms in apps schema.i want to create a data block form based on this table.should i need to connect to custom schema to do it. or should i need to connect to apps schema and select build block based on the synonym created in apps
    thanks arun

     

    Blogger Anil Passi said ... (10:41 PM) : 

    Hi Arun

    With Oracle forms in Oracle ERP, you do not have to connect to any specific schema.

    Your form will be registered with Oracle ERP and hence to the menu via form function. Oracle will internally connect to APPS schema after you have logged in. Hence your Forms session will inherit that APPS connection automatically too.

    Thanks
    Anil

     

    Blogger Naa Tho Neenu said ... (1:23 AM) : 

    hai anil,
    can u plz post the aq's for apps dba.

     

    Blogger Punjali said ... (11:01 AM) : 

    Really Good Job Anil, I am very new to Oracle apps, I will be the regular visitor of this site

     

    Blogger Punjali said ... (11:02 AM) : 

    Hi Anil, Really a Good Job, I am very new to Oracle Apps, Your articles are reaaly useful to me

    Thanks
    Gopinath

     

    Blogger Ravi Saini said ... (12:44 AM) : 

    Hi
    Anil
    i am working as a apps technical. now i want to work on xml ,discover and some new technology in oracle apps tell me the way that i can make myself strong in oracle apps what is the new things in apps demended in market i want to do something unique in apps. please help tell me the step how can i preparing myself for the latest technologies. Ravi saini

     

    Blogger Ravi Saini said ... (12:49 AM) : 

    hi anil
    i am working as a apps technical conslulant, i want to work on xml, fusion, and discovrer please tell me the step that i can learn these technologies soon with sysmatic way. want to do something unique in field of apps help me i can do hard labour but i don't know the way......Ravi Saini

     

    Blogger Kaka said ... (2:48 AM) : 

    Hi Anil,

    Kudos on this very vibrant and dynamic blog.
    I am an Oracle techie and what i would like to see is how to track a transaction via various tables and interfaces e.g Procure to Pay process, Order-Ship-Bill process.
    Much appreciated.
    Cheers Mate

     

    Blogger Kaka said ... (2:52 AM) : 

    Hi Anil,
    Kudos on this blog, very informative and dynamic. What i'd like to see is how to track a transaction from start to finish via the various tables and interfaces in PO (Procure-to-Pay cycle) and OM (Order-ship-Bill cycle).

    Cheers

     

    Blogger Kaka said ... (2:53 AM) : 

    Hi Anil,
    Kudos on this blog, very informative and dynamic. What i'd like to see is how to track a transaction from start to finish via the various tables and interfaces in PO (Procure-to-Pay cycle) and OM (Order-ship-Bill cycle).

    Cheers

     

    Anonymous Anonymous said ... (3:41 AM) : 

    HI,

    i am trying to run standard purchase document open interface but it is showing output 0 bytes. with log request completed. and I can't find the data in base tables. In interface tables org_id is also set. Can u tell me what to do , Plz tell me immediately.

    Thanks
    Ganesh

     

    Blogger Anil Passi said ... (4:24 AM) : 

    Hi Ganesh

    Please run the sql trace for the process, and then execute the same set of sqls from sqlplus to see if it returns data

    Thanks,
    Anil

     

    Blogger Unknown said ... (4:43 AM) : 

    Great job anil

     

    Anonymous Anonymous said ... (4:44 AM) : 

    Great job Anil

     

    Anonymous Anonymous said ... (5:07 AM) : 

    Hi Anil,

    What type of synonyms can we defined in apps schema..is it a public or private.

    Thanks,
    Ahmed

     

    Blogger Unknown said ... (10:11 PM) : 

    Dear Anil

    This is Majid. I have been newly introduced to oracle apps the Q&A session is quit impressive and informative. Just one request if you can some time teach us the architecture and file structure of oracle apps where source and executable files are resided.

    Thanks

     

    Anonymous Anonymous said ... (11:47 PM) : 

    Nice work.......
    Specially for beginners....

    Thanks,
    Dhritiman Maitra

     

    Blogger ganesh said ... (10:15 PM) : 

    Hi anil,
    I seen this post.this is great one . But i want exact infrmation about the SAP & what is relationship defined by apps.
    Thanks
    Ganesh

     

    Anonymous Anonymous said ... (11:35 PM) : 

    hi anil,

    Can you tell me how to delete an inactive or disabled items in oracle apps like is there any option to purge the items.Can you mail me to this id chakri.kuna@gamil.com ..

     

    Blogger raghu-appsdba said ... (12:00 AM) : 

    hi,

    how can i backup FIP and ADDEFFERED TABLES?/

     

    Blogger raghu-appsdba said ... (12:07 AM) : 

    hi,

    how can i backup FIP and ADDEFFERED TABLES?/

     

    Blogger Rooba said ... (3:27 AM) : 

    hi,
    i am new to oracle platform.
    i know to write the queries.
    but in which prompt i will create or type the table query/
    i don't know the customized schema.
    hw to generate reports/

     

    Blogger Manju said ... (12:25 AM) : 

    Hi I am Manjunath I am working in IBM see i had got one interview i went & i geven interview but problom is there asking me in AL GP PO what kind of problom youu are facing i really dont know that can u help me pls.

    with regards
    manjunath

     

    Anonymous Anonymous said ... (10:26 AM) : 

    Hi Passil,

    I think there is a little type in your text.

    Hence if you have a pseudo report that joins ap_invoices_all table( in AP schema) to PO_HEADERS_ALL table( in AP schema), you will simply need to do the below once connected to APPS.

    It should be PO rigth ?

    Great blog by the way !

     

    Blogger Anil Passi said ... (10:53 AM) : 

    Hi Guillaume

    You are right, it should have been

    Hence if you have a pseudo report that joins ap_invoices_all table( in AP schema) to PO_HEADERS_ALL table( in PO schema), you will simply need to do the below once connected to APPS.

    Thanks,
    Anil Passi

     

    Blogger blesson said ... (12:10 PM) : 

    I have just started to learn Oracle Apps. With risk of sounding stupidy can i know some facts-

    As one mentionned
    "a. Registering custom Conc Programs against Custom Applications.
    b. Registering custom Conc Program Executables against Custom Applications.
    c. Registering Custom Lookup Types against Custom Applications.
    d. Registering Custom Responsibilities against Custom Applications(HR can be exception, as some feature cease to work with Custmo Applications).
    e. Registering Flexfields against Custom Applications.

    all this are stored in tables that finally reside as you said in APPLSYS schema tables."

    You said concurrent programs are stored in APPS then where does APPLSYS comes.

    Can you describe wat all object we keep in Custom schemas, APPS,and APPLYS?

    Thanks in advance.

     

    Blogger Anil Passi said ... (12:20 PM) : 

    a. Registering custom Conc Programs against Custom Applications.
    -->This is a good practice, otherwise Oracle may simply drop all the concurrent programs from Standard Application so as to re-design/re-build. Having said so, never in the history of apps has this happened


    b. Registering custom Conc Program Executables against Custom Applications.
    -->If you have SQL type conc program, it will reside in $XXPO_TOP/sql
    If you regsiter executable against Standard Application, then sql file must reside in $PO_TOP/sql
    Now of course, Oracle may decide to drop and rebuild all contents within $PO_TOP/sql. This is possible, hence the reason for registration of executables against custom app



    c. Registering Custom Lookup Types against Custom Applications.
    --> Similar to above two cases


    d. Registering Custom Responsibilities against Custom Applications(HR can be exception, as some feature cease to work with Custmo Applications).
    --> Restriction on HR was noticed due to some earlier bugs in 11.5.9. I suspect those have been resolved by now



    e. Registering Flexfields against Custom Applications.
    -->Only applies when you define DFF for custom forms



    All this are stored in tables that finally reside as you said in APPLSYS schema tables."
    --> APPS contains the synonyms to tables in APPLSYS, PO, AP etc




    Thanks,
    Anil Passi

     

    Anonymous Anonymous said ... (9:13 AM) : 

    Great Blog and very useful article.

    Just noticed a typo..

    “Hence if you have a pseudo report that joins ap_invoices_all table( in AP schema) to PO_HEADERS_ALL table( in AP schema).......“

    I think you meant- PO_HEADERS_ALL table( in PO schema)..

     

    Blogger Unknown said ... (12:13 AM) : 

    Hii
    Can u tell me in values set(Table Value Set) if i want to write a query with a distinct clause or query using an UNION clause then how should i write ....

     

    Anonymous Anonymous said ... (9:06 AM) : 

    hi anil, you are very helpfull. thanks a lot.
    can you please explain value sets,validations.

    thanks
    tibbu

     

    Blogger Unknown said ... (11:04 PM) : 

    Hey Anil,

    I am Kavitha and this is my first post. I have taken training in Oracle Apps Technical and attending interviews.

    I am facing issues while answering questions especially practical questions.

    can you please post some interview questions with possible explanations so that ppl like me can get benifitted???

    thanks in advance

     

    Blogger Anil Passi said ... (11:21 PM) : 

    Hi K

    Please refer to link below for technical interview questions

    http://apps2fusion.com/apps/apps/oracle-apps-interview-questions






    All the best with job interviews.

    Thanks,
    Anil Passi

     

    Blogger rama said ... (10:28 AM) : 

    hiiiiiiiii
    this is rama.i read ur answers.it is very gud.i have some doubts regarding oracle apps?can u tel me answers/

     

    Blogger rama said ... (10:32 AM) : 

    hi
    i am rama.ur answers are very clear.i wm new to apps.i have some doubts.can u clarify mmy doubts

     

    Anonymous Anonymous said ... (9:46 PM) : 

    Hi Anil,

    I have one custom schema where I have created custom tables, procedures, functions, packages
    and has given rights to apps schema. for tables you mention to create synonym what about for procedures, functions and packages.

    Regards

    Arun

     

    Blogger Anil Passi said ... (10:18 PM) : 

    Hi Arun

    Procedures, packages and functions must be created directly in apps schema

    Thanks,
    Anil Passi

     

    Anonymous Anonymous said ... (12:25 AM) : 

    Hi Anil,
    I am begineer in Oracle Apps.I wan to begin to learn technical things in Apps.So what be my approach to learn technical things in apps.

    regards
    Vinay

     

    Anonymous Anonymous said ... (1:22 AM) : 

    Hi Kanvik
    Answer for your queries

    Use the select statement with distinct clause within brackets as the table name in value set definition
    Example
    table name : (selet distinct x from xyz)
    table name :(select x from xyz union select y from abc)

    Regards
    Mohan

     

    Anonymous Anonymous said ... (8:07 AM) : 

    Hi Anil,

    I am working as a developer in Legacy technology for the past 7 years. I would like to shift to a different technology. Earlier I searched your blogs and found the way to start so I have learned PL/SQL by reading the documents. But some of my friends suggested to learn Oracle Fusion instead of Oracle Apps Technical, also some suggested to learn Oracle Apps DBA.

    I am totally confused and pondering to make a better decision and go for a trainnig class.

    I am a novice to Oracle, so anything is a fresh start.

    Do you think should I learn Oracle Apps Techinical or Oracle Fusion or Oracle Apps DBA?

    Could you please suggest me on this?

    Thanks
    Suresh

     

    Blogger Anil Passi said ... (12:02 PM) : 

    Start learning SQL, PL/SQL and then BPEL/SOA and then ADF.

    That is the direction Oracle Product is going.

    Invest for future, dont invest in past technologies.

    Give yourself One Year timeframe to make this shift. But learn a lot during that time. You will make it. Dont look for shortcuts.
    Invest one full year in practising these technologies. Thereafter getting a job in Oracle Fusion will be much easy. There wont be many consultants with the desired skillsets in western world when Fusion comes out.

    If you get job in Fusion related project earlier than 2years, then well and good.
    Good luck
    Anil Passi

     

    Blogger madhu said ... (7:30 AM) : 

    hii is there any method to find the ip address

     

    Blogger madhu said ... (10:13 PM) : 

    how to find the ip address of the system while logging into the oracle application

     

    Blogger davis said ... (4:34 PM) : 

    Hi Anil

    Thanks for your posts and all the materials seems to be pretty good, i am student and i don't have an Real Time experience and planning to take a training on Oracle financial. So do think the training will help me to get the enough knowledge.

    Thanks
    Dilip

     

    Blogger Prasanth said ... (3:25 AM) : 

    Hi Anil,
    I have an error in PO-AP module while practicing, i.e, 'GL date is not in the period time'.
    Please give me the answer for that question, how to rectify it?

     

    Blogger Mohammed Taqui said ... (12:11 PM) : 

    Hi, This is Mohammed & i want to know that what will be the questions asked in the interview to an oracle apps scm functional consultant while he is a fresher.

     

    Blogger Prosenjit Manna said ... (10:09 AM) : 

    Hi Anil
    This is Prosenjit.First of all I would like to thanks for your wonderful job.This is really helpful.

    However I have a simple question.What does it mean the different modules of Oracle Apps.Are they Oracle Financial,HRMS,SCM or some other thing.
    Please do let me know

     

    Blogger Chaitanya Kobula said ... (10:09 AM) : 

    Hi Anil,

    I am a Oracle Apps Developer and have been working in Oracle Apps for past 2+ Years. I should say you are the master of Oracle Apps. When ever i face any issue, my first thought is to search in your site/blog and for sue i found the answers and solutions!!

    You simply rock!

    Regards,
    Chaitanya

     

    Anonymous Anonymous said ... (3:47 AM) : 

    hi anil,
    i dont know anything about oracle apps but i know pl/sql. i want to learn oracle apps. luckily i got your blog. iam following your blog. can you help me by providing the course material if you have. thank you. and one more thing i want to know the installation process of oracle apps. please kindly help me . thank you.

     

    Anonymous Anonymous said ... (9:00 AM) : 

    hi, i need some information on Aol.. plz

     

    Anonymous Anonymous said ... (7:37 PM) : 

    Hi Anil,
    I have taken an Apps Technical Consultant Course recently. Can u give some tips to make myself stand in apps demamded market.

     

    Blogger Rajesh said ... (11:17 PM) : 

    Hi,
    I am a fresher in oracle apps , i had series of trainings on sql , pl/sql ,reports,xmlp,OAF and had a little bit hands-on in using some API's(OM,HRMS).now i'm 8 months exp. still i don't know what technology is good for me to go ahead. Can i have a good oppurtunities a head with these technologies .

     

    Anonymous Anonymous said ... (8:23 AM) : 

    how can i query through oracle erp applications forms using mathematical operators , logical operators and conditional operators?do have a manual for that ?

     

    Blogger Ahamed Ashik said ... (1:36 PM) : 

    Hi Anil,
    Excellent job!!!!


    Cheers,
    Ahamed Ashik

     

    Anonymous Anonymous said ... (1:38 PM) : 

    Hi Anil,
    Excellent job!!!

    Cheers,
    Ahamed Ashik

     

    Blogger Zombie said ... (12:18 PM) : 

    Wish to Catch you someday in person.

    really helpful inputs.

    -Animesh

     

    post a comment