Monday, October 09, 2006

What happens when you login to Apps?

Firstly and surely there is a URL for oracle applications that is structured possibly in below format, although it can vary from version of apps.
http://machinename:portnumber/OA_HTML/US/ICXINDEX.htm
http://machinename:portnumber /oa_servlets/AppsLogin

When you join an Oracle Apps development team for an employer, you will first be given URL of the development environment.

In any Oracle Apps implementation project (assuming it has gone live), there are minimum of three environments, each with different URL's and different database instances.

These are:-
---------------
Development environment
Testing environment
Production environment

You will most probably, as a techie, be given url,username ad password of the development environment.

What happens when you login(no advanced info here):-
--------------------------------------
A. Your login gets authenticated against a table named fnd_user for your username and password. The screen below is where username and password defined. This screen is called user definition screen. Only system administrators have access to this screen.

B. As you can see above, this username xxpassi is attached to two responsibilities (this will be discussed in details in latter training lesson). It is this assignment to the responsibility that controls what a logged in person can do and can't do. In layman’s words, a responsibility is a group of menu.


C. When you successfully login you will see below screens.

This screen below will prompt you to change your password, to a value different than that assigned by System Administrator.








Click on either of the above Responsibility Names, will initiate Oracle Apps( Note: You might be prompted to install jinitiator…..just keep clicking OK…OK for all Jinitiator messages). Effectively, what I mean to say is that you do not need to download jinitiator from anywhere; Oracle will do this automatically (provided your DBA’s got this cofig’ed) for you during your first logon attempt from the PC. Once your jInitiator gets installed








Hurray, we have logged into apps.

Some notes on advanced info (beginners may ignore this):
Oracle internally uses a login named GUEST, prior to invoking validation of actual username. Some people regard this as a security threat, but it isn’t. Your DBA’s can change the “guest” password from its default value after installation.

Oracle uses a DB User account named applsyspub to which it first connects during validation of LOGIN. This user account has very restricted privileges and has access to below objects (primarily for authentication purposes):-
FND_APPLICATION
FND_UNSUCCESSFUL_LOGINS
FND_SESSIONS
FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_GROUPS
FND_MESSAGES
FND_LANGUAGES_TL
FND_APPLICATION_TL
FND_APPLICATION_VL
FND_LANGUAGES_VL
FND_SIGNON
FND_PUB_MESSAGE
FND_WEBFILEPUB
FND_DISCONNECTED
FND_MESSAGE
FND_SECURITY_PKG
FND_LOOKUPS

113 comments:

  1. Anonymous1:32 AM

    Hello,

    very interesting blog. I have a small question : what does it mean fnd from fnd_messages for example ?

    ReplyDelete
  2. Hi anonymous,

    FND_MESSAGES is a table where Oracle stores all the messages...for example...
    "Are you sure you wish to continue?"
    ...
    "Your Password has expired"...

    Each such message has a code.
    For example, FND_PASSWD_EXPIRED code has text "Your Password has expired" attached to it.

    Many a times you wish to change the text of the messages, for which Oracle delivers a screen to maintain message texts.

    Thanks,
    Anil Passi

    ReplyDelete
  3. Anonymous4:00 AM

    Hello Anil,

    thanks for the answer altough it is not what I was looking for. I was wondering where does it come from FND ? it is an abbreviation for what ?

    thanks,

    ReplyDelete
  4. Hi Florin,

    Now I understand your question fully.

    FND means Foundation. It means, this is the schema where all the foundation/"apps tech stack" tables are created.

    For example, following entities can be classified as Foundation to apps.1
    1. Apps Security related tables, to name a few FND_USER, FND_SECURITY_GROUPS etc...


    2. Apps validation related tables, like FND_FLEX_VALUES, FND_FLEX_VALIDATION_EVENTS

    3. All the workflow related tables...

    4. Concurrent manager related tables....

    Thanks
    Anil

    ReplyDelete
  5. Hi Kishore

    GUEST is a special user, albeit a nasty one.

    By default, its password is oracle.
    And not many clients change that password after their install.

    External Web facing SelfService pages (example forgot page connects to GUEST schema)...hopefully oracle would have fixed this...one of my clients regarded this as security threat to apps

    ReplyDelete
  6. Hi Anil,

    Can you please tell me is there link which you have added for article on Function/Menus/Submenu and Responsibilty

    I want to know when when i create Functtion/menus/Sub menu in which tables data for these things get stores.

    Can I attach more than one menu to one responsbilty?

    Thanks
    Mukesh

    ReplyDelete
  7. Anonymous8:51 AM

    hi anil
    very good job .really it is very useful .please can u guide me i am planning to aplly for oracle hrms funcational consultant role in uk .do u guide me some interview questions r tips please .
    thanks bye

    ReplyDelete
  8. hi reddy,

    these days I am writing on Oracle HRMS and Payroll, both technical and functional articles.

    Those can be accessed from http://oracle.anilpassi.com

    Thanks
    Anil Passi

    ReplyDelete
  9. Anonymous12:08 AM

    Hi Anil ji,
    ur website is really good,As u r providing lots of solutions to all the people,i think my problem also will be solved,
    Actually i have installed oracle Apps 11i in my PC,i successfully logged with operations &welcome as usrnme & password,but when i switch to the system administrator responsibility there when i click on the user:define to define a user, teh form is not at all opening,not only that form im unable to open any of the forms in that respponsibility,i then checked whether Jinitiator was installed or not but i came to know that when we logon in Apps Jinitiator will be automatically installed, plz giv me a solution how can i open the forms!

    ReplyDelete
  10. Anonymous11:46 PM

    Hi Anil,

    How is per_people_f different from per_all_people_f.

    Can you please help me on this.

    Regards,

    ReplyDelete
  11. Hi there

    This has been explained in HRMS Articles. See the one related to security on
    http://oracle.anilpassi.com

    ReplyDelete
  12. Anonymous6:17 AM

    hi Anil,
    Nice blog. I really apprciate for your initiative.

    ReplyDelete
  13. Anonymous6:18 AM

    hi Anil,
    Nice blog. I really apprciate for your initiative.

    ReplyDelete
  14. Anonymous6:31 AM

    Hi Anil,

    I am very new for Apps. So,I am going to ask you few questions, which might be very easy/silly to u. But, pls explain me.

    1. Why do we need Apps in reality? Normally To develope a Form or Report in Apps, we need to do it in D2k and need to move them to Apps. Insted of that can't we develope the same project using Oracle & D2K only?

    2. Why do we need to create first Executable, next Conc Prog, next Resp, Requestgroup, user and SRS window to submit a concurrent program. Why do we need all to submit a single concurrent program. It's really wasting time to submit a very small report also. Can't I direcly run a report from one single window in Apps?

    Plese dont ignore, as I am confusing with all these doubts.

    Thanks and Rgds,
    Mahesh

    ReplyDelete
  15. Anonymous6:33 AM

    Hi Anil,

    I am very new for Apps. So,I am going to ask you few questions, which might be very easy/silly to u. But, pls explain me.

    1. Why do we need Apps in reality? Normally To develope a Form or Report in Apps, we need to do it in D2k and need to move them to Apps. Insted of that can't we develope the same project using Oracle & D2K only?

    2. Why do we need to create first Executable, next Conc Prog, next Resp, Requestgroup, user and SRS window to submit a concurrent program. Why do we need all to submit a single concurrent program. It's really wasting time to submit a very small report also. Can't I direcly run a report from one single window in Apps?

    Plese dont ignore, as I am confusing with all these doubts.

    Thanks and Rgds,
    Mahesh

    ReplyDelete
  16. Hi Anil
    you have done a great job for Oracle Apps techies.
    can you tell me what is _VL & _TL means and when it is used?
    thanks
    asit

    ReplyDelete
  17. Hi Anil
    You have done a remarkable job for Oracle Apps techies.
    can you help me to understand what is _VL & _TL table. also when it is used.

    ReplyDelete
  18. Anonymous5:25 AM

    hi..

    answer the previous question

    ReplyDelete
  19. Hi Mahesh,

    In answer to your questions.....
    1. Why do we need Apps in reality?
    APPS is the database schema, where synonyms to all the objects exit[ragardless of the module]
    Effectively APPS provides a runtime environment.
    Leaving your development just on d2k will restrict the usage of what you develop just to your PC.


    2. Why do we need to create first Executable, next Conc Prog, next Resp, Requestgroup, user and SRS window to submit a concurrent program. Why do we need all to submit a single concurrent program. It's really wasting time to submit a very small report also. Can't I direcly run a report from one single window in Apps?
    You can run directly from a Single Window, which is named "Submit Request".
    The roles of various pieces are:-

    executable
    to find location of code on server to be executed
    but for pl/sql its always APPS schema

    request group
    these are attached to responsibilities
    say you have two resopnsibilities
    Payroll Clerk
    Payroll Manager
    Payroll manager responsibility in this case should have access to much more reports that Payroll Clerk
    Hence you will have two different request groups in this case.
    Each request group will have respective concurrent programs included into them

    thanks
    anil

    ReplyDelete
  20. Hi Anil,

    I am very new to oracle applications world.Presently i am working with Leading IT company.
    I am working on PN(Property Manager) Module.Please let me know which module set should i concentrate Finicals , HRMS, CRM etc.One more thing that i am from science backgroungd so feel difficult to understand these Bussiness term.please let me know which set of module mostly working on.

    Thanks
    Shiril

    ReplyDelete
  21. Anonymous10:20 PM

    Hi Anil,
    could u brief on the use of FND_LOOKUPS in ORacle APPS?

    Thanks and Regards
    Mary

    ReplyDelete
  22. Anonymous2:04 AM

    what is URL

    ReplyDelete
  23. Hi Anil
    Really this site is very informative.I came to know about it from a friend.
    Well I am working in an IT firm as an oracle Apps Consultant in HRMS module.But i am totally new in this APPS field.
    Previously i was working as a Oracle D2k developer,I have also completed my OCP certification in developer track.So I have No idea about oracle Apps as such nor do i have taken any training.
    They have recruited me for support job in oracle apps and they will gradually move me to developement.
    So,i will like to ask you how should i plan my trainings so that i can quickly move to development.
    I have acess to oracle apps front end almost to all the responsibilities on development and test enviorment.
    So I can do any R&D i like.
    I just need your guidence.
    Like from where to start and what should be the next step.
    I will be really greatful to you.
    Thanks
    Prasenjit Dash

    ReplyDelete
  24. Hi Anil,

    I was going through the list which is given by you regarding the FND Tables.
    Please let me know the difference between the tables:
    FND_APPLICATION
    FND_APPLICATION_TL
    FND_APPLICATION_VL
    and
    FND_LANGUAGES_TL
    FND_LANGUAGES_VL
    and
    FND_MESSAGE
    FND_MESSAGES
    AND
    For what purpose are the following tables used for?
    FND_SIGNON
    FND_PUB_MESSAGE
    FND_WEBFILEPUB
    FND_DISCONNECTED
    FND_MESSAGE
    and the pkg:
    FND_SECURITY_PKG

    Regards,
    Anuj Malhotra

    ReplyDelete
  25. Hi Anil,
    I was going through the list of table names which you mentioned and I am bit confused about some of the tables mentioned in the list.
    Please let me know what the is difference between the folowing tables and for what purpose they are used for:

    FND_APPLICATION
    FND_APPLICATION_TL
    FND_APPLICATION_VL
    --AND--
    FND_LANGUAGES_VL
    FND_LANGUAGES_TL
    --AND--
    FND_MESSAGES
    FND_MESSAGE
    --AND--
    FND_SIGNON
    FND_PUB_MESSAGE
    FND_WEBFILEPUB
    FND_DISCONNECTED
    FND_MESSAGE
    ----AND----
    The pkg name:
    FND_SECURITY_PKG

    Regards,

    Anuj Malhotra

    ReplyDelete
  26. Hi Anil,
    I was going through the list of table names which you mentioned and I am bit confused about some of the tables mentioned in the list.
    Please let me know what the is difference between the folowing tables and for what purpose they are used for:

    FND_APPLICATION
    FND_APPLICATION_TL
    FND_APPLICATION_VL
    --AND--
    FND_LANGUAGES_VL
    FND_LANGUAGES_TL
    --AND--
    FND_MESSAGES
    FND_MESSAGE
    --AND--
    FND_SIGNON
    FND_PUB_MESSAGE
    FND_WEBFILEPUB
    FND_DISCONNECTED
    FND_MESSAGE
    ----AND----
    The pkg name:
    FND_SECURITY_PKG

    Regards,

    Anuj Malhotra

    ReplyDelete
  27. Hi Anuj,

    If your client has 2 languages [Oracle Apps being used in both US- and germany-DE]
    n that case, if user logs in from US responsibility, then they should see descriptions in English, whereas person logging in from German responsibility must see the description in German language.

    Hence, in FND_APPLICATION_TL you will have 2 records[one for each language]

    Record 1....LANGUAGE:- DE
    Record 1....APPLICATION_NAME:-Oracle Kaufen
    Record 1....APPLICATION_ID:-10001 [assume]

    Record 2....LANGUAGE:- US
    Record 2....APPLICATION_NAME:-Oracle Purchasing
    Record 2....APPLICATION_ID:-10001 [assume]


    FND_APPLICATION will not store the Application Name.
    Hence it will simply store FND_APPLICATION = 10001


    FND_APPLICATION_VL is a view. It will look at applicable language for the current logged in user, and display the relevant description from either "Record 1" or "Record 2" depending upon whether user is logged in from "German Responsibility" or "US responsiblity".

    Thanks,
    Anil Passi

    ReplyDelete
  28. Hi Anil,
    Thanks for ur Reply. Well what about the usage of following tables?
    FND_SIGNON
    FND_PUB_MESSAGE
    FND_WEBFILEPUB
    FND_DISCONNECTED
    FND_MESSAGE
    Regards,

    Anuj

    ReplyDelete
  29. Hi Anil,

    Can you please explain how the view does the validation of the language for the current user. How would it differntiate.

    Thanks,
    Kishore Kantamneni

    FND_APPLICATION_VL is a view. It will look at applicable language for the current logged in user, and display the relevant description from either "Record 1" or "Record 2" depending upon whether user is logged in from "German Responsibility" or "US responsiblity".

    ReplyDelete
  30. Hi Anil,

    In your post, you said that
    1. Oracle internally uses a login name GUEST, prior to invoking validation of actual username
    2. Oracle uses a DB User account named applsyspub to which it first connects during validation of LOGIN.

    Can you please elaborate on these two points as I am a bit confused.

    ReplyDelete
  31. Hi, This is venkat.

    Here there is an issue in running indian payroll. We submitted requests yesterday at 06.00PM for 1200 employees in 3 batches. But, still it is running and didn't show any error message. Also, we checked up the employee list in "people - enter and maintain" to verify whether it is processing or not. We found no record is updated

    Can you please guide me in this regard?

    Thanks & Regards
    Venkat

    ReplyDelete
  32. I hope you ran the gathered statistics for the entire schema, so that cost boased optimizer can build the correct explain path.

    Try running the payroll with debug enaled. You will see where it is getting stuck.

    Alternaely, your DBA can enable trace of the currently running ongoing concurrent request. this will tell you where it is running slowly

    ReplyDelete
  33. Anonymous11:54 PM

    Helloo Everyone ,
    Can any one tell me how can i find the language which i am logging by , for programatic reason.
    by other mean , how oracle know the current language to display the relevant data .
    Ex: when am logging US displaying English data and when i am logging DE displaying germany .
    (i can imagin there is function returning the current language depending on the current session information .)
    your accurate replies highly appreciated .

    ReplyDelete
  34. Anonymous3:36 AM

    Hi Anil,
    Can u please expalin me teh useage of srw.message given in Oracle Reports?

    Thank You,
    Maggi.

    ReplyDelete
  35. Hi Maggi

    when you use srw.message, then that message appears in the log file of the concurrent request.

    As you would know, reports are submitted as concurrent programs in Oracle Apps. For debugging things like Report Triggers or Fast Formulas, you can induce messages using srw.message, and those messages then appear in the log file of the concurrent request.

    Thanks,
    Anil Passi

    ReplyDelete
  36. Anonymous5:59 PM

    Hi Anil,
    Great blog and a great site. God bless you for a such a wonderfull job.

    You mentioned taht when you use srw.message, then that message appears in the log file.

    My question is where can I find the log file?

    Thanks,
    Venkat

    ReplyDelete
  37. When you submit the concurrent program[report], after it completes, in the concurrent request monitor screen, there is a button labelled log. you need to click there to see the messages.

    This log file physically resides on the Server where the concurrent manager is running, which most probably will be on database tier. Go to directory $APPLCSF/$APPLLOG

    ReplyDelete
  38. Anonymous4:26 PM

    Thanks a lot Anil, helps beginners a lot. Thanks !!

    ReplyDelete
  39. waiting for your reply anil

    -Gautham
    gau.official@gmail.com

    ReplyDelete
  40. Anil,
    I m currently wrkng as a functional consultant. i would like to gradually move into technical domain. As i went thro ur blog, i felt i need to know oracle pl/sql ,forms, reports etc to shift.

    Hence would like u to pls mail me some pdf tutorials on forms, reports . Also i would like to know if i need to know both forms & reports in detail

    Gautham
    gau.official@gmail.com

    ReplyDelete
  41. Anonymous1:30 AM

    I am having more than 10 yrs of exposure with Oracle,forms,reports,system design etc., would like to move as Oracle apps techy, can you refer some institute in India WHO provides training on that? Also can you let me know if any automotive specific module is available in oracle apps?

    Regards

    Kalyan Mitra

    ReplyDelete
  42. Anonymous1:37 AM

    thanks anil.. good one..


    Yusuf

    ReplyDelete
  43. Anonymous12:51 AM

    Hi Anil,

    Simply Great ! very very helpful for biginers.

    Thanks,
    Shree

    ReplyDelete
  44. Anonymous6:08 AM

    Hi Anil,
    First of all let me thank u for ur blog.

    Iam new to Oracle Apps and im basically a Java programmer.

    I want to know where java code resides in Oracle Apps.

    Plz help me.

    Thanks
    Srinivas.

    ReplyDelete
  45. Hello all
    i am asvini, i am in US i am plan to learn oracle apps. please tell me which module is best one either functional or technical, what is the root map, i am very well know oracle db but new to apps.

    to learn oracle apps functinal module do i need to know any pre requestes

    please help me any one
    regards
    ash

    ReplyDelete
  46. hi anil,
    i am new to this Apps environment but
    want to make the carrier in the same.
    So give me the carrier path as a techie.

    Thanks.
    Pavan

    ReplyDelete
  47. OK, if you are yet to start, then learn two things

    1. APPS Architecture Basics, and its development practices
    2. Get solid grip on SQL
    3. In tech field, learn Java,XML and WebsServices. This is where Oracle Fusion is heading towards

    Using knowledge of 2&3, practice the toolsets like jDeveloper.

    In future, most of the development tools in Fusion Apps will be integrated with jDeveloper
    Thanks,
    Anil

    ReplyDelete
  48. Anonymous4:51 AM

    Hi i have just completed my Masters in IT and have done training for Oracle Apps in GL,AP,AR and Iexpenses. I want to start my career in it. so please can u suggest me should i apply as a freshers or show some fake experience. if so what type of experience should i show. please guide me through.it is question of my career

    ReplyDelete
  49. Anonymous5:29 AM

    Hi Anil

    I am new to Oracle Apps and currently working as a Technical Writer in ETL Domain. I am a graduate in English and willing to switch on to Oracle Apps HRMS (Functional). Could you please guide me the right ways to begin with?

    ReplyDelete
  50. Hi Anil,you r doind a greate jpb.here i want informatipon on performance tuning in reports and interfaces like?

    ReplyDelete
  51. Anonymous8:30 AM

    There are few ICX tables in which data gets populated when the users logs into Oracle Apps.
    Ex:ICX_SESSIONS

    Thanks,
    --Sunil

    ReplyDelete
  52. Anil,
    I have a question.

    We have certain conc.requests. These requests can be submitted only certain users (say USER_A).

    USER_B also having similar respponsibilities like USER_A. But still he can't submit it successfully. He can see the conc. request in Submit window. But he can't run it.

    What could be the reason. How can I find root cause for this behaviour.? Any special profile settings - set for USER_A. ?

    Chandra

    ReplyDelete
  53. Hi Anil,

    In your post, you said that
    1. Oracle internally uses a login name GUEST, prior to invoking validation of actual username
    2. Oracle uses a DB User account named applsyspub to which it first connects during validation of LOGIN.

    Can you please elaborate on these two points as I am a bit confused.

    ReplyDelete
  54. Anonymous7:31 AM

    Hi Anil,
    I have Installed Oracle Apps 11.5.9 on my machine.
    It got installed without any error. But when i try to log in
    (http://localhost.localdomain:8000) for the first time with SYSADMIN / SYSADMIN it goes to change Password Page with an Error: "You do not have a current Session. Please log in before visting this URL."
    when i try to log in using MFG/WELCOME it gives an "Java Exception ".
    do i need to change any settings ?
    Please let me know. thanks

    ReplyDelete
  55. Anonymous4:52 AM

    Hi Anil,

    VERY USEFUL SITE.

    When you login from browser, which files on Application server are executed or referred to.

    Gibbs

    ReplyDelete
  56. Dear Anil,

    Great job. I am just learning Oracle Apps and my company specializes in Oracle ERP and related Supply chain products. I am basically a System Admin in-charge of IT, but my aim is to expand and there is unlimited scope in my company, but I need to start from scratch and there are not much training going on from scratch. Most the guys recruited in this have some manufacturing experience. Can you also please direct me to some audio-video resources on the internet. I have a metalink account,
    Thanks,
    Srinivas

    ReplyDelete
  57. Anonymous5:41 AM

    hi anil
    this is good blog for beginer

    ReplyDelete
  58. Anonymous5:43 AM

    hi anil
    this is good blog.

    ReplyDelete
  59. Hi Anil
    u r work is excellent presently iam workingon APPS CRM dou have any info regarding Service...Support etc

    nith

    ReplyDelete
  60. Anonymous9:51 PM

    Hi Anil,
    This my very first comment on our blogger site. I am preparing for oracle certification for the first paper so i need ur help. I hope u will guide me .
    Thanks

    ReplyDelete
  61. Hi Anil,
    I like this blog very much,But now i want some detial information about the Jinitiator.
    Thanks

    ReplyDelete
  62. Anonymous1:44 AM

    Hi Anil,
    I have a critical doubt in Forms.

    A message window is popped up for alerts and warnings which asks us for ok or Yes and No or cancel.

    1)The pop window does not allow us to do anything else other than pressing any of the buttons of the Pop up window.

    Question: How does the FND_Message (which generates the Pop up window) get to know whether any button on the pop up window is pressed or not .

    This is urgent .
    Please help .
    Thanks.

    ReplyDelete
  63. Anonymous2:31 AM

    Hi Anil,
    I have a critical doubt in Forms.

    A message window is popped up for alerts and warnings which asks us for ok or Yes and No or cancel.

    1)The pop window does not allow us to do anything else other than pressing any of the buttons of the Pop up window.

    Question: How does the FND_Message (which generates the Pop up window) get to know whether any button on the pop up window is pressed or not .

    This is urgent .
    Please help .
    Thanks.

    ReplyDelete
  64. Anonymous1:52 PM

    Hi Anil,

    Could you please explain..
    what does FCP in FCP_LOGIN stand for?

    Thanks in advance
    Anita

    ReplyDelete
  65. Anonymous8:15 PM

    Hi Anil
    I appreciate UR talent.

    Why are you teaching all this knowledge which U acquired from years of hard work to these kids ??

    Its like spoon feeding to them.
    and making them lazy and arrogant guys out in the industry.
    Let them prove by hard working.

    Tean them how to fish not a fish

    thanks

    ReplyDelete
  66. HI Anil,
    Thank you for your support and greatful to you .

    Can you do something for us in PL/SQL ? I am feeling difficult in understanding these logics in programming . Can you giveus some ides how to understand it easier and get better in Programming .

    ReplyDelete
  67. Anonymous3:31 PM

    Hi anil,
    I was trained on apps previously in india,and i missd my notes.Can u plz tell me how to enable security.Iam unable to recollect the path.We use %User% ...profile options..

    ReplyDelete
  68. Anonymous12:50 AM

    i need syntax to show mesages by fnd_messages in my program.
    What is the syntax?

    ReplyDelete
  69. Anonymous10:08 PM

    Hello Anil passi,

    This is sekar.you have done a remarkable job for all those who are in getting doubht.

    thank you

    as am totally new to oracle , can u please suggest me how can i improve it?

    am working as a oracle DBA and also in APPS too.

    how can i improve it ?

    please give me reply sir,


    thanks and regards,
    sekar

    ReplyDelete
  70. Anonymous7:38 AM

    hi anil
    can u explain the applications architecture request flow

    ReplyDelete
  71. Anonymous7:37 AM

    Hi Anil,

    is it possible to switch user within oracle application environment without logging out of the session, i am planning it as my GB project, can you raise some help on it.

    Thanks,
    Neeladri

    ReplyDelete
  72. This is not recommended, because you will need to call fnd_global.initialize and also alter ICX_SESSIONS entry

    However, if in OA Framework, Look at methods in OAPageContext, there is a method to switch context programatically in controller

    Thanks
    Anil

    ReplyDelete
  73. Anonymous12:15 AM

    Hi Anil,
    I just had a look at the dbc file of one of our instances. i could find the guest un/password over there. But while i try connecting to the database using sqlplus/toad using the tns entries with the uname/pword specified in the dbc file, it says that the uname and password is invalid. Are there any restrictions on the same?

    ReplyDelete
  74. Anonymous12:34 AM

    I have been working in IT for last
    20 years. I have been involved in customized development of Financial Accounting, Fixed Assets,
    Inventory, Payroll etc. I have developed these systems on various platofrms like COBOL, UNIFY/ACCEL,
    Informix, Oracle & D2K. Now my management wants me to shift to Oracle Apps (Fianacials). At this stage there is slight hesitation in my mind to learn new environment. Please advise.

    ReplyDelete
  75. Hi Anil,

    I am an Oracle Apps technical Consultant working for an IT company.

    However,Recently I sat for an Interview for one of the major Global Consulting Gaints where the interviewer gave me a reply that you are an Oracle Guy but not an Oracle Apps Guy.
    As such for the past two days I was anxious to know the difference of the two and am glad to hit upon your blog.

    I will keep myself updated with your site and lets hope i clear forthcoming ones

    ReplyDelete
  76. Hi Anil,

    I am an Oracle Apps technical Consultant working for an IT company.

    However,Recently I sat for an Interview for one of the major Global Consulting Gaints where the interviewer gave me a reply that you are an Oracle Guy but not an Oracle Apps Guy.
    As such for the past two days I was anxious to know the difference of the two and am glad to hit upon your blog.

    I will keep myself updated with your site and lets hope i clear forthcoming ones

    ReplyDelete
  77. Hi anil
    i have a question
    suppose we are creating some set of forms(oracle apps) and first form is like login form. in that form the user needs to give usercode , the usercode is not available in the database means it will ask to create a new user(like new customers in AR).
    when creating new user, the user will enter 4 fields of data which is more important and we dont want to display when we see the table in backend. i mean to say how to encript the data(not readable) from backend?.
    what are settings we need to do for that 4 fields while creating a oracle apps form.

    thanks
    umapathy

    ReplyDelete
  78. Anonymous12:19 AM

    Hi Anil

    I came across ur site through my friends.
    I am working in an IT company for last 4 & 1/2 yrs. and worked on programming in mainframe technologies and Testing (independent of technologies) on Web, DWH & mainframe applications. I have previously worked in core engineering industry for close to 3 & 1/2 years. I have a good business understanding functionally in manufacturing & SCM domains. I wish to switch my career in Oracle Apps functional role. I do not have knowledge on Oracle or Oracle Apps. How should I start & what should be my next steps? Please advise.
    Thanks & Regards,
    Mandar

    ReplyDelete
  79. Hi Anil , I'm trying to imbibe myself in oracle apps technical. recently i've completed my in oracle apps technical course. I would appreciate, if you help me with some reference manual to understand the complete flow of work in any financial module and what all customization a developer does . In a nutshell, if you can share some live project with all the customization you did.

    ReplyDelete
  80. Anonymous2:49 AM

    hi anil,

    You have a wonderful site, helped me a lot in terms of understanding quiet a few fundamental question.
    I had small question which I would be gr8ful if you could address.
    I am working a oracle apps CRM functional consultant for the past 2 years now.
    I have developed my understanding of oracle apps only with the help of one on one sessions and a few user and implementation guides.
    I wanted to know is that what is the processed to be followed for getting a sound understanding of the application. I mean If I focus on CRM service side first what all published user/implementation guides should i go through in all to get full functional concepts of the same and what should be the order of the same ie do i read contract first or teleservice first.

    Keep the good work
    Vivek

    ReplyDelete
  81. Anonymous10:01 PM

    Hi Anil
    very interesting blog
    thank you

    ReplyDelete
  82. Anonymous2:51 AM

    I can just say EAST or WEST.
    Anil and Team is BEST.

    Thanks for helping too many developers

    ReplyDelete
  83. Anonymous3:12 AM

    Hi Anil,

    In Oracle APPS some of screens showing the System Logon and Terminal details in REcords History.

    Some of screens not displaying. Pl. let me know how to display those details.

    Thanks in advance.

    ReplyDelete
  84. Hi Anil,
    Actually i want to establish my carrier in Oracle Apps, infact i have 2 years of experience in Distribution Module but due to some personal reason i quite job form Oracle now day i consulting for SAP and take care of Sales activities.But my full interest to build my carrier in Oracle itself .will u please guide me to who i contact and do a good course in Oracle
    My native town is Pune ..

    ReplyDelete
  85. hi anil,
    im ramadevi.i sent comment to u but it was not display .how to enter ur forum to ask doubts plz tel me

    ReplyDelete
  86. Hi, Anil, I really appreciate your efforts. My questions are some what different from others, I've read almost all the messages and replies. Ok, Let me ask my questions,but I want to tell you one thing that I'm working for Satyam Computers Limited from past almost 2 yrs on Oracle technologies and joined as a fresher, got tranings like SQL, PL/SQL, Forms and Reports and 5 days Apps training and undergoing OAF training. continue...........

    ReplyDelete
  87. This comment has been removed by a blog administrator.

    ReplyDelete
  88. Hi CEO

    I got your message, have sent you an email.

    Thanks,
    Anil

    ReplyDelete
  89. hi anil iam jana from abudhabi
    i joined petrochemical construction company before i have worked in chennai as a apps techie
    consultantsites odc but now i joined in direct client based , here some of the dept
    using apps but iam in planning dept they told to develop ite's own erp forms and reports, already
    using own erp in Ms acess ther told to study the bps bussiness process study .this is my first experience iam working in direct client.

    ReplyDelete
  90. Hi Anil,

    I have Just started Learning Oracle Apps.While reading the blogs I come across many things which shows that the envirnoment shold be there which I don't have.Any Suggestions that how can I proceed with that.

    Sincere regards,
    Sandeep

    ReplyDelete
  91. Anonymous3:49 PM

    Hi Anil,
    Thanks your efforts to this site.
    I have very good knowledge of Fuunctional side but i would like to learn also techie to.
    so from where I have to start.I know pl/sql ,but donot know in report form .would pls guide me study material. I am 9i OCP certified.

    ReplyDelete
  92. Hi Anil,

    I have a requirement in R12 , we have GL Import Interface program.

    The File in CSV format is loaded into Staging table, validated and then Journal Import is Executed to Import validated records. The file also contains Inoice Records stored in columns is GL Interface.

    After import is Done in R12 for GL, I need to create AP Invoice for the ledgers provided in the Gl Interface using the Invoice details given in GL Interface Columns.

    Is there any Generic API for creating invoices in R12 or should I use open Interface.

    Your advice will be appreciated.

    ReplyDelete
  93. Anonymous2:34 AM

    Hi Anil,
    Do you have any script to handle LPN unpacking & Packing of onhand quantities.
    Regards
    Sunil

    ReplyDelete
  94. Anonymous4:04 AM

    Its a fantastic blog for Apps.
    Thanks to Everyone who r all behind this!

    ReplyDelete
  95. Anonymous7:14 AM

    Hi Anil,
    I am new to this whole thing known as ORACLE APPS, I am a fresher did engg in E&C & changed the field due to recruitment in a software company.
    This ORACLE apps, i find very confusing..... But i found ur blogs very knowledgeable & gud. Thanx 4 such a gr8 help....
    What are the future prospects of this technology & how can i develop my knowledge better in this field?

    ReplyDelete
  96. Anonymous7:17 AM

    Hi Anil,
    I am new to this whole thing known as ORACLE APPS, I am a fresher did engg in E&C & changed the field due to recruitment in a software company.
    This ORACLE apps, i find very confusing..... But i found ur blogs very knowledgeable & gud. Thanx 4 such a gr8 help....
    What are the future prospects of this technology & how can i develop my knowledge better in this field?

    ReplyDelete
  97. Manish7:15 AM

    Hi Anil

    Could you please help me with the given query

    I have to find out the responibility name wih its Menu, submenu details , functions for alll teh responibilities existing in teh system.
    I have tried to using the Connect By Prior functionality .. but no success , it would be really helpful if you could sugget me the same..

    ReplyDelete
  98. hi anil...great job man. your work is highly appreciated by the oracle apps community. thanks a lot. your are making apps easy to understand and learn and to work as well..
    regards.
    pushpal

    ReplyDelete
  99. Anil, Your Blog is Really Superb, I have one doubt, If i want to terminate my report manually? how is it possible?Any package?

    ReplyDelete
  100. Anil, Your blog is Really Superb, I have one doubt, If i want to manually terminate my report,what can i do, Is any package available?

    ReplyDelete
  101. Hi Anil ,

    I have one question here , when we reset our password how the system know ie, this password is newly changed and need to pop up the password change window for initial login.If anyone wants to control this , it is possible ?
    From which procedure/function the OA page get called for changing intial password.?
    How can I know the OA page details if want ..?

    Thanks in advance !

    Regards,
    Kamlesh

    ReplyDelete
  102. Hi Anil,

    How are you...

    I have a question: We have migrated reports from UNIX AIX to Linux and now getting issue.

    Once i am logging into application with English (US) language, i am able to see the concurrent program based on report (rdf), this program supposed to run by german language. but once i am choosing the option german and logging into oracle application, i am not able to see concurrent program in concurrent program definition.

    Could you please help me

    Thanks,
    Ricky

    ReplyDelete
  103. Hi Anil,

    How are you...

    I have a question: We have migrated reports from UNIX AIX to Linux and now getting issue.

    Once i am logging into application with English (US) language, i am able to see the concurrent program based on report (rdf), this program supposed to run by german language. but once i am choosing the option german and logging into oracle application, i am not able to see concurrent program in concurrent program definition.

    Could you please help me

    Thanks,
    Ricky

    ReplyDelete
  104. Anonymous5:06 AM

    Hi Anil,
    manish here i'm a fresher and recently joined accenture.Working as sales support for emc.They are using DXP 11i,CXP 11i which are customized form of oracle apps .What i wish is to propagate my career in the field of development.

    can u do me a favor,just show me the way of Oracle apps.

    I consider my msg will look like as navice.:)

    ReplyDelete
  105. Anonymous3:36 PM

    Hi Anil,

    This is saikumar...I'm doing Oracle Apps 11i course.You are realy doing wonderfull job providing this stuff to us. As I'm learining apps. I find it very difficult to learn the tables of AP,PO,GL,Inv modules. Is there any easy way to do it...

    Keep this good work coming.

    ReplyDelete
  106. Anonymous12:11 AM

    Hello this is ranjit, this site is very usefull for me bcoz i am new for oraapps techi,so i dont have friends in this,pls explain about inbound interface process

    ReplyDelete
  107. Hi Anil,

    100000 kudos for ur patience in helping all....as i am a oracle beginner getting a lot benefit from ur site.

    thank u...

    ReplyDelete
  108. Anonymous1:31 AM

    Hi Anil,
    Can you please assist me with "SIGNON PASSWORD CUSTOM" option in oracle 11.5.9

    ReplyDelete
  109. Hello,

    very interesting blog. I have a small question : what does it mean fnd from fnd_messages for example ?

    ReplyDelete
  110. hi anil
    this is chandu i want to learn oracle apps.so what is the process to learn the oracle apps.pls let me know.dont take it as silly thing it is very imp for me.iam B.E 2011 passout

    ReplyDelete
  111. Anonymous2:21 AM

    Thanks a Lot...Anil
    Nice blog..now m learning oracle apps..on which area should i focus..

    Plz waiting 4 ur Reply

    THANKS

    ReplyDelete
  112. Hi Anil,

    appreciated ur job...

    can you pl let me knwo about Oracle HRMS functional articals.just now finished training.how can i improve my knowldege on oracle apps.

    thanks in adv.TC
    Aparna

    ReplyDelete