RE: ORA-1801 Intermittently in OA Pages
- From: "Zydek, Steven" <steven.zydek@xxxxxxxxxxxxx>
- To: "ora-apps-dba@xxxxxxxxxxxxx" <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 6 Jul 2007 10:52:28 -0500
Thanks Navdeep! Oracle Support finally got back to us with this fix as well. I
wish I would have been told about this patch 3 months ago when I first reported
it!!
Thanks again,
+Steve
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Navdeep Singh
Sent: Friday, July 06, 2007 10:35 AM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: ORA-1801 Intermittently in OA Pages
Hi Steven
We used to get the same error in some of the requisition approvals in workflow.
We corrected it by applying database patch 5345437.
Thanks
Navdeep
On 7/3/07, Zydek, Steven
<steven.zydek@xxxxxxxxxxxxx<mailto:steven.zydek@xxxxxxxxxxxxx>> wrote:
I've gone around and around w/Oracle support about this issue we're having
where occasionally we receive a JBO-27122/ORA-1801 error regarding "format is
too long for internal buffer " (see below) on certain OA pages: Payslip,
Vacation Accrual and Appraisal pages. I've been trying to figure it out for a
couple months now to no avail!! I even had support suggest that we change the
'ICX: Date Format Mask' from DD-MON-YYYY to DD-MM-YYYY at the site level --
they thought this would do the trick and we didn't see the issue again for a
couple weeks, but lo and behold a few days ago it cropped up again...
I think I can get around the issue by flushing the shared_pool, but I don't
think this is good practice during normal working hours. We're running
11.5.10.2<http://11.5.10.2/> on HPUX 11.11 with 10.2.0.2<http://10.2.0.2/>
RDBMS. This issue is sporadic and can't be re-produced on demand or re-created
in test/dev. Any help would be much appreciated!!
Thanks,
+Steve
Our error message looks like the following:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122:
SQL error during statement preparation. Statement: SELECT * FROM (select
effective_date||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '||
action_information14||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '||
check_count payslip_choice,
action_context_id,
person_id,
effective_date
from pay_emp_payslip_action_info_v
where person_id = :3
and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT WHERE
(pay_us_employee_payslip_web.get_term_info( 0,person_id,action_context_id) =
'Y') ORDER BY effective_date desc
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122:
SQL error during statement preparation. Statement: SELECT * FROM (select
effective_date||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '||
action_information14||' - '||
pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '||
check_count payslip_choice,
action_context_id,
person_id,
effective_date
from pay_emp_payslip_action_info_v
where person_id = :3
and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT WHERE
(pay_us_employee_payslip_web.get_term_info( 0,person_id,action_context_id) =
'Y') ORDER BY effective_date desc
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:597)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest
(OAWebBeanContainerHelper.java:247)
at
oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
...
java.sql.SQLException: ORA-01801: date format is too long for internal buffer
Other related posts:
