Status of the Roles and Responsiblities in Oracle

Excepted:
      Roles and Responsibilities is meant to active for the period, You have just given for the User.
      But, You can assign a role for an user that would be assigned infinitely long by just leaving the 'Active To' Field as Blank.
To Roles and Responsibilities:
      Login as SYSADMIN/SYSADMIN, Go to User Management-->Users, click 'Assign roles' button.

Tips on executing the PL/SQL Query

Issue:
Sometimes, When You are executing the PL/SQL query, it may end up with error by constraints problem.

Note:

The thing to be noted is, the some queries may get partially executed and altered the table.
If You are trying to run the same PL/SQL again, it will surely end up with some error if and only if the Table having constraints.

Blog is not loading properly

Issue:
It is due to javascript in the page may get crashed and while sending any request to the server, it will show the Error like, "Bad Request 400"

Solution:

     Try clearing the Cookies, Temporary from Firefox Browser.
         Go to Tools-->Clear Recent History, then delete everything from the browser.

Connect to different database thru SQL Editor

Use this query to switch to different databases,
   Run SQL Editor,
      *Use any default credentials like,
           apps/apps@VIS

           system/manager@VIS

           scott/tiger@VIS

     

      *While working in the SQL Editor, if You need to switch to other user or database,
          Use this query,
            connect apps/apps@VIS

            connect  system/manager@VIS

            connect scott/tiger@VIS

Databases and Tables

Note:

     First, You logon using credentials like apps/apps@VIS   (VIS is database name)
     If You create any tables in the SQL Editor, it will be storing in the VIS Database and referred from user_tables Table.Could be queried by using the Command,
         select table_name from user_tables;
    See clearly, tables You are creating always specific User only. You cannot get access from system/manager@VIS or scott/tiger@VIS

Finding database name from Oracle SQL PLUS

Use the command,
       select ora_database_name from dual;

Field cannot be updated

Issue:
  Field cannot be updated-Error.

Steps:

1. Create a COMPETENCE_TYPE in COMPETENCE_TYPE.
    1.1. Login as sysadmin/sysadmin in Admin page
    1.2. Navigate to HRMS Manager -> Other -> Lookup
    1.3. Click View->Find and find "COMPETENCE_TYPE"
    1.4. Add the following types into that lookup by clicking File->New
        CODE    Meaning            Date
        ===========================================================           
        BGT           BGT Skills     Do not give date

2. Create a COMPETENCE_TYPE in IRC_COMPETENCE_TYPE.
    1.1. Login as sysadmin/sysadmin in Admin page
    1.2. Navigate to HRMS Manager -> Other -> Lookup
    1.3. Click View->Find and find "IRC_COMPETENCE_TYPE"
    1.4. Add the following types into that lookup by clicking File->New
        CODE    Meaning            Date
        ===========================================================           
      BGT           BGT Skills     Do not give date




4. Check the newly added competencies.
4.1. Login as External/Employee.
4.2. Click 'Add Another Skill' button.
4.3. In the Skill Type, Click 'BGT Skills' and then click 'Search'.
4.4. 'J2ME' will be displayed in the search result. Choose that skill and click 'OK'.

Tips:
      * If You find the Field disabled, go to File-->Save and proceed
   then, File-->New.
      * If You can't find the inserted values in the Oracle Applications, please commit the changes made in SQL Editor. But, Closing the SQL Editor may commit the changes automatically.
       

Note:

    Please find whether You have added Skills in both COMPETENCE_TYPE and IRC_COMPETENCE_TYPE Tables.

Security and privileges for running an application

Tips:

     To run any application that accesses the system information will get privileges, if and only if we run it as an Administrator.

Redirecting the output from Oracle SQL to a Text File

Steps:

i) Create a text file and copy that Location.
ii) In SQL Editor, to enable spooling the buffer to text file,
Give the Command like
SQL> SPOOL <File path>
SQL> Run your queries here
If You are finished with querying,
SQL> SPOOL off

Go, find the SQL query output in the text file.

Selecting first 'N' Columns in a Table (Oracle SQL)

Use the query,
         SELECT * from Table where rownum < N

Adding Editable TextFields in PDF

To add a PDF text field:

1. Open the PDF in Nitro PDF Professional.
2. On the Forms ribbon tab, in the Fields group, click Text Field.
3. On the page, drag the pointer where you want the field to appear.
4. Double-click on the field and do one of the following (depending on your preferences):
   • In the Properties context tab, name the field and set its appearance settings.
   • In the Properties dialog, name the field and set its appearance settings.
5. Do either of the following:
   • If you're using the Properties context tab, in the More group, click Properties and then Options.
   • If you're using the Properties dialog, click the Options tab.
6. Select Options. Click Alignment and select from drop down menu items text alignment for left, center, or right.
7. Add text in the Default Text box if you want text to appear as a default for the field. Something like a zip code or country might be used where most of your respondents are likely to come from the area you add for the default text.
8. Check Multiple Line if you want the text to appear on multiple lines and check Scroll long text to have the text scroll in a box.
9. Click Limit of characters and enter the number of characters you want to limit a response to. Something like a zip code would work here.
10. Check Password to password secure a field.
11. Check Comb of Characters to create a comb field. (Note: You must turn off all other checkboxes to use this feature.) Comb fields are designed for characters to be added in individual boxes. The number of boxes are defined in the text box that appears after you check the Comb of Characters box.
12. Format. If you want a format other than text, such as a date or custom format, then choose an option from the Select format category drop down menu.
13. Validation. If you want the field data to be validated, you need to know JavaScript. Check Run custom validation script and type the JavaScript code to validate the field data.
14. Calculate. If the field is to be calculated, check an option for calculating data.

To edit a text box form field:

1. Open the PDF in Nitro PDF Professional.
2. On the Form ribbon tab, in the Fields group, do either of the following:
   • Click the field type that corresponds to the field you want to edit.
   • Click Edit All Fields.
3. Double-click the field to begin editing its attributes.

Oracle Forms not Populating

Note[Important]:

         Mozilla Firefox 3.5 should be installed. Don't allow any Automatic Updates to any of the Softwares installed for Oracle so far.
        Internet Explorer 8 mostly find updates for improving security to the Browser but it will hinder the performance of Oracle Applications.

Steps to take back Your System:

          First, check whether the system is configured for Automatic Updates. If so, Turn off the Auto Updates.
          Then, go to the Control Panel, there check "Show Updates", this will be showing all updates for each installed product. If You want, You can remove those updates.

Oracle SQL Plus

General Procedures before starting the SQL Plus:

      *Check tnsnames.ora whether the Current Database Name has been updated or not.
      *Instead, You can configure it by giving the Server Name and Service Name will be the Name of the Database.
      *Now, Start the SQL Editor(SQL PLUS).
      *Give the Credentials SCOTT/TIGER/VIS(Database Name,You have created).
      *Cheers!! Start Working.....
 

Installation Tips

Look for the Minimum requirements of the Software or any Application before You start installing any product.

Oracle irecruitment:

          To Run the Oracle Applications in the browser, it needs the J2SE plugin (i.e.,) JRE 1.5.0 update 13.
Make sure that, it is installed in the Machine.

Start and Stop the Apache Server

       Go to Apache Installation Folder, where You will Four Executable files tomcat6w.exe,.......
You should run the "tomcat6w.exe" as Administrator then You will have the dialog box, where You go to General Tab.


       You will find the way to Start/Stop the Apache Service.

Windows Live Communications has stopped working

Solution 1:
      Here, One or more service may conflict each other. For this, You could possibly restart Your Computer. Then it will start all services normally. Windows Live will also be working great.

Solution 2:

      Either you could download "faultrep.dll" and paste it into Contacts Folder by mapping through "C:\Program Files\Windows Live\Contacts", then restart Your Computer.

General Installation Tips

Important:

     Before starting any installation,  Please make sure that every files, components, even small file matters. It saves much time and work too.

Steps to mind before Installing Apps any Server.

Steps to be performed before installing any new software on the server.

Obtain Screenshots/details of the following and update it in the instance specific installation document. This will help in determining new processes, new registry entries etc.
1)Task Manager Process – select all user processess (Start -> Run -> Taskmgr -> Maximise Window -> Click Process Tab)
2)Export Registry Settings (Start -> Run -> regedit -> File -> Export)
3)Services (Start -> Run -> services.msc -> click Status column Heading to sort based on services started -> Click Export List – this option will also export the descriptions, hence click on View -> Add/Remove Columns -> Click Description -> Remove -> Click ok. After Exporting, Click View -> Add/Remove Columns -> Click Description -> Add -> Click ok)
4)Environment Variables (Start -> Run -> cmd -> type set)
5)Record PATH Environment Variable Value (Start -> Run -> explorer -> Right Click on My computer -> Properties -> Advanced -> Environment Variables -> Under System Variables -> Double Click Path -> Copy the value)

To get ScreenShots

Click Print Screen Button [Prnt Scrn] -> Start -> Run -> MsPaint -> Control + V

Windows Shortcuts

To Launch Run -> WindowsKey + R
To Launch Explorer -> WindowsKey + E

Installing Microsoft Visual Studio 2005 on Win Server 2003 Enterprise Edition

Sometimes, the Visual Studio 2005 installer may Stop with this, Saying,

ERROR:Error 1335.The cabinet file '_9191_RTL_x86_enu_vc7pkg_SDE.cab' required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package.


Don't give up. If You are having the ISO Image, You can load it directly into the CD Drive and Start Installing again. This time installation would go Smoothly.

Thank You.

Creating the New Users in Win Server 2003

Creating a Local User on Windows 2003 server

1. From the Windows Start menu select Administrative Tools | Computer Management. If this menu item does not exist, you are either not an administrator for the computer or the server is a domain controller and you need to create a domain user instead.
2. From the Computer Management dialog, navigate to System Tools | Local Users and Groups | Users on the left panel; right click on Users and select New user from the popup menu.
3. In the New User dialog, enter prtracker, PR-Tracker and Problem Tracking System for the User name, Full name and Description, respectively.
4. Uncheck box User must change password at next login and then check box Password Never Expires.
5. Click the Create button to create the user and then click Close button.
6. Optional steps follow: double-click the prtracker username on the right panel.
7. From the prtracker Properties dialog, select tab Member Of and click the Add button.
8. From the Select Groups dialog and in the Name box, type Administrators and click the OK button. Also, add prtracker user to be member of DCOM User Group.

Installation of Windows Server 2003

Note:
   While installing Windows Server 2003, You should allocate the Primary Partition and Leave the rest unallocated.
    Because You have no choice to Shrink/Extend the Primary Partition Once You installed the Server 2003.
So make sure that You Leave the rest of Memory unallocated to create partition after the installation.

Installation of Software from CD Backups

Method 1:
If You start installing the Setup from First CD Backup, while installation it may prompt for file that is missing in the First Backup. It is recommended that You should copy all the files from BackUps(Splitted Backups from CD like CD1, CD2, CD3......) and put it into the First Backup then Start the installation.

Method 2:

  You can Copy the Missing files while installing too. Then Continue.

Method 3:

   You could possibly load ISO Images into CD Drive or Daemon Tools. And start installation, this time installation would go smoothly. Load the Other ISO image will installer prompt other CD.