0004863: SL_CashJournal_Amounts_data.xsql doesn't compile

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004863

Openbravo ERP

Z. Others

public

2008-09-08 21:34

2008-12-14 21:11

Reporter

jpabloae

Assigned To

cromero

Priority

immediate

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Gentoo - 2.6.24

Product Version

Target Version

2.50

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004863: SL_CashJournal_Amounts_data.xsql doesn't compile

Description

Some database objects are in invalid state and they don't let some xsql files to be run correctly:

    [java] 5225 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_callouts/SL_CashJournal_Amounts_data.xsql processed
     [java] 5295 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT C_Currency_Convert((CASE ISRECEIPT WHEN 'Y' THEN p.AMOUNT ELSE -p.AMOUNT END), p.C_Currency_ID, (SELECT b.C_CURRENCY_ID
     [java] FROM C_CASH C, C_CASHBOOK B
     [java] WHERE C.C_CASHBOOK_ID = B.C_CASHBOOK_ID
     [java] AND C.C_CASH_ID = ?),
     [java] (SELECT STATEMENTDATE FROM C_CASH WHERE C_CASH_ID = ?),null,p.AD_Client_ID,p.AD_Org_ID) as amount
     [java] FROM C_DEBT_PAYMENT p
     [java] WHERE C_DEBT_PAYMENT_ID = ?
     [java] Exception:java.sql.SQLException: ORA-06575: Package or function C_CURRENCY_CONVERT is in an invalid state

Steps To Reproduce

Proposed Solution

Additional Information