Oracle Applications DBA

Wednesday, March 21, 2012

ORA-00959: TABLESPACE '_$DELETED$11$0' DOES NOT EXIST

######################################################
ORA-00959: TABLESPACE '_$DELETED$11$0' DOES NOT EXIST
#######################################################
we got the above error after cutdown process for few tables, as a workaround for this error we need to identify impacted partition tables/indexes:

Here is the query to identify impacted partition tables/indexes:
-------------------------------------------------------------------------
SET lines 180
COL segment_name format a55
SELECT DISTINCT table_name segment_name, def_tablespace_name
           FROM dba_part_tables
          WHERE def_tablespace_name LIKE '%deleted%'
UNION
SELECT DISTINCT index_name segment_name, def_tablespace_name
           FROM dba_part_indexes
          WHERE def_tablespace_name LIKE '%deleted%'
       ORDER BY 1
/

Query to generate the fix commands
-------------------------------------------------------------------------
SELECT DISTINCT    'ALTER TABLE '
                || owner
                || '.'
                || b.table_name
                || ' MODIFY DEFAULT ATTRIBUTES TABLESPACE '
                || tablespace_name
                || ';'
           FROM dba_part_tables b, dba_tab_partitions d
          WHERE d.table_name = b.table_name
            AND def_tablespace_name LIKE '%deleted%'
UNION
SELECT DISTINCT    'ALTER INDEX '
                || owner
                || '.'
                || b.index_name
                || ' MODIFY DEFAULT ATTRIBUTES TABLESPACE '
                || tablespace_name
                || ';'
           FROM dba_part_indexes b, dba_ind_partitions d
          WHERE d.index_name = b.index_name
            AND def_tablespace_name LIKE '%deleted%'
/

18:28:23 [SYS][ORQ21]>> select owner, table_name, def_tablespace_name from dba_part_tables where lower(def_tablespace_name) like '%deleted%';

OWNER                          TABLE_NAME                  DEF_TABLESPACE_NAME
------------------------------ -------------------------- ------------------------------
MGIXX                          MGIHZ_EXTR_RQST_CNTL_PARMS _$deleted$393$0
MGIXX                          MGIAR_TRANS                 _$deleted$393$0 ? this is the table they accessed and hit with “ORA-959”
MDSYS                          OLS_DIR_BUSINESSES          _$deleted$393$0

18:36:15 [SYS][ORQ21]>> alter table MDSYS.OLS_DIR_BUSINESSES modify default attributes tablespace SYSTEM;

18:36:59 [SYS][ORQ21]>> alter table MGIXX.MGIAR_TRANS modify default attributes tablespace MGIXX_DATA;

18:37:23 [SYS][ORQ21]>> alter table MGIXX.MGIHZ_EXTR_RQST_CNTL_PARMS modify default attributes tablespace MGIXX_DATA;

18:37:44 [SYS][ORQ21]>> select owner, table_name, def_tablespace_name from dba_part_tables where lower(def_tablespace_name) like '%deleted%';

Tuesday, March 20, 2012

WHICH SESSIONS GENERATING MORE REDO LOGS IN ORACLE

##################################################
WHICH SESSIONS GENERATING MORE REDO LOGS IN ORACLE
##################################################

SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc;

SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5,6 desc;

According to the Redo generation size.
-----------------------------------------
select sid, name,
round(value/1024/1024) redo_mb
from v$statname n, v$sesstat s
where n.name like 'redo size'
and s.statistic# = n.statistic#
/

Below Query will list the top 10 redo generated sessions info.
----------------------------------------------------------------
select b.inst_id, b.SID, b.serial# sid_serial, b.username, machine, b.osuser, b.status, a.redo_mb MB
from (select n.inst_id, sid, round(value/1024/1024) redo_mb from gv$statname n, gv$sesstat s
where n.inst_id=s.inst_id and n.statistic#=134 and s.statistic# = n.statistic# order by value desc) a, gv$session b
where b.inst_id=a.inst_id
and a.sid = b.sid
and rownum <= 10;

Saturday, March 17, 2012

How To Clear Too Many Pending Requests For Password Reset [ID 875559.1]

On 12.0.6 in Production:
When attempting to use the "FORGET PASSWORD" feature from the Oracle Applications, the
user is unable to reset it's password due to the following error:

ERROR
Too many pending requests already exists in the system. Please check your email or contact the
System Administrator for further assistance.

Cause

The cause of the issue is that there are five 'Forgot password' requests that are currently active
for a user that have possibly timed out but not been processed by 'Workflow Background Process'.

If user doesn't respond within 4 hours after receiving email notification to reset password, the activity will time out but will remain active till 'Workflow Background Process' is run to process 'Timeout'
activities. When the number of such requests for a user exceeds five, the above warning message is displayed.

The following SQL shows status of request for a user:

select * from
(
SELECT WorkflowItemEO.ITEM_TYPE,
WorkflowItemEO.ITEM_KEY,
wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE,
WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE,
WorkflowItemEO.ROOT_ACTIVITY,
WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE
FROM WF_ITEMS WorkflowItemEO,
WF_ITEM_TYPES_VL WorkflowItemTypeEO,
WF_ACTIVITIES_VL ActivityEO,
WF_ITEM_ATTRIBUTE_VALUES attrib
WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME
AND ActivityEO.ITEM_TYPE = WorkflowItemEO.ITEM_TYPE
AND ActivityEO.NAME = WorkflowItemEO.ROOT_ACTIVITY
AND ActivityEO.VERSION = WorkflowItemEO.ROOT_ACTIVITY_VERSION
AND attrib.item_type = WorkflowItemEO.ITEM_TYPE
AND attrib.item_key = WorkflowItemEO.ITEM_KEY
AND attrib.name = 'USER_NAME'
AND attrib.text_value = '<USER_NAME>'
) QRSLT
where
item_type = 'UMXLHELP';

.

Solution

To close the pending items, please execute the following steps:

1. submit concurrent request 'Workflow Background Process with following parameters:

Item Type : UMX Login Help
Process deferred: Yes
Process Timeout: Yes

2. Retest the issue after request completes to confirm that warning message no longer appears.

Form Compilation Against a 11g Database Hangs or Takes a Very Long Time [ID 880660.1]

When trying to compile some forms against an 11g Database using 'frmcmp.sh' and 'frmcmp_batch.sh' compilers, it seems to hang or it takes too much time (10 min +)
Compile command is like:
frmcmp_batch.sh module=test.fmb module_type=FORM compile_all=YES userid=scott/tiger@orcl

If we compile the same source with the same command line against the 9i/10g database there is no problem.

Cause

The cause of this problem has been identified and verified in an unpublished Forms Bug: 8557019 - APPSPERF: ONE SQL USING ALL_OBJECTS HAS PERFORMANCE ISSUE UNDER 11G INSTANCE. and the underlying unpublished Database (Dictionary) Bug: 8560951 - PERFORMANCE ISSUE WHEN RUNNING A QUERY IN 11G

These Bugs explain that there is a performance issue when executing a similar 'problematic' SQL Query against the 11g database like in the following example:

SELECT COUNT (*)
FROM ALL_OBJECTS
WHERE ( OWNER = 'SYS'
AND OBJECT_NAME = 'DBMS_JAVA'
AND OBJECT_TYPE = 'PACKAGE'
AND ALL_OBJECTS.STATUS = 'VALID' )
OR ( OWNER = 'SYSTEM'
AND OBJECT_NAME = 'ORA_DE_REFLECTION'
AND OBJECT_TYPE = 'PACKAGE'
AND ALL_OBJECTS.STATUS = 'VALID' )
OR ( OWNER = 'SYSTEM'
AND OBJECT_NAME = 'oracle/opb/Reflection'
AND OBJECT_TYPE = 'JAVA CLASS'
AND ALL_OBJECTS.STATUS = 'VALID' )
OR ( OWNER = 'SYSTEM'
AND OBJECT_NAME = 'oracle/opb/SchemaClassLoader'
AND OBJECT_TYPE = 'JAVA CLASS'
AND ALL_OBJECTS.STATUS = 'VALID' ) ;

Solution

To implement the solution, you can either:

A). First, apply the database Patch 8560951 on top of your Database.

Important Notes:

The Patch 8560951 brings modifications in a sensible area and it is needed to use _FIX_CONTROL to enable the fix. This can be done usually either at the DB or session level, but here, as the compiler will launch its own session, it is needed to activate the fix at the DB level.
This patch is already included in higher database versions (e.g. 10.2.0.5, 11.2.0.2). For these it's not necessary to install the patch.
But, "_FIX_CONTROL"='8560951:ON' still needs to be set as the fix is disabled by default.

Second, execute an additional step on your database to activate this fix:

SQL> ALTER SYSTEM SET "_FIX_CONTROL"='8560951:ON''

This will enable the fix in memory. If needed to restore things as they were, you can similarly turn the fix off with:

SQL> ALTER SYSTEM SET "_FIX_CONTROL"='8560951:OFF''

More info about _FIX_CONTROL in:
NOTE 782926.1 Info About Hidden Parameter _fix_control
(You can add scope=spfile and restart the DB to have the fix remain active in the future.)

OR

B) Use the following workaround:

1 Connect to the DB with SQL*Plus as the user who compiles the Forms application

2. Use the following command to create a synonym all_objects with:

SQL> create synonym all_objects for sys.dba_objects;

Note. If it's not working, grant SELECT privelege on sys.dba_objects to the user who will be compiling the form.

3. Compile again your Form.

If you want at the end, you can drop this synonym with:

SQL> drop synonym all_objects;

Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12

The purpose of this document is to provide guidelines for setting up JVMs (Jserv groups/OC4J instances) for online applications in Apps 11i and R12.

This is supposed to be a generic rule of thumb or a starting point. This document is written based on Sun's JDK. Other platforms, like Linux and HP, can also use pretty much the same parameter. AIX does not have all those parameters and some differences will be pointed. Although there are differences in the JDK parameters, the concepts presented here should apply to all platforms.

Although this has shown to be sufficient for most of the Apps 11i and R12 installations, some additional tuning may be necessary.

Scope and Application

Oracle Application 11i (11.5.9 and up) and R12

Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12

JDK Version:

It is recommended to use JDK 1.6, because of better performance and additional features. On Solaris and Linux, Sun's JVM will automatically detect whether the Hotspot Server Compiler or the Client Compiler should be used based on the number of CPUs and memory available on the machine.

It is recommended also to use always the latest version for the specific JDK release.

For information about upgrading the JDK, refer to:
Note 401561.1 Using J2SE Version 6.0 with Oracle E-Business Suite 11i
Note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12.
Note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12

Number of JVMs:

1) For OACoreGroup:

Assumption: eBusiness Suite is running in a 2-tier environment (middle tier in a separate machine)

- No more than 100 active users per JVM/OC4J instance

- There should be no more than 1 active JVM/OC4J instance per CPU (ideally, there should be 1 JVM per 2 CPUs)

- Watch out for available memory (make sure that you have enough memory to run all the configured JVMs/OC4J instances without swapping)

Note: Each 'core' in a multi-core system is considered to be a separate CPU. For example, a dual quad-core chip would be the same as stating 2 x 4 x CPU or 8 CPUs.

In regards to hyper-threading cores, in theory the same thing applies, but in some cases it didn't equate to the exact same as a separate core. One could tune greater then a single CPU, but not treating the same as two CPUs.

2) For FormsGroup:

For the forms servlet, the actual JVM/servlet usage is minimal, and a single JVM can normally handle up to 100-250 forms users.

Note: that depends on the type of forms. For more complex forms, those numbers are likely to be substantially lower

Notes:
a) The number of jvms (oc4j in R12) is configured by the autoconfig variables s_oacore_nprocs, s_disco_nprocs, s_forms_servlet_nprocs and s_xmlsvcs_nprocs.

b) In 11i, those changes are made in the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.conf file, while in R12 in the $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

Heap Configuration:

1) For OACore, start with the following configuration:

For R12.0 and 11i:

-Xmx512M -Xms256M -XX:MaxPermSize=128M
-XX:NewRatio=2 -XX:+PrintGCTimeStamps

For R12.1 and higher:

      -Xmx1024M -Xms512M -XX:MaxPermSize=256M
      -XX:NewRatio=2 -XX:+PrintGCTimeStamps

     Also, ensure you add the following parameter to the DBC file:

     JDBC\:oracle.jdbc.maxCachedBufferSize=262144

Adjust the heap sizes accordingly to minimize garbage collection frequency and user pause times due to full garbage collections.

In JDK 1.6, the JVM detects that you have a server class machine (2 or more CPUs with 2GB or more memory), and will automatically enable Parallel Throughput Garbage Collector. The number of GC threads defaults to the number of CPUs on the machine. If you are running multiple JVMs on the same machine, or if your machine has more than 2 CPUs, to avoid the GC threads to be overly active you should reduce the number of GC threads by using:

-XX:+UseParallelGC -XX:ParallelGCThreads=2

In most cases, using 2 GC threads should be sufficient. If you are using heap size of over 1GB, you can experiment with 4 GC threads and see if it gives you better performance.

2) If using Forms in Servlet mode, the following configuration for FormsGroup should be enough for most of the cases:

-Xmx256M -Xms128M -XX:MaxPermSize=128M -XX:NewRatio=2

Notes:
a) The heap is configured by the following autoconfig variables:
11i: s_jvm_options, s_forms_jvm_options
R12: s_oacore_jvm_start_option, s_forms_jvm_start_options,

b) In 11i, those changes are made in the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties file, while in R12 in the $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

Additional Recommendations:

1) It is recommended to use Forms in socket mode which is more efficient than servlet mode, unless there is a requirement to use servlet (like, need for external users access).

2) Although the setup of those parameters can be temporarily done manually changing (jserv.conf and jserv.properties in 11i; opmn.xml in R12), the correct way to update those parameters is using the context editor, update the variables s_oacore_nprocs and s_forms_servlet_nprocs, and then run autoconfig.

3) Oracle Development recommends to be on the last ATG rollup patch, which is currently ATG-rollup7 (Note.783600.1).

5) Make sure to have the following setting in the jserv.properties file:
wrapper.bin.parameters=-DLONG_RUNNING_JVM=true

If there is any entry in jserv.properties setting -DCACHEMODE, either comment it out or remove that entry:
#wrapper.bin.parameters=-DCACHEMODE=LOCAL

6) Check also recommended patches for Performance issues in:
Note 244040.1 - Oracle E-Business Suite Recommended Performance Patches

7) AIX accepts only the parameters "-Xmx" -Xms". The reminder of the parameters should not be used on those platforms. More
More info about JDK parameters on AIX can be found at
http://www.ibm.com/developerworks/ibm/library/i-garbage3.html

8) A very good comparison of jdk parameters can be find at
http://blogs.sun.com/watt/resource/jvm-options-list.html

ORA-29701: unable to connect to Cluster Manager

Needs an ASM Bounce for this Issue as resolution with a small change as below

[asm@dev123~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 6 01:23:24 2011

Connected to an idle instance.

SQL> startup

ORA-29701: unable to connect to Cluster Manager

SQL> exit

Resolution:

As root User,

[user1@dev123~]$ sudo su -

[root@dev123 ~]# cd /u06/app/oracle/product/11.1.0/asm/bin ßASM Home

[root@dev123 bin]# ./localconfig delete

Stopping Cluster Synchronization Services.

Unable to communicate with the Cluster Synchronization Services daemon.

Shutdown has begun. The daemons should exit soon.

Cleaning up Network socket directories

[root@ddev123 bin]#

[root@dev123 bin]# ./localconfig add

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Configuration for local CSS has been initialized

Cleaning up Network socket directories

Setting up Network socket directories

Adding to inittab

Startup will be queued to init within 30 seconds.

Checking the status of new Oracle init process...

Expecting the CRS daemons to be up within 600 seconds.

Cluster Synchronization Services is active on these nodes.

dev123

Cluster Synchronization Services is active on all the nodes.

Oracle CSS service is installed and running under init(1M)

[root@dev123 bin]#

[root@dev123 bin]# ps -ef|grep css

root 16699 1 0 01:27 ? 00:00:00 /bin/sh /etc/init.d/init.cssd run

root 16974 16699 0 01:27 ? 00:00:00 /bin/sh /etc/init.d/init.cssd daemon

asm 17164 16974 0 01:27 ? 00:00:00 /u06/app/oracle/product/11.1.0/asm/bin/ocssd.bin

root 17170 16699 0 01:27 ? 00:00:00 /bin/sh /etc/init.d/init.cssd diskmon

root 17475 15609 0 01:27 pts/5 00:00:00 grep css

[root@dev123 bin]#exit

As asm User,

[user1@dev123 ~]$ sudo su - asm

[asm@dev123~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 6 01:28:31 2011

Connected to an idle instance.

SQL> startup

ASM instance started

Total System Global Area 175382528 bytes

Fixed Size 2157904 bytes

Variable Size 148058800 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

SQL> exit

PSU Patching failed with the below error OUI-67200 Make failed to invoke

Incase if you hit the below error while applying Oracle11g Patchset to RDBMS homes, here is the workaround/solution to fix that.

ERROR/ISSUE –

--------------------------------------------------------------------------------

The following warnings have occurred during OPatch execution:

……..

3) OUI-67200:Make failed to invoke "/usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u06/app/oracle/product/11.1.0/db_1"....'genclntsh: genclntsh: Could not locate /u06/app/oracle/product/11.1.0/db_1/network/admin/shrept.lst

make: *** [client_sharedlib] Error 1

4) OUI-67200:Make failed to invoke "/usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/u06/app/oracle/product/11.1.0/db_1"....'genclntsh: genclntsh: Could not locate /u06/app/oracle/product/11.1.0/db_1/network/admin/shrept.lst

make: *** [client_sharedlib] Error 1

5) OUI-67124:Re-link fails on target "client_sharedlib".

Re-link fails on target "client_sharedlib".

--------------------------------------------------------------------------------

SOLUTION –

--------------------------------------------------------------------------------

For 11.1, if the file is missing, create $ORACLE_HOME/network/admin/shrept.lst with a text editor and put the following lines into it.

network : snaumihi_inithostinfo
network : snaumbg_gmt
network : naedpwd_encrypt
network : naumbsb_bld_singlebyte
network : ztapis
network : nlgh

Using the 'ls -al' command, check that the file has 644 permissions:

-rw-r--r-- $ORACLE_HOME/network/admin/shrept.lst

If necessary, change the permissions using the command:

chmod 644 $ORACLE_HOME/network/admin/shrept.lst

Now manually relink using the command 'relink all'

--------------------------------------------------------------------------------

For more detail, refer Metalink note “genclntsh: Could not locate $ORACLE_HOME/network/admin/shrept.lst (Doc ID 340978.1)”

ORA-01092: ORACLE INSTANCE TERMINATED. DISCONNECTION FORCED

###########################################################
ORA-01092: ORACLE INSTANCE TERMINATED. DISCONNECTION FORCED
###########################################################

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2191112 bytes
Variable Size             426684664 bytes
Database Buffers          629145600 bytes
Redo Buffers               10915840 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 14492
Session ID: 690 Serial number: 1

Solution:
---------

check for alertlog..

create the undo tablespace.

CREATE UNDO TABLESPACE "UNDOTS2" DATAFILE '+OAD' SIZE 512M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2G, '+OAD' SIZE 512M REUSE AUTOEXTEND ON
NEXT 100M MAXSIZE 2G , '+OAD' SIZE 512M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2G;

adclonectxt.pl failed at the time of creating contextfile with Perl Issue.

Here is the below command for creating a context file under RAC environment, while creating the context file i have faced the below PERLissue and did the below workaround to fix the issue.

[oracle@hostname bin]$ perl adclonectx.pl \
> contextfile=/u01/app/oracle/product/11.1.0/db_1/appsutil/orp1_pmnalx1091.xml \
> template=/u01/app/oracle/product/11.1.0/db_1/appsutil/template/adxdbctx.tmp \
> pairsfile=/u01/app/oracle/product/11.1.0/db_1/appsutil/clone/pairsfile.txt \
> initialnode
Can't locate strict.pm in @INC (@INC contains: /ade/aime_perl58_amd64/perl58/bin/Linux/Opt/lib/5.8.3/x86_64-linux-thread-multi

/ade/aime_perl58_amd64/perl58/bin/Linux/Opt/lib/5.8.3 /ade/aime_perl58_amd64/perl58/bin/Linux/Opt/lib/site_perl/5.8.3/x86_64-linux-thread-multi

/ade/aime_perl58_amd64/perl58/bin/Linux/Opt/lib/site_perl/5.8.3 /ade/aime_perl58_amd64/perl58/bin/Linux/Opt/lib/site_perl .) at adclonectx.pl line 29.
BEGIN failed--compilation aborted at adclonectx.pl line 29.

Solution:
----------
[oracle@hostname db_1]$ pwd
/u2490/app/oracle/product/11.1.0/db_1

[oracle@hostname 5.8.3]$ echo $PERL5LIB

[oracle@hostname 5.8.3]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.8.3

[oracle@hostname 5.8.3]$ echo $PERL5LIB
/u2490/app/oracle/product/11.1.0/db_1/perl/lib/5.8.3

Now you can try again for creating the contextfile I hope the above workaround will solve the issue.

Saturday, January 14, 2012

Oracle E-Business Suite Technology

Oracle E-Business Suite Release 12.1.3 Now Available

By Steven Chan (Oracle Development) on Aug 20, 2010

I'm very pleased to announce that Oracle E-Business Suite Release 12.1.3 is now available for download:

Oracle E-Business Suite Release 12.1.3 Release Update Pack (Patch 9239090)

Oracle strongly recommends that all E-Business Suite customers upgrade to this release.
For installation instructions for EBS 12.1.3, see:

Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1)

This release update pack (RUP) combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set. This release is a maintenance pack and can only be installed on top of an existing EBS 12.1 environment.

What's New In This Release?
E-Business Suite 12.1.3 includes new product functionality, enhancements to existing functionality, and fixes for improved stability, security, and performance. Apps 12.1.3 is a cumulative update that includes all updates and fixes that were previously released on top of 12.1.1 and 12.1.2.

All E-Business Suite product families and nearly every product team have released new content in this release. You can find links to Release Content Documents (RCD) with details about new features, updates and fixes in the following Metalink Note:

Oracle E-Business Suite Release 12.1.3: Release Content Documents (Note 561580.1)

It also includes new features from the Applications Technology Group and support for new technology stack components, which I will cover in a separate article. For those of you eager to get those details now, see the Applications Technology Release Content Document linked from within Note 561580.1, above.

If you're looking for installation instructions for the ATG 12.1.3 Family Pack, see:

Oracle E-Business Suite Applications Technology Readme, Release 12.1.3 (R12.ATG_PF.B.delta.3, Patch 8919491) (Note 1066312.1)

References

Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1)
Oracle Applications Documentation Resources, Release 12.1 (Note 790942.1)
Oracle E-Business Suite Release 12.1 Information Center (Note 806593.1)
Oracle E-Business Suite Upgrade Guide, Release 11i to 12.1.3 (OTN, PDF, 1.4 MB)

Related Articles

Here is the link from the Oracle's blog for more Info:
http://blogs.oracle.com/stevenChan/entry/ebs_1213_available