Discoverer invoke from EBS oracle.discoverer.applications.viewer.events.ApiConnectAppsSecureEvent

issue : An error occurred while handling the event. See the application log for more details.
oracle.discoverer.applications.viewer.events.ApiConnectAppsSecureEvent
- Empty input (or null input) is not allowed

all user are getting discoverere reports when invoking from Oracle ebs  and user able to access with other browsers as well ,at the same time few users not able to get the discoverer and getting the above error message in IE 8


Solution;

Go to internet explorer->tools->internet Options->Security-> Trusted Sites->Sites->Add

Add the discovers address

How can I activate the Totals button that is grayed out in PSI

How to active the Total button in Oracle PSI

The Totals button is activated through the set up of Project Status Columns.  After navigating to
Setup -> Project Status Columns,
 enable the Total check box for each column you want to total for column summarization and save your changes.

 NOTE: You cannot click in the Segment 1, Name, or Over Budget lines.

Concurrent Manager Status Shows 'System Hold Fix Manager

All concurrent managers status shows''System Hold Fix Manager ' and all requests  are in pending....

Solution:

1.go to OS and check any  concurrent process is running (here  only two process were running )
2.stop concurrent manager adcmctl.sh stop apps/pwd
3.kill those process whice are still running
4.start concurrent managers sh adcmctlsh start apps/pwd
5.and go applicatoin and clikc on fixed button


All process will start


Regards

Webadi Error Run-time error '1004': Method 'Vbproject' Of Object'_workbook'

ISSUE:

Run-time error '1004':

Method 'VBProject' of Object'_Workbook' Failed
this issue reproduce when downloading the excel sheet via webADI .

SOLUSTION:
In Excel 2003:
go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab.  Check the box next to "Trust access to Visual Basic Project".
(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

In Excel 2007, use the following navigation:

• Click on the Office button in the upper left corner
• Click on the Excel Options button
• On the left, click on the Trust Center
• Click on the Trust Center Settings button
• On the left, click on Macro Settings
• Click on "Trust access to the VBA project object model"

Ref: 376013.1
       406526.1     

Tablespace (APPS_TS_MEDIA ) is growing

step 1:  select * from
(select SEGMENT_NAME, sum(bytes)
from dba_segments where TABLESPACE_NAME='APPS_TS_MEDIA'
group by segment_name order by 2 desc)
where rownum <= 10;

Step 2:  

Use the following query to find out currently set value for PCTVERSION:

select PCTVERSION from dba_lobs where TABLE_NAME = 'FND_LOBS' and COLUMN_NAME='FILE_DATA'; 

PCTVERSION

----------

        10

Step 3: 

PCTVERSION can be changed using the following SQL (it can be run anytime in a running system):

ALTER TABLE FND_LOBS MODIFY LOB (FILE_DATA) ( PCTVERSION 0 ); 

Ref: 298698.1

How to replace the default Oracle Logo with a Customized Logo Company Brand logo

There are 3 ways to change the Oracle logo to a Customized logo. The logo can be replaced in two ways at site level and one way by application only.
To change the logo at the Site level.
1. Change the FNDSSCORP.gif file.
A. Make a backup copy of the FNDSSCORP.gif file. Name it FNDSSCORP.bak
B. Make the name of the custom logo FNDSSCORP.gif
C. Upload the new FNDSSCORP.gif file to the $OA_MEDIA directory
D. Log out and log back into the application 2. Leave the FNDSSCORP.gif file alone and upload a new image (test.jpg, for example) $OA_MEDIA directory.
A. Log into (N) System Administrator > Profile > System
B. Query the "Corporate Branding Image for Oracle Applications" profile
C. Type "test.jpg" (following our example image) under the Site column
D. Save
E. Log out and log back into the applicationBoth cases, the application will show:
Now, change the Corporate Branding (the Oracle image) in a specific application and leave it as the Oracle image for all the rest of the applications, as well as the login and home page.
3. Start the same as step 2. above: Leave the FNDSSCORP.gif file alone and upload a new image (test.jpg, for example) $OA_MEDIA directory.
A. Log into (N) System Administrator > Profile > System
B. Put a checkmark in the Application box and type "Self-Service Web Applications"
C. Type "Corporate Branding Image for Oracle Applications" in the Profile field and click Find
D. Type "test.jpg" (using the same example) under the Application column that should already say "Self-Service Web Applications"
E. Log out and log back into the applicationAll pages except for the iProcurement responsibility will have the Oracle logo in the Corporate Branding



Ref:421636.1

Custom Code to Read only for all resposibilities and able to sumbit Concurrent srequests

----(Added the Custom Code to read only the Responsiblity )-----------
    formname    VARCHAR2 (30);
   blockname   VARCHAR2 (30);
BEGIN
   IF event_name = 'WHEN-NEW-FORM-INSTANCE'
   THEN

      IF fnd_profile.VALUE ('USER_NAME') = 'XXXX'
      THEN
(CURRENT_FORM)||'..FMB NAME..'||GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME));

         IF GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME) NOT IN ( 'FNDRSRUN')
         THEN
('USER_NAME'));

            BEGIN

               COPY ('Entering app_form.query_only_mode.',
                     'global.frd_debug');
               COPY ('YES', 'PARAMETER.QUERY_ONLY');
               app_menu2.set_prop ('FILE.SAVE', enabled, property_off);
               app_menu2.set_prop ('FILE.ACCEPT', enabled, property_off);
               formname := NAME_IN ('system.current_form');
               blockname := GET_FORM_PROPERTY (formname, first_block);

               WHILE (blockname IS NOT NULL)
               LOOP
                  IF (GET_BLOCK_PROPERTY (blockname, base_table) IS NOT NULL
                     )
                  THEN

                     SET_BLOCK_PROPERTY (blockname,
                                         insert_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         update_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         delete_allowed,
                                         property_false
                                        );
                  END IF;

                  blockname := GET_BLOCK_PROPERTY (blockname, nextblock);
               END LOOP;

            END;
         END IF;
      END IF;
   END IF;
END event;
----(End Added the Custom Code to read only the Responsiblity )-----------

compile a form using frmcmp_batch.sh ORA-12154: TNS:could not resolve the connect identifier specified

When attempting to compile a form using frmcmp_batch.sh or frmcmp.sh

The following errors occurs

ORA-12154: TNS:could not resolve the connect identifier specified

Solution: 

Cause

The TNS_ADMIN set in the scrip frmcmp_batch.sh or frmcmp.sh is pointing to the wrong location.
When the script frmcmp.sh or frmcmp_batch.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin

See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN...
While it should be:
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN
...


Reference : 431324.1

How to transfer expenditure item from one project to another project

1.Create new job 12040900 with old job 12040387

2.while creating take the choose  correct customer 2308

3.update the billing

4.save ...

5.go to agrrement and funding 1204900 with customer 2308

6.go to budget and baselined.

7.run PRC: Update Project Summary Amounts now we can see in contract value in PSI

8.source projcet expenditure item window and sselect  rows

9.tools tranfer (transfer788)

10.PRC: Distribute Labor Costs

11.PRC: Distribute Supplier Cost Adjustments

12.PRC: Update Project Summary Amounts

13.now in project 12040900 the expenditure 42,348.06

14.PRC: One Step Interface Streamline Processes to GL with option XS: Interface Supplier Costs To GL

How to change the customer name for a project

1.how to change the customer name for a project;
case: once project created with a customer (wrong customer) ABC Sevices (2531) and invoice and revenues completed now client wants to change the customer to XYZ (2308)
Ans: we can do it  in two ways
Option 1:
in AR Customer-> Account Merge
with this we can merging the customers and the project which was in ABC now in XYZ and abc will be inactive
Option 2:
1. create new project with different number
2.transfer the expenditure items to new project from old(Material,Labour,Sub contract ,other overheads)
3.cancel the revenue and invoice and events from old jobs
4.create new invoice ,revenues
5.commitments has to create for new job
6.close old job

Monitor Users Monitor User Form Shows Users Who Have Already Logged Out

Issue : Monitor User Form Shows Users Who Have Already Logged Out

Solution : Please run the Concurrent Program "Purge Signon Audit Data" regularly.

Ref: 270814.1

Assigning Default Folders to Users or Responsibilities

Assigning Default Folders to Users or Responsibilities 116125.1

Solution Description
--------------------
1.  Create a new folder:

     a. Sign on to the application using your Projects Responsibility.

     b. Navigate to Expenditures -> Pre-Approved Batches -> Enter.

     c. Select the Expenditures button.

     d. Select the Folder icon.

     e. Select New.

     f. Enter in your requirements and select Save As.

     g. Save the folder as Public and Open As Default.


2.  Assign the folder as a default to your users:

     a. Sign on to the application using your System Administrator
        Responsibility.

     b. Navigate to Application -> Administer Folders.

     c. Enable Default Folder Assignments By User.

     d. Select Find.

     e. Add your new folder to the appropriate user(s).


Notes
-----
1.  Folders can be assigned to users as well as responsibilities

Ref: 116125.1

drop and re-create of dbconsole.

 drop and re-create of dbconsole. Here are the steps:

-----------------------------
To drop and recreate follow this note:

How To Drop, Create And Recreate DB Control In A 10g/11g Database (Doc ID 278100.1)

1) stop dbconsole

emctl stop dbcosnole

2) the drop

Step 1: Drop AQ related objects in the SYSMAN schema

Logon to SQLPLUS as the user SYS

SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE);


Note: For 11.2 datrabase, logon to SQLPLUS as the user SYS (not SYSMAN) and run:

exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force =>TRUE);

Step 2: Drop the DB Control Repository Objects

Logon to SQLPLUS as the user SYS or SYSTEM, and drop the sysman account and management objects:

SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
SQL> EXEC sysman.setEMUserContext('',5);
SQL> REVOKE dba FROM sysman;
SQL> DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
SQL> DROP USER mgmt_view CASCADE;
SQL> DROP ROLE mgmt_user;
SQL> DROP USER sysman CASCADE;


3) Manually remove the files:

Section A, Option 2. Delete DB Control Configuration Files Manually (and for windows update the registry)

4) the create

Section B, Option 2. Create the DB Control Repository Objects and Configuration Files


Please note carefully that the drop and create put the database in Quiesce Mode. This note provides information about what that means.

From 11.2.0.1.0 release, the database is NOT put into quiesce mode anymore for repository drop and recreate operation. This means that emca drop and recreate commands can be executed for 11.2.0.1 database without impacting other sessions in the database.

PRC: Create Accounting There are no eligible transactions to account

Issue : PRC: Create Accounting

Error in output file:
"There are no eligible transactions to account.  Please update the parameters or submit the request at a later time when there are transactions requiring accounting."
Log file:
"Technical warning : There are no events to process."
Accounting Program did not find any events.

Solution: There Are No Eligible Transactions To Account, Please Update The Parameters And Resubmit

Ref:[ID 1382155.1]

Unable to Login to WebLogic Console. Getting "Error 404

Unable to Login to WebLogic Console. Getting "Error 404

Error 404--Not Found
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found

The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.
If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address

Cause
The incorrect URL is being used.
Solution
To access WebLogic console, use the following url:
http://hostname:9999/console%22.%A0%A0Login

Ref :622756.1

How to cancel an invoice interfaced to AR

How to cancel an invoice interfaced to AR ?
There are 2 ways of doing it :

1. In Invoice Review form, cancel the invoice which will create a credit memo automatically which has to be interfaced back
to AR. This will reverse the original invoice accounting in AR and there will be zero amount balance in AR.

2.The other method is to enter a new event with a negative amount, generate draft invoice that includes that event, release
and interface to AR.

Credit Memos from Oracle Projects issue in Autoinvoicing

Credit Memos from Oracle Projects

A common AutoInvoice error that can occur when credit memos are sourced from Oracle Projects:

"You cannot supply any account assignment for your credit memo transaction when the system option 'Use Invoice Accounting for Credit Memos' is Yes"

Fix: Set the profile option AR: Use Invoice Accounting For Credit Memos to No.

PRC: Generate Draft Invoices for a Single Project Gives 'No eligible expenditures or events' on Billing Events

ISSUE:
PRC: Generate Draft Invoices for a Single Project Gives 'No eligible expenditures or events' on
Billing Events

Solution : 
 - go Event screen and check the billed flag (Yes)

- it should be 'No'




Ref:1066250.1

WEBADI CANNOT CREATE EXCEL SPREADSHEET - HANGS

Enable 'Allow status bar updates via script'.

1) Open Internet Explorer browser window.
2) Click on Tools Menu.
3) When the Tools menu appears, click "Internet Options" at the bottom of the Tools menu.
4) Click on the security tab.
5) When the Security page appears, click the "Internet" icon in the "Select a zone" box and then
click the "Custom Level.. " button.
6) When the "Security Settings" dialog box appears, scroll down to "Scripting" on the menu. Enable
- Allow status bar updates script.
   Select OK
7) You may receive a Warning. Please select "Yes"
8) Finally, click "OK" to close the Internet Options dialog box.
9) Close the browser window so that new settings can be used.


Ref:    789122.1

PRC: Update Project Summary Amounts Fails With ORA-01400 on EXPENDITURE_ITEM_DATE

PRC: Update Project Summary Amounts Fails With ORA-01400 on EXPENDITURE_ITEM_DATE [ID 1290089.1]
Ref: 1290089.1

PRC: Update Project Summary Amounts Ends with REP-0069 and REP-57054

PRC: Update Project Summary Amounts Ends with REP-0069 and REP-57054

Cause:

The parameter 'Generate Report Output' was set to YES so a huge amount of data was created with each run.  Once this option was set to NO, the error quit occurring.
Solution:

Set the parameter 'Generate Report Output' to NO for the PRC: Update Project Summary process.


Ref: 1372693.1

How to find last update for xml data definition,tamplate in database tables

Q.How to find last update for  xml data definition,tamplate  in database tables

Ans: XBO_LOBS (tables)

how to grant ON COMMIT REFRESH to user

grant ON COMMIT REFRESH to wpprod

How to delete log file in Unix

delete the file of 10 days old with this command

find . -mtime +10 -exec rm "{}" ";"

How To Enable/Disable Diagnostics menus and The Forms Personalization Menu

By default the “Personalize” menu is visible to all the users.  This can be controlled with help of profile options. By setting up the below profile options, the access to the Personalize menu can be limited for the authorized users. This will prevent unwanted users from changing the look and behavior of the forms.
The profile options are:

1. Utilities:Diagnostics = Yes/No
   This profile option controls the availability of the Diagnostics utility.
   So you can set it to Yes on site level or on user level.
   
2. Hide Diagnostics menu entry = Yes/No
   This profile Option determines whether a user can automatically use the Diagnostics features.
   If Utilities:Diagnostics is set to No, then users must enter the password for the APPS schema
   to use the Diagnostics features.

Ref:550626.1

oracle.apps.ar.applications.cashapp.apply

 Applying Receipt Generates Workflow Notification With Error - Local Event Error: oracle.apps.ar.applications.cashapp.apply

The issue can be reproduced at will with the following steps:

1. NAV: Receipts->Receipts
2. Apply a receipt to an invoice

The issue has the following business impact:

Due to this issue, SYSADMIN mailbox is getting hundreds of notifications daily and users are not sure if they need to be ignored

Solution:
The following workaround will avoid the error notification:

Please disable the event subscription as follows:

First login as SYSADMIN (you must have SYSADMIN privileges in order to update)

- RESP: Workflow Administrator Web Applications
- NAV: Administrator Workflow->Business Events
- In Name field for search criteria enter 'oracle.apps.ar.applications.CashApp.apply'
- (B) Click Go
- It will show you one even under Results
- Under Subscription column, click on Subscription icon
- Go to update subscription "PA_PWP_NOTIFICATION.Receive_BE"
- Select Disable
- Apply

Ref:973074.1

ICX Timeout Profile Values

• ICX Timeout Profile Values

The following E-Business Suite profile options control screen timeouts for Forms, as well as Self Service sessions.  Again, please note, some of the ICX profiles also control Forms Session timeouts!  This can be confusing since Inter-Cartridge Exchange (ICX) is often associated with Self Service applications. This is no longer the case since the release of Framework for the ICX Profiles control the timeout functionality.

Parameter	Default	Recommendation
ICX:Session Timeout	None	30 (minutes)
ICX: Limit Time	4 (hours)	4 (hours)
ICX: Limit Connect	1000	2000

·         ICX:Session Timeout - This profile option determines the length of time (in minutes) of inactivity in a user's form session before the session is disabled.  Note that disabled does not mean terminated or killed.  The user is provided the opportunity to re-authenticate and re-enable their timed-out session. If the re-authentication is successful, the disabled session is re-enabled and no work is lost. Otherwise, the session is terminated without saving pending work.  This functionality is available via Patch 2012308 (included in 11.5.7, FND.E).  Note: Setting the profile value to greater than 30 minutes can drain the JVM resources and cause ‘out of memory’ errors.

·         ICX: Limit time - This profile option defines the maximum connection time for a connection – regardless of user activity.  If 'ICX:Session Timeout' is set to NULL, then the session will last only as long as 'ICX: Limit Time', regardless of user activity. 

·         ICX: Limit connect - This profile option defines the maximum number of connection requests a user can make in a single session. Note that other EBS internal checks will generate connection requests during a user session, so it is not just user activity that can increment the count. 

OEM Console page not bale open

Issue :
started OEM but not able to open in IE  getting error

I tried https://proddb.xxxxxxxxx.ae:5501/em

getting Error :'The webpage cannot be found'



1.emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation.  All rights reserved.
https://proddb.reyamigroup.ae:5501/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
all attemps to stop oc4j failed... now trying to kill 9
--- Failed to shutdown DBConsole Gracefully ---
 failed.


Solution:

1. emctl stop dbsoncole
2.kill agent related proceses

3.emctl start dbconsole

Customer Number Skips When Automatic Customer Numbering On

While creating new customers the Customer Number is not generated sequentially, and often has gaps of 20


Solution :

1) Run the following sql.

SELECT sequence_owner ,sequence_name, increment_by, cache_size ,last_number
FROM dba_sequences seq
WHERE seq.sequence_name like 'HZ_ACCOUNT_NUM_S' ;

2)
If the cache is not = 0 set it to zero using the following alter statement :

ALTER SEQUENCE AR.HZ_ACCOUNT_NUM_S nocache;

COMMIT;

Ref:  397212.1

AFPASSWD Utility in R12

AFPASSWD Utility

AFPASSWD is an enhanced version of FNDCPASS, and includes the following features:

• AFPASSWD only prompts for passwords required for the current operation,

allowing separation of duties between applications administrators and database

administrators. This also improves interoperability with Oracle Database Vault. In

contrast, the FNDCPASS utility currently requires specification of the APPS and the

SYSTEM usernames and corresponding passwords, preventing separation of duties

between applications administrators and database administrators.

• When changing a password with AFPASSWD, the user is prompted to enter the

new password twice to confirm.

• AFPASSWD can be run from the database tier as well as the application tier. In

contrast, FNDCPASS can only be run from the application tier.

FNDCPASS will continue to be shipped with Oracle E-Business Suite, and customers

can migrate to the AFPASSWD utility at their discretion.

Important: The FNDCPASS utility must still be used to migrate the

password hashing scheme, as described in My Oracle Support

Document 457166.1, FNDCPASS Utility New Feature: Enhance Security

With Non-Reversible Hash Password.

AFPASSWD Usage

The AFPASSWD command is used with the relevant command line options to perform

the desired action.

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-f <FNDUSER>]

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-o <DBUSER>]

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-a]

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-l <ORACLEUSER> [<TRUE>] |

[<FALSE>]]

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-L [<TRUE>] | [<FALSE>]]

AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] [-s] <APPLSYS>

These options have the following functions:

• -c {APPSUSER}[@{TWO_TASK}] - Specifies the connection string to use, the

Applications user, and/or the value of TWO_TASK. This option can be use in

combination with others. If it is not specified, default values from the environment

will be used.

Note: The password will be prompted for, and is not to be

provided in the connection string.

• -f {FNDUSER} - Changes the password for an Applications user. A username that

contains spaces must be enclosed in double quotation marks; for example, "JOHN

SMITH".

• -o {DBUSER} - Changes the password for an Oracle E-Business Suite database user.

Note: This only applies to users listed in the

FND_ORACLE_USERID table, not database users in general.

• -a - Changes all Oracle (ALLORACLE) passwords (except the passwords of APPS,

APPLSYS, APPLSYSPUB) to the same password, in the same way as the

ALLORACLE mode does in FNDCPASS.

• -l - Locks individual {ORACLE_USER} users (except required schemas). {TRUE} =

LOCK, {FALSE} = UNLOCK.

• -L - Locks all Oracle (ALLORACLE) users (except required schemas). {TRUE} =

LOCK, {FALSE} = UNLOCK.

• -s {APPLSYS} - Changes the password for the APPLSYS user and the APPS user.

This requires the execution of AutoConfig on all tiers.

• -h - Displays help.

[appsvis@erptest out]$ AFPASSWD -o okc

Enter the ORACLE password of Application Object Library 'APPSUSER':

Connected successfully to APPS.

Enter the password for your 'SYSTEM' ORACLE schema:

Connected successfully to SYSTEM.

Working...

Enter new password for user [okc]:

Verify new password for user [okc]:

Password is changed successfully for user okc.

AFPASSWD completed successfully.

[appsvis@erptest out]$ AFPASSWD -f hyder

Enter the ORACLE password of Application Object Library 'APPSUSER':

Connected successfully to APPS.

Working...

Enter new password for user [hyder]:

Verify new password for user [hyder]:

Password is changed successfully for user hyder.

Password is changed successfully for user hyder.

AFPASSWD completed successfully.

====================================

How to execute Gather schema from backend

exec dbms_stats.gather_schema_stats('AP',options=>'GATHER',estimate_percent =>DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FOR ALL COLUMNS SIZE AUTO', cascade => TRUE);
To execute the corresponding FND_STATS procedures from SQL*Plus to gather CBO stats for one or all schemas, or for a particular table, use the following examples:
# sqlplus apps/<apps_pwd>
SQL> exec fnd_stats.gather_schema_statistics('MRP');      <- One schema
SQL> exec fnd_stats.gather_schema_statistics('ALL');      <- All schemas
SQL> exec fnd_stats.gather_table_stats('MRP','MRP_FORECAST_DATES'); <- One table
SQL> begin            <- Partitioned table
  2      fnd_stats.gather_table_stats(ownname     => 'APPLSYS',
  3                                   tabname     => 'WF_ITEM_ACTIVITY_STATUSES',
  4                                   granularity => 'PARTITION');
  5  end;
  6  /

ORA-12545: Connect failed because target host or object does not exist

ORA-12545: Connect failed because target host or object does not exist

Cause: The address specified is not valid, or the program being connected to does not exist.

Action: If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again

Add Arabic Languae in Oralce R12.1.x

Theses are the steps for adding  Arabic language:
 
1. Active the language:
   From Oracle Application Manager, go to License manger and activate to Arabic    language   
2. Run Multi-lingual Tables:
   From AD Administration, run Multi-lingual Tables (AD Administration
   Main Menu >Maintain Applications Database Entities Menu)
3. Apply NLS patch 6678700_AR  for the Arabic language by adpatch.
4. Run the Translation Synchronization patch utility (adgennls.pl).
   Create and submit a manifest using the form provided in Oracle meta link, select the Get Latest Translations check box option.
5. Apply translation Synchronization Patch (TSP).
6. Install the Release 12 NLS help
 

How to generate a debug file in OM

1. Set the following profile options:
   OM: Debug Level - set to 5
   OM: Debug Log Directory - any directory that can be written to by the database
   To check, run the following SQL statement:
   Code:

   select value from v$parameter where name = 'utl_file_dir'

   Set profile option OM: Debug Log Directory at the Site & Application Level.
2. In the Sales Orders form go to Tools -> Debug and select 'Write to a File'.
   Note: Later versions of the Sales Order form do not have this option. Simply click on Tools and check the Debug box. This will print out a file name - NOTE down this file name (the first letter in the file name is lower case 'L').
3. Perform the action you wish to debug.
4. Go to Tools -> Debug and select 'Turn Debug Off' to complete debugging. Or on later form versions just uncheck Debug.
5. After you have completed generating the debug file, please set the value of the profile OM: Debug Level back to 0, otherwise there will be some performance impact. Retrieve the debug file from the directory specified in step 1.

How to Run a Patch Impact Analysis In OAM [ID 352843.1]

FRM-41051 You cannot create records here in Projects Events

Issue
when user navigation Projects-> Events ->Projects and New

FRM-41051 You cannot create records here

Solution :
PA: Cross Project User -- Update = YES  (responsibliity level)

Change status button disable at responsibilitiy level in projects

Change status button disable at responsibilitiy level in projects

solution ; attache the sub menu to responsibility

Project Status Function Security Menu

Samba not able to access with user

1.[root@erptest home]# cd /shared/rpm/
2.[root@erptest rpm]# ls
binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm
perl-Convert-ASN1-0.20-1.1.noarch.rpm
rdesktop-1.6.0-3.x86_64.rpm
samba-3.0.33-3.29.el5_5.1.x86_64.rpm
samba-client-3.0.33-3.29.el5_5.1.x86_64.rpm
system-config-samba-1.2.41-5.el5.noarch.rpm
vsftpd-2.0.5-16.el5_5.1.x86_64.rpm
3.[root@erptest rpm]# system-config-samba
4. close
5.click on preferences
6. add user
7. and bounce ther samba sercer  $ service smb restart






 

Samba server configureation

Server side configuration

1.      Login as root on Linux User

2.      Check VNC packages are installed or not as shown below

Results showing that we have required packages

3.      Now check smb, portmap, xinetd should be made on.(You can select by clicking the spacebar)

             

             

          

4.      Now restart the smb, portmap and  xinetd  service.

5.      To keep the services after reboot

#chkconfig  portmap on   

#chkconfig  xinetd on     

#chkconfig  samba on        

6.      Create a OS User

Ex:dvis

#useradd dvis

#passwd dvis

7.      Open /etc/samba/smb.conf

vi /etc/samba/smb.conf

8.      By default name of the workgroup is MYGROUP  in smb.conf. We can change it with desired name.

9.      Share $XXARG_TOP/forms/US & $AU_TOP/ forms/US  for user dvis – so go in the end of line  add the following

Clinet side configuration

1. Go to windows system ping the samba server, check the workgroup you given is correct.
2. If not change & restart the system

3.      After reboot open my network place here you can see samba server, if not go to RUN  enter

             \\ipaddress of samba server.

4.      It will ask for username & password:

dvis

dvis2011

OEM Issue after dbca database otions

if issue with ralated secure or em key

then

1.emctl status emkey -sysman_pwd argprod4
2.cd sysman/admin/emdrep/bin/
3.RepManager proddb 1521 PROD -action drop
4.emca -config dbcontrol db -repos create

Event Alert Does Not Fire Or Check Event Alert ( ALECTC ) Concurrent Request Does Not Start [ID 1261925.1]

Event Alert Does Not Fire Or Check Event Alert ( ALECTC ) Concurrent Request Does Not Start [ID 1261925.1]

frmplsqlconv.sh unable to connect to database

frmplsqlconv.sh  to upgrade forms from 6i to 10g forms ..getting error to connect database .


 Solution :
frmcmp.sh or frmcmp_batch.sh , frmplsqlconv.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin
go to $ORACLE_HOME/bin (10.1.2 )
See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN...
and change to
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN

Ref: 431324.1

OEM Configuration

how to create OEM in 11g

1.check the oratab (/etc/oratab)
2.check oraInst.loc (/etc/oraInst)
3.run dbca
4.chose database configuration options(if it is disable then need to check oratab
5.provide all email if want
6.dedicated server
7.finish

if issue with ralated secure or em key
then
1.emctl status emkey -sysman_pwd argprod4
2.cd sysman/admin/emdrep/bin/
3.RepManager proddb 1521 PROD -action drop
4.emca -config dbcontrol db -repos create

How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]

How to Register the Master GDF Diagnostic as a Concurrent Program

Registering The Concurrent Program(s)

There are 2 concurrent programs that can be defined

1. AP Data Validation Report
2. AP Single Transaction Data Validation Report

The first will allow you to schedule and run a concurrent process which will scan all transactions in a date range within specified operating units for any data integrity issues.  The second concurrent program will allow you to specify individual invoice and/or check transaction ID's for validation.

The simplest and quickest method for defining these concurrent processes in your instance is to upload the definition from the files below using FNDLOAD.

• AP Data Validation Report: APGDFVAL.ldt
• AP Single Transaction Data Validation Report:  APGDFVAL_SINGLE.ldt

These files can then be used to upload the concurrent program definitions using the following FNDLOAD command substituting in the correct password and ldt file name:

FNDLOAD apps/<appspw> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <ldtfilename> CUSTOM_MODE=FORCE

diagnostic script ap_gdf_detect_pgk.sql of AP

This diagnostic script ap_gdf_detect_pgk.sql  to identify known data integrity issues within your Payables application
1.Download the file ap_gdf_detect_pkg.zip . This file contains the package definition file ap_gdf_detect_pkg.sql as well as two wrapper scripts which can be used to submit the detection procedures:

• single_trx.sql: This script can be used to submit the validation procedure for a single transaction.
• date_range.sql This script will submit the validation procedure for a range of dates within specified operating units

2.First you must run the script ap_gdf_detect_pkg.sql as user APPS to create the package definition.  This is required each time you download a new version of the script.  Then you can run one of the wrapper files as described below.

RETRY PAYROLL RUN/RETROPAY FAILS WITH AN ERROR

Retry Payroll Run concurrent program fails with below error

   HR_6860_HRPROC_INVALID_PACTION
   APP-PAY-06860: Specified payroll is invalid.
   Cause:        The Payroll specified does not exist.

  RetroPay concurrent program fails with below error

  HR_6862_HRPROC_INV_NUM_ARGS
  PNAME RETROPAY
  APP-PAY-06862: An invalid number of arguments has been specified for this
  process.
  Cause: Either too few or too many arguments have been
  specified for the current process.

Solution : Apply patch 9863804

Ref:  1264959.1

HRMS read only

we can provide HR data only read only mode with profile
HR:Query Only Mode   to  yes
either at  user level or at responsibilitiy level .

WebADI Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

ISSUE:

Run-time error '1004':

Method 'VBProject' of Object'_Workbook' Failed
this issue reproduce when downloading the excel sheet via webADI .

SOLUSTION:
In Excel 2003:
go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab.  Check the box next to "Trust access to Visual Basic Project".
(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

In Excel 2007, use the following navigation:

• Click on the Office button in the upper left corner
• Click on the Excel Options button
• On the left, click on the Trust Center
• Click on the Trust Center Settings button
• On the left, click on Macro Settings
• Click on "Trust access to the VBA project object model"

Ref: 376013.1
       406526.1     

XML Concurrent Request with warning...

All xml concurrent requests completing with Warning


solution : increase  process of concurrent manager "Output Post Processor"

Automatic Asset Numbering Skips Numbers

Issue : Asset numbers appear to be skipping by a multiples of 20 or some other number

Solution :

 The following command will change the CACHE_SIZE to 0:  

  

           alter sequence fa_additions_s nocache; 

 

Ref: 1036833.6

Unable to authenticate session in R12 at login

1.Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
2.Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
3.Create a new IE8 icon adding the -noframemerging parameter e.g.
4.Start -> Program Files
5.Right click on the Internet Explorer icon and select Properties
6.Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
7..Click the OK button to close the window
8.This icon may then be copied to the desktop if desired


R12: Using IE8 to access two EBS Instances runs in error "Unable To Authenticate Session" [ID 1098563.1]

Printer configuration :network printer configuration in Linux

1.Install the CUPS
2.Open the CUPS Web interface by typing
"http://localhost:631/" into a browser window.

3.Click "Add Printer" under the Administration tab
4.Type the name of the networked printer as it is named on
the server.printer name as same as machine name in test
print in windows UNNI1
5.Type a location. This could be the IP address of the
printer
6 .Add a description. This can be anything or it can be
left blank.
7.Choose "Internet Printing Protocol (IPP)" from the
"Device" drop-down menu.
8. Device: select "AppSocket/HP JetDirect"
9.Device URI: socket://172.16.50.13:9100(printer ip)
10.Make:HP
11.Driver : HP Leser Jet 4050
12. provide root password
13.Click "Print Test Page."


 

FNDLOAD the complete

What FNDLOAD can be done?
These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules


Some sample examples:

1.MENU:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct menu.ldt
MENU MENU_NAME=BOM_NAV

FUNCTION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
function.ldt FUNCTION FUNCTION_NAME=INV_INVTTMTX

FORM:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form.ldt
FORM FORM_NAME=${shortname}

PERSONALIZATION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
formpersonalization.ldt FND_FORM_CUSTOM_RULES function_name=${shortname}

Upload
FNDLOAD apps/apps  0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPO_PURCHASEORDER.ldt 


PRINTER:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct
printer.ldt STYLE PRINTER_STYLE_NAME=${shortname}

CONCURRENT:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
concprog.ldt PROGRAM CONCURRENT_PROGRAM_NAME=${shortname}

LOOKUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct
lookup.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE=${shortname}

RESPONSIBILITY:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afscursp.lct
responsible.ldt FND_RESPONSIBILITY RESP_KEY="${respkey}"

DESCFLEX:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
${shortname}_flex.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=${shortname}

KEYFLEX:
FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
keyflex.ldt KEY_FLEX
P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL: CVR_ALL:SEG_ALL'
APPLICATION_SHORT_NAME=${appshortname} ID_FLEX_CODE=MCAT
P_STRUCTURE_CODE=${shortname}

VALUE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
valset.ldt VALUE_SET FLEX_VALUE_SET_NAME=${shortname}

PROFILE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct
profile.ldt PROFILE PROFILE_NAME=${shortname}

MESSAGE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
message.ldt FND_NEW_MESSAGES MESSAGE_NAME=${shortname}

REQUEST GROUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
reqgrp.ldt REQUEST_GROUP REQUEST_GROUP_NAME=${shortname}

REQUEST SET:
OAUG Forum at COLLABORATE 08 Page 6
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct
rqstset.ldt REQ_SET APPLICATION_SHORT_NAME="FND"
REQUEST_SET_NAME=${shortname}

WEBADI:
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct
XX_C_O_F_T.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="XX_C_O_F_T"

Blob:
With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained

Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data

References:
Note: 274667.1 FNDLOAD Commands to Download Different Seed Data Types.
Note: 287417.1 Parameters Of Different Configuration Files To Download And Upload Seed Data Types.
Note: 256573.1 How To Download/Upload Descriptive Flexfield With Name $SRS$
EBS Release 11.5.10.2+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.0.4+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.1.3 : Oracle Applications System Administrator's Guide - Configuration
Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code, Brad Simmons and Donna Campbell,
Los Alamos National Laboratory document
Tips About FNDLOAD [ID 735338.1]
Is It Possible To Use FNDLOAD To Migrate Configurations Or Data To Another Instance? [ID 1316916.1]
How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1