f Get Oracle Apps Traning Here: What happens when you login to Apps?

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



Name:
Location: United Kingdom

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


  • 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

    Comments on "What happens when you login to Apps?"

     

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

    Hello,

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

     

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

    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

     

    Anonymous Anonymous said ... (4: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,

     

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

    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

     

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

    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

     

    Blogger Mukesh said ... (1:10 AM) : 

    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

     

    Anonymous Anonymous said ... (8: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

     

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

    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

     

    Anonymous Anonymous said ... (12: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!

     

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

    Hi Anil,

    How is per_people_f different from per_all_people_f.

    Can you please help me on this.

    Regards,

     

    Blogger Anil Passi said ... (1:05 AM) : 

    Hi there

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

     

    Anonymous Anonymous said ... (6:17 AM) : 

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

     

    Anonymous Anonymous said ... (6:18 AM) : 

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

     

    Anonymous Anonymous said ... (6: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

     

    Anonymous Anonymous said ... (6: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

     

    Blogger Unknown said ... (7:41 AM) : 

    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

     

    Blogger Unknown said ... (7:42 AM) : 

    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.

     

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

    hi..

    answer the previous question

     

    Blogger Anil Passi said ... (5:41 AM) : 

    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

     

    Blogger Shiril Dubey said ... (11:53 PM) : 

    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

     

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

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

    Thanks and Regards
    Mary

     

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

    what is URL

     

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

    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

     

    Blogger Anuj Malhotra said ... (12:17 AM) : 

    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

     

    Blogger Anuj Malhotra said ... (12:32 AM) : 

    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

     

    Blogger Anuj Malhotra said ... (12:33 AM) : 

    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

     

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

    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

     

    Blogger Anuj Malhotra said ... (12:23 AM) : 

    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

     

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

    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".

     

    Blogger Unknown said ... (1:26 AM) : 

    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.

     

    Blogger venky said ... (9:57 PM) : 

    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

     

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

    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

     

    Blogger Unknown said ... (11: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 .

     

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

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

    Thank You,
    Maggi.

     

    Blogger Anil Passi said ... (3:47 AM) : 

    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

     

    Anonymous Anonymous said ... (5: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

     

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

    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

     

    Anonymous Anonymous said ... (4:26 PM) : 

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

     

    Blogger Gautham said ... (10:44 PM) : 

    waiting for your reply anil

    -Gautham
    gau.official@gmail.com

     

    Blogger Gautham said ... (10:47 PM) : 

    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

     

    Anonymous Anonymous said ... (1: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

     

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

    thanks anil.. good one..


    Yusuf

     

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

    Hi Anil,

    Simply Great ! very very helpful for biginers.

    Thanks,
    Shree

     

    Anonymous Anonymous said ... (6: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.

     

    Blogger Unknown said ... (9:17 PM) : 

    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

     

    Blogger Pavankumar Barlota . said ... (11:52 PM) : 

    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

     

    Blogger Anil Passi said ... (1:28 AM) : 

    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

     

    Anonymous Anonymous said ... (4: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

     

    Anonymous Anonymous said ... (5: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?

     

    Blogger prabhakar said ... (6:04 AM) : 

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

     

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

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

    Thanks,
    --Sunil

     

    Blogger Chandra R Matta said ... (8:46 AM) : 

    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

     

    Blogger hari said ... (4:01 AM) : 

    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.

     

    Anonymous Anonymous said ... (7: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

     

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

    Hi Anil,

    VERY USEFUL SITE.

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

    Gibbs

     

    Blogger Sri said ... (8:16 AM) : 

    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

     

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

    hi anil
    this is good blog for beginer

     

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

    hi anil
    this is good blog.

     

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

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

    nith

     

    Anonymous Anonymous said ... (9: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

     

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

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

     

    Anonymous Anonymous said ... (1: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.

     

    Anonymous Anonymous said ... (2: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.

     

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

    Hi Anil,

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

    Thanks in advance
    Anita

     

    Anonymous Anonymous said ... (8: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

     

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

    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 .

     

    Anonymous Anonymous said ... (3: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..

     

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

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

     

    Anonymous Anonymous said ... (10: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

     

    Anonymous Anonymous said ... (7:38 AM) : 

    hi anil
    can u explain the applications architecture request flow

     

    Anonymous Anonymous said ... (7: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

     

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

    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

     

    Anonymous Anonymous said ... (12: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?

     

    Anonymous Anonymous said ... (12: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.

     

    Blogger Ashish Harbhajanka (Oracle ACE) said ... (5:11 AM) : 

    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

     

    Blogger Ashish Harbhajanka (Oracle ACE) said ... (5:11 AM) : 

    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

     

    Blogger Uma Pathy said ... (4:11 AM) : 

    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

     

    Anonymous Anonymous said ... (12: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

     

    Blogger Unknown said ... (9:31 PM) : 

    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.

     

    Anonymous Anonymous said ... (2: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

     

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

    Hi Anil
    very interesting blog
    thank you

     

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

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

    Thanks for helping too many developers

     

    Anonymous Anonymous said ... (3: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.

     

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

    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 ..

     

    Blogger rama said ... (12:12 AM) : 

    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

     

    Blogger CEO said ... (2:38 PM) : 

    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...........

     

    Blogger CEO said ... (2:52 PM) : 

    This comment has been removed by a blog administrator.

     

    Blogger Anil Passi said ... (3:22 PM) : 

    Hi CEO

    I got your message, have sent you an email.

    Thanks,
    Anil

     

    Blogger janahar said ... (10:23 PM) : 

    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.

     

    Blogger Unknown said ... (6:07 AM) : 

    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

     

    Anonymous Anonymous said ... (3: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.

     

    Blogger Unknown said ... (1:05 AM) : 

    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.

     

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

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

     

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

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

     

    Anonymous Anonymous said ... (7: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?

     

    Anonymous Anonymous said ... (7: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?

     

    Anonymous Manish said ... (7: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..

     

    Blogger Pushpal said ... (12:46 AM) : 

    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

     

    Blogger Prem said ... (12:32 AM) : 

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

     

    Blogger Prem said ... (12:44 AM) : 

    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?

     

    Blogger Kamlesh Nikhade said ... (5:12 AM) : 

    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

     

    Blogger Unknown said ... (11:48 AM) : 

    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

     

    Blogger Unknown said ... (11:49 AM) : 

    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

     

    Anonymous Anonymous said ... (5: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.:)

     

    Anonymous Anonymous said ... (3: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.

     

    Anonymous Anonymous said ... (12: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

     

    Blogger Unknown said ... (1:44 AM) : 

    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...

     

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

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

     

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

    hi

     

    Blogger harish said ... (9:36 AM) : 

    Hello,

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

     

    Blogger chandu said ... (2:50 AM) : 

    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

     

    Anonymous Anonymous said ... (2: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

     

    Blogger Aparna said ... (11:08 PM) : 

    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

     

    post a comment