Archive for the ‘Oracle EBS Application’ Category

ENABLE DIAGNOSTICS IN ORACLE APPLICATIONS R12

August 7th, 2023, posted in Oracle EBS Application
Share
Users may not able to able to see Help >Diagnostics option or get an error “Function Not Available to this Responsibility. Please check with your system administrator.”

These profiles need to be set at user level. So specific user can access this functionality (ex. Support folks/Developers)

Navigation: Go to System Administrator responsibility
Profile> System

Profile Option Name: Utilities:Diagnostics
User Level: Yes

Profile Option Name: Hide Diagnostics menu entry
User Level: NO

Save changes
Have user logout of Oracle Application and login again

User should be able to access Help >Diagnostics Menu

Share

ORA-01438 Value Larger Than Specified Precision Allowed For This Column AP_AC_TABLE_HANDLER_PKG.INSERT_ROW

March 1st, 2023, posted in Oracle EBS Application
Share

SYMPTOMS

Payment Workbench(APXPAWKB) > When try to save the payment , following error appear:

ERROR
-----------------------
APP-SQLAP-10000 ORA-01438 Value Larger than specified Precision allowed for this column occurred
in AP_AC_TABLE_HANDLER_PKG.INSERT_ROW <AP_CHECKS_PKG.INSERT_ROW>
With Parameter (ROWID= , CHECK_ID=&check_id) while performing the following operation insert into ap_checks

 

ORA-01438 Value Larger,R12: AP: APXPAWKB,ORA-01438 Value Larger Than Specified Precision Allowed,AP_AC_TABLE_HANDLER_PKG.INSERT_ROW

Click to Viewer Larger

 

CAUSE

The cause of the issue is invalid / incorrect Payment Document Number
Payment Document Number should not have more than 15 digits

 

 

SOLUTION

This error is displayed when you enter more than 15 digits in the payment document number.
Please enter the payment document number less than 15 digits and recheck.

 

 

Click to Viewer Larger

Share

Find the Seeded Table,Transactional Tables, Static Data

September 11th, 2022, posted in Oracle EBS Application, Oracle Queries
Share

You can tell based on the TABLESPACE the table belongs to – this is the new Oracle Applications Tablespace Model (OATM)

Run the following code to see:

SELECT tablespace_name, table_name
FROM all_tables
WHERE tablespace_name LIKE '%SEED%' -- seeded data
AND table_name LIKE 'FND%'

SELECT tablespace_name, table_name
FROM all_tables
WHERE tablespace_name LIKE '%TX%' -- transaction data
AND table_name LIKE 'FND%'

SELECT tablespace_name, table_name
FROM all_tables
WHERE tablespace_name LIKE '%ARCHIVE%' -- static data
AND table_name LIKE 'FND%'
Share

Oracle EBS Application [UNEXPECTED] java.io.FileNotFoundException

September 4th, 2022, posted in Oracle EBS Application
Share

The concurrent program the output of which is XML report is failing in warning and the log shows the below message:
Beginning post-processing of request 5292785 on node AP6105RT at 02-AUG-2006 04:47:48. Post-processing of request 5292785 failed at 02-AUG-2006 04:49:48 with the error message:

The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. Example if the response time is set to 60 make it at-least 180. Bounce the concurrent manager once this is done. This will resolve the issue.

If the issue still persist, check the OPP log file. You follow below navigation

System Administrator -> Concurrent : Manager -> Administrator

On this screen click on Output Post Processor and then click on Processes button -> Manager Log button

 

Error : 

 

[11/10/19 10:27:07 AM] [OPPServiceThread1] Post-processing request 16359131.
[11/10/19 10:27:07 AM] [820550:RT16359131] Executing post-processing actions for request 16359131.
[11/10/19 10:27:07 AM] [820550:RT16359131] Starting XML Publisher post-processing action.
[11/10/19 10:27:07 AM] [820550:RT16359131] 
Template code: XXSD_RDF_TO_XML_PROC
Template app:  AR
Language:      en
Territory:     00
Output type:   EXCEL
[11/10/19 10:27:07 AM] [UNEXPECTED] [820550:RT16359131] java.io.FileNotFoundException:
        /usr/tmp/xml/xdoSBWzBuUW6V111019_1027079523.fo (No such file or directory)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
	at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
	at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
	at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
	at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
	at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)
	at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)

[11/10/19 10:27:07 AM] [820550:RT16359131] Completed post-processing actions for request 16359131.

 

Cause :

The Temporary directory for XML Publisher has not been modified after making the clone so it was pointing to non existing location and getting error out.

 

Issue :

Issue was with XML Publisher temporary directory path.

 

Solution :

1. Create a new Temporary Directory on OS level for the cloned environment.
2. Make sure that the application owner (APPLMGR) has Read and Write permission this directory.
3. Setup this new directory for XML Publisher via :
XML Publisher Administrator responsibility: Properties -> General -> Temporary Directory.

3. Restart the Server.
4. Test again with a XML Publisher Report.

Share

ORA-25153: Temp Tablespace error on adconfig.sh

July 24th, 2022, posted in Oracle, Oracle EBS Application
Share

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

                                                        If This Error Facing on Adconfig.sh or autoconfig.sh
=======================================================================

Atempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() :
Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3);
END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests
ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3);
END;: 1; Oracle error -1187: ORA-01187: cannot read from file 515 because it failed verification tests
ORA-01110: data file 515: '/oradata/proddb/data/temp03.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:220)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1688)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
FAILED
COMPLETED

=======================================================================================================================================================
                                             Solution Apply
============================================================================================================================================
login as: dgdb
dgdb@192.168.1.80's password:
Last login: Mon May  2 15:54:08 2016 from 192.168.81.61
[dgdb@b6dgdb ~]$ cd /oradb/proddb/PROD/db/tech_st/11.1.0/
[dgdb@b6dgdb 11.1.0]$ . ./T2_b6dgdb.env
[dgdb@b6dgdb 11.1.0]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon May 2 16:46:14 2016

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
sql> select bytes/1024/1024 from dba_temp_files;
select bytes/1024/1024 from dba_temp_files
*
ERROR at line 1:
ORA-01187: cannot read from file 513 because it failed verification tests
ORA-01110: data file 513: '/oradata/proddb/data/temp01.dbf'

SQL> col name format a50
SQL> run
1* select file#,status,name from v$tempfile

FILE# STATUS  NAME
---------- ------- --------------------------------------------------
1 ONLINE  /oradata/proddb/data/temp01.dbf
2 ONLINE  /oradata/proddb/data/temp02.dbf
3 ONLINE  /oradata/proddb/data/temp03.dbf

SQL> col DESCRIPTION format a40
SQL>
SQL> SELECT * FROM   database_properties WHERE  property_name like '%TABLESPACE'

PROPERTY_NAME                  PROPERTY_VALUE                           DESCRIPTION
------------------------------ ---------------------------------------- ----------------------------------------
DEFAULT_TEMP_TABLESPACE        TEMP                                     ID of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE   SYSTEM                                   Default Permanent Tablespace ID

CREATE TEMPORARY TABLESPACE temp3 TEMPFILE '/oradata/proddb/data/temp_01' SIZE 1024M TABLESPACE GROUP temp;

alter tablespace temp3 add tempfile  '/oradata/proddb/data/temp_02' SIZE 1024M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;

SQL> SELECT * FROM dba_tablespace_groups;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEMP                           TEMP1
TEMP                           TEMP2

DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

sql> select TABLESPACE_NAME,FILE_NAME from dba_temp_files

TABLESPACE_NAME                FILE_NAME
------------------------------ ----------------------------------------
TEMP3                          /oradata/proddb/data/temp_02
TEMP3                          /oradata/proddb/data/temp_01

========================================================================================================================================
                                              Then Run Adconfig.sh
========================================================================================================================================
login as: dgapps
dgapps@192.168.1.81's password:
Last login: Mon May  2 16:24:32 2016 from 192.168.81.61
[dgapps@c6dgapps ~]$ cd /oraapps/prodapps/
oraInventory/ PROD/
[dgapps@c6dgapps ~]$ cd /oraapps/prodapps/PROD/apps/apps_st/appl/
[dgapps@c6dgapps appl]$ cd ad/12.0.0/bin
[dgapps@c6dgapps bin]$
[dgapps@c6dgapps bin]$ sh adconfig.sh
Enter the full path to the Context file:/oraapps/prodapps/PROD/inst/apps/T2_c6dgapps/appl/admin/T2_c6dgapps.xml
Share