11 October 2011

How to Check the Pach Level in Oracle Apps

This will be required for Oracle tar with Oracle corp. The following statement is mostly used by DBA

/* Formatted on 10/11/2011 5:46:09 PM (QP5 v5.163.1008.3004) */
  SELECT patch_level, application_name
    FROM fnd_product_installations a, fnd_application_tl b
   WHERE patch_level IS NOT NULL AND a.application_id = b.application_id
ORDER BY application_name;

Output:-

PATCH_LEVEL,APPLICATION_NAME
11i.MST.A, ????? ?????
11i.ABM.G.4,Activity Based Management
11i.BEN.O.2,Advanced Benefits
11i.IEC.R,Advanced Outbound Telephony
11i.QP.J,Advanced Pricing
11i.EGO.C,Advanced Product Catalog
11i.MSC.I,Advanced Supply Chain Planning
11i.ALR.G,Alert
11i.AZ.H.2,Application Implementation
11i.FND.H,Application Object Library
11i.RG.I,Application Report Generator
11i.BIS.L.6,Applications BIS
11i.AD.I.6,Applications DBA
11i.JA.I,Asia/Pacific Localizations
11i.FA.P,Assets
11i.VEA.J,Automotive
11i.BSC.H,Balanced Scorecard
11i.FPT.D,Banking Center

How to check which concurrent program attached to which responsibility

Execute following select statement to know the responsibilities names to which your concurrent program is attached

 SELECT responsibility_name
  FROM fnd_responsibility_tl a,
       fnd_responsibility c,                       
       fnd_request_group_units d,
       fnd_concurrent_programs_tl b
 WHERE     a.responsibility_id = c.responsibility_id
       AND c.request_group_id = d.request_group_id
       AND b.concurrent_program_id = d.request_unit_id
       AND UPPER (b.USER_CONCURRENT_PROGRAM_NAME) =
              UPPER ('Enter your program Name');

Example:-
/* Formatted on 10/11/2011 5:27:36 PM (QP5 v5.163.1008.3004) */
SELECT responsibility_name
  FROM fnd_responsibility_tl a,
       fnd_responsibility c,                      
       fnd_request_group_units d,
       fnd_concurrent_programs_tl b
 WHERE     a.responsibility_id = c.responsibility_id
       AND c.request_group_id = d.request_group_id
       AND b.concurrent_program_id = d.request_unit_id
       AND UPPER (b.USER_CONCURRENT_PROGRAM_NAME) =
              UPPER ('Qtel CI TO IRB Interface Program');

04 October 2011

Step by Step Oracle Linux Installation

Select Skip

Click Next
Select your Language Click Next
 Click next

 Select Manual
Click Yes

 Enter your Mount point. /boot, /,  Swap

  Click next
 Click next
 Enter your IP address and Host name
 Disable your Firewall  Click next
 Select your country  Click next
 Enter your Root Password  Click next
  Select Everything  Click next
  Click next

 Reboot

You have successfully installed .

The requested operation could not be completed due to a file system limitation

Error:-
The requested operation could not be completed due to a file system limitation


I am trying to copy 117GB file in D drive . i am getting above error .


Solution:-



Just deselect  Compress this drive to save disk space .

next i tried to copy its copied  successfully .