AP_ACCTG_DATA_FIX_PKG Package Compilation Fails With Error

Issue:

ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors

SQL> select owner,object_name ,object_type,status from dba_objects where object_name like 'AP%' and status='INVALID';

OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------------------------------------------------------
APPS AP_ACCTG_DATA_FIX_PKG PACKAGE BODY INVALID

After applying GDF patch 11787050:R12.AP.B or any other patch requiring undo accounting, running the script "ap_undo_acctg.sql" throws the below error:

ERROR
-----------------------
ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.AP_ACCTG_DATA_FIX_PKG"
ORA-06512: at line 38

When trying to compile "APPS.AP_ACCTG_DATA_FIX_PKG", following errors are shown:

AP_ACCTG_DATA_FIX_PKG PLS-00394: wrong number of values in the INTO list of a FETCH statement

Solution:

Download for Patch 11772495:R12.AP.B (to fix the package apacpayb.pls) and Patch.12582979:R12.AP.B (to upgrade the version of apgdfalb.pls).

Check if the AP_ACCTG_DATA_FIX_PKG is now valid.

AutoPatch error: ERROR [code=11] Running adjcopy.class

Issue:

Running adjcopy.class:

adjava -mx1024m -nojit oracle.apps.ad.jri.adjcopy @/u01/oracle/DEV/apps/apps_st/appl/admin/DEV/out/apps.cmd
stat_low = B
stat_high = 0
emsg:was terminated by signal 11

AutoPatch error:
ERROR [code=11] Running adjcopy.class


AutoPatch error:
Error updating master archive


An error occurred while Updating Oracle Applications Java files if necessary.
Continue as if it were successful [No] :


Solution:

 Run the adrelink

$ adrelink.sh force=y ranlib=y "ad adjava"

Check the log file.

view /u01/oracle/DEV/apps/apps_st/appl/admin/log/adrelink.log

Once the adrelink completes successfully rerun the patch. This will resolve the issue.

OAM Applications Dashboard Collection Program completed error with DBC File Could not be found

Issue:

Issue is with after Refresh/Cloning Oracle Applications. 

Solution:

After Refresh few profiles were not changed in Post clone steps, So Profiles are pointing to source.

We need to change the below profile value source to Cloned instance name.

Bounce Apache Services and Test it.

FRM-92150 Web client version too new

Issue:

While we click the responsibility, the form opens at that time the following error comes:

FRM-92150 Web client version too new

Solution:

     1.   Go to Control Panel 

2.      Open Java from the Control Panel.

3.      Open press button "settings" on the general tab page.

4.      Click the button "delete files" to delete the cached jar files.

Click OK

5.      Re-open applications in fresh IE and Re-run the Form. You will able to forms without any issues.

How Do I Allow Remote Access/Connections To MySQL Database Server?

By default remote access to the MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server.

Step 1: Login into the server using os user which user under istalled mysql.

Ex: If you are installed os user under mysql

Login putty if you are using Linux or Unix-like systems.

Login as mysql


Step 2: Verify if you are able to access database using MySQL Connectors/MySQL drivers like JDBC etc..

If you getting error or not able to connect database follow below steps.

Step 3: By default MySQL only listens to localhost, if we want to enable the remote access to it, then we need to made some changes in my.cnf file as like below:

a. Stop services:

sudo service mysql stop

b. Edit my.cnf file and comment out the bind-address and skip-external-locking lines:

sudo su - root

vi /etc/mysql/my.cnf

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/English
#bind-address = 127.0..1

# skip-networking
....
..
....


c. sudo service mysql start

d. Verify port listening or not

   netsta -na|grep 3306

e.Grant permission to root from any host:

  mysql -u root -p

  GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password';

  Put % instead of your IP to allow access from any IP
  root is mysql database user

  FLUSH PRIVILEGES;

Step 4: Now you are able to access database using MySQL Connectors/MySQL drivers like JDBC etc..