Posts Tagged ‘oracle error’

RECEIPT APPLICATION ERROR: APP-FND-00531

April 28th, 2018, posted in Oracle Queries
Share
제품 : FIN_AR
작성날짜 : 2003-11-18
RECEIPT APPLICATION ERROR: APP-FND-00531
========================================
PURPOSE
-------
Receipt Application 시 발생하는 error를 효과적으로 해결한다.
Problem Description
-------------------
Applications 11.0.3:
Transaction을 생성 한 후 Receipt 과 Apply 할 때 다음과 같은 error 가 발생하였다.
APP-FND-00531 Amount Cannot Be Correctly Formatted
The Amount XXX.XXX Could Not Be Formally Formatted.
The Correct Format Is 999.99 And -999.99

Workaround
----------
1. 해당 data 를 bakcup 받아 놓는다.
2. 다음 update script을 수행한다.
Update ar_payment_schedules_all
set amount_due_original = round(amount_due_original,2),
amount_due_remaining= round(amount_due_remaining,2),
acctd_amount_due_remaining = round (acctd_amount_due_remaining, 2)
where customer_trx_id=xxx
update ra_customer_trx_lines_all
set extended_amount=round(extended_amount,2)
where customer_trx_id=xxx and line_type='TAX'
update ra_cust_trx_line_gl_dist_all
set amount=round(amount,2)
where customer_trx_id=xxx

Solution Description
--------------------------
Applications 11.0.3에서 Tax / Freight Defaultation Program이 rounding 처리를 잘 못하여 ra_cust_trx_line_gl_dist_all 에 데이타가 corrupted 된 것으로 보인다.
잘 못된 data를 rounding 처리하여 저장해준다.
Reference Documents
-------------------
Note 247018.1
Share

adcfgclone.pl dbTechStack – RC-50004 Error occurred in CloneContext Target System Domain Name

February 4th, 2018, posted in Oracle, Solaris
Share

RC-50004: Error occurred in CloneContext – Target System Domain Name in

adcfgclone.pl dbTechStack :

Error:

Target System Domain Name : worths.co.za
RC-50004: Error occurred in CloneContext: 
null
Check Clone Context logfile
/ebsdbprd_app/oracle/product/ebsdbprd/db/tech_st/11.2.0/appsutil/clone/bin/CloneContext_0418120037.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_4849738.err if present.


adcfgclone.pl,oracle apps,oracle dba,oracle apps dba,oracle,dba,oracle error,ora error,oracle errors,adcfgclone.pl dbTechStack RC-50004 Error occurred in CloneContext Target System Domain Name,Target System Domain Name,adcfgclone.pl dbTechStack,RC-50004 Error,RC-50004,Error,clone error,oracle clone error,apps error,database error,oracle database,database oracle error,database,APPS-domain-50004,APPS domain 50004,RC 50004,RC 50004 Error

 

Solution :
Ensure that your hostname is fully populated in the /etc/hosts file

Not like this:

3 $ grep ebsdbprdp7 /etc/hosts
19.36.148.157   ebsdbprdp7
w@ebsdbprdp7:/
4 $

Should look like this

3 $ grep ebsdbprdp7 /etc/hosts
19.36.148.157   ebsdbprdp7.domain.co.za  ebsdbprdp7
w@ebsdbprdp7:/
4 $
Share

Cancel All Pending Concurrent Request

December 27th, 2017, posted in Oracle Queries
Share

Oracle : Cancel All Pending Concurrent Request

Updating base tables directly is not supported or recommended by Oracle – this update would be OK to execute in a non-production instance. In a production instance, use APIs or cancel the pending requests thru the forms interface

 

update FND_CONCURRENT_REQUESTS set phase_code='C',status_code='D' where phase_code='P' ;
Share

RC-00118 Error Occurred During Creation Of Database

December 10th, 2017, posted in Oracle
Share

I was cloning PROD to DEV instance … when I am configuring DEV instance , got following errors.

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

ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             427820216 bytes
Database Buffers          624951296 bytes
Redo Buffers               13930496 bytes

Control file created.

alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oracle/DEV/oradata/DEV/system01.dbf'


alter tablespace TEMP1 add tempfile '/u02/oracle/DEV/oradata/DEV/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


alter tablespace TEMP2 add tempfile '/u02/oracle/DEV/oradata/DEV/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE RENAME GLOBAL_NAME TO "DEV.localhost"
                                     *
ERROR at line 1:
ORA-01109: database not open

ORA-01109: database not open


Error Running create/replace library with adupdlib.sql
ORA-01109: database not open

PL/SQL procedure successfully completed.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
exit_code=0

Checking for errors ...

The database has not been successfully created. Shutting down the instance ...

SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 1 01:26:22 2014

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

Connected.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

.end std out.

.end err out.

---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : localhost
    sDbDomain  : localhost.domain.com
    sDbPort    : 1530
    sDbSid     : DEV
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@localhost:1530:DEV
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=DEV)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=DEV.localhost)))
    Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase


StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)
        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Thread.java:637)

                                                                   

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

In my case, control file were created successfully, but above error indicates that database was not created successfully.

I found root of this issue that when i had copied PROD binaries and data files at same time some services were running using ORACLE user.

Note: You would get this error if oracle database was not properly shutdown when you copied the files.

All my stuff were wasted.
So, I have copied only datafiles again from PROD to DEV.
And ran adcfgclone.pl dbTier again and cloning has been completed successfully without any error !!

Share