APP-FND-00222: Encountered an error while getting the ORACLE user account for your concurrent request Contact your system administrator

Error:






 Checked for relevance 14-Apr-2010 Application Install 11.5.6 to 12.0

• fact: Oracle Application Object Library
• fact: FNDRSRUN - Run Reports
• symptom: APP-FND-00222 Encountered an error while getting the ORACLE user account for your concurrent request to run from
• symptom: Error submitting concurrent request registered to a custom application
• cause: The custom application has not been assigned to any data grou

fix:

Add the custom application to a data group.

1.  Under the System Administrator responsibility navigate to Security --> 
Oracle --> DataGroup.
2.  Query up a data group (Standard Data Group is appropriate).
3.  A list of applications associated with the standard data group will appear.
4.  Click on FILE in the toolbar menu then click on NEW.
5.  In the Application column select the custom application from the LOV.
6.  Add an Oracle ID to the ORACLE ID column (APPS is appropriate)
7.  Save the changes.
8.  Resubmit the concurrent request.

Run the Report:

How to change Language To Arabic in Toad Oracle

Step 1: Check what NLS_LANGUAGE is being used in your database.

SELECT    (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_LANGUAGE')
       || '_'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_TERRITORY')
       || '.'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_CHARACTERSET') LANGUAGE
  FROM DUAL

Step 2: Change the NLS _ LANGUAGE in Toad to the same.

Step 3: Open Toad

Step 4: Click on the button as shown below

Step 5 : Click on the current  NLS_LANGUAGE

Sept 6 : Change it according to the database.
Sept 7 : Save the changes and close toad application then start again.

 Now Connect to the database...

How to Purge Debug Log, Closed Notifications and Concurrent Program Log/out files in Oracle Applications

Concurrent program “Purge Debug Log and System Alerts” in Release 11i and “Purge Logs and Closed System Alerts” in Release 12 is recommended way to purge messages.

 This program purges all messages up to the specified date,except messages for active transactions (new or open alerts, active ICX sessions, concurrent requests, and so on). This program is by default scheduled to run daily and purge messages older than 7 days. Internally this concurrent program invokes FND_LOG_ADMIN APIs.

Data from the following tables will be deleted when you run “Purge Logs and Closed System Alerts'” or “Purge Debug Log and System Alerts” program :

select * from FND_EXCEPTION_NOTES;

select * from FND_OAM_BIZEX_SENT_NOTIF;

select * from FND_LOG_METRICS;

select * from FND_LOG_UNIQUE_EXCEPTIONS;

select * from FND_LOG_EXCEPTIONS;

select * from FND_LOG_MESSAGES;

select * from FND_LOG_TRANSACTION_CONTEXT;

select * from FND_LOG_ATTACHMENTS

These tables contain debug & error messages.

Purge Concurrent Request and/or Manager Data Program

This concurrent program is used to purge concurrent requests log/out file, and/or CM log files.

Query to find Cloned Date, Version Details, URL of Oracle Applications

Query to get Instance Version details

SELECT product,
       version,
       status
FROM   product_component_version;  

Query to  get cloned date of an oracle instance

SELECT resetlogs_time
FROM   v$database; 

Query to get the front end URL from back-end

SELECT home_url
FROM   icx_parameters;   

Oracle WINSCP path finding Query for all modules

select * from fnd_env_context


/* Formatted on 5/9/2017 2:55:28 PM (QP5 v5.114.809.3010) */
  SELECT   variable_name, VALUE
    FROM   fnd_env_context
   WHERE   variable_name LIKE '%\_TOP' ESCAPE '\'
           AND concurrent_process_id =
                 (  SELECT   MAX (concurrent_process_id) FROM fnd_env_context)
ORDER BY   1

 

How to find the data Who deleted and commited in database

SQL> SELECT NAME, value FROM v$parameter WHERE NAME LIKE 'audit%';

NAME
----------------------------------------------------------------------
VALUE
----------------------------------------------------------------------
audit_sys_operations
FALSE
audit_file_dest
E:\ORACLE\PRODUCT\10.2.0\ADMIN\XP10R2JAN\ADUMP
audit_trail
DB
The audit is being done to the DB


SQL> desc dba_audit_trail;
SELECT userid, action#, STATEMENT, OBJ$NAME, To_Char (timestamp#, 'mm/dd/yyyy hh24:mi:ss')
FROM sys.aud$ ORDER BY timestamp# asc;

Check Current Applied Patch & Patch level status of all modules in oracle

Check Current Applied Patch

/* Formatted on 11/7/2016 1:00:42 PM (QP5 v5.114.809.3010) */
  SELECT   patch_name,
           patch_type,
           maint_pack_level,
           creation_date
    FROM   applsys.ad_applied_patches
ORDER BY   creation_date DESC

Query used to view the patch level status of all modules

/* Formatted on 11/7/2016 1:00:31 PM (QP5 v5.114.809.3010) */
SELECT   a.application_name,
         DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
         patch_level
  FROM   apps.fnd_application_vl a, apps.fnd_product_installations b
 WHERE   a.application_id = b.application_id;

After responsibility end dated but Still responsibility showing in the EBS application

Need to run the Report in Sys-Admin

Workflow Directory Services User/Role Validation