0007046: Impossible to create periods for a year

Description

When you are creating the periods for a year the application displays a "Warning" and it doesn't create the periods.

Here is the log:
ERROR org.openbravo.erpCommon.ad_process.PinstanceProcedure - SQL error in query: CALL C_YearPeriods(?)Exception:
java.sql.SQLException: ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:212)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:951)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:45)
        at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
        at org.openbravo.erpWindows.FiscalCalendar.Year.doPost(Year.java:375)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:245)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:369)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:83)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
11:28:15 [http-8080-11] ERROR org.openbravo.scheduling.ProcessRunner - @CODE=6575@ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

java.lang.Exception: @CODE=6575@ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

        at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:49)
        at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
        at org.openbravo.erpWindows.FiscalCalendar.Year.doPost(Year.java:375)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:245)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:369)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:83)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)

Steps To Reproduce

1- As Openbravo Admin, go to Financial Management || Accounting || Setup || Fiscal Calendar || Calendar and select "BigBazaar Financial Calendar"
2- Go to year tab and create a new year, example "2009". Save it
3- Press the "Create Periods" button.

Proposed Solution

Ainhoa, I think the problem is that you are using not-Oracle compatible code in the C_YearPeriods procedure. Please check the functions you are using inside this procedure are both Oracle and PostgreSQL compatible.

Issue History
Date Modified	Username	Field	Change
2009-01-21 11:42	vmromanos	New Issue
2009-01-21 11:42	vmromanos	Assigned To	=> AinhoaPagola
2009-01-21 11:42	vmromanos	sf_bug_id	0 => 2525986
2009-01-21 11:42	vmromanos	Regression testing	=> No
2009-01-21 11:43	vmromanos	Relationship added	blocks 0006772
2009-01-21 12:43	AinhoaPagola	Status	new => acknowledged
2009-01-21 14:31	rafaroda	Status	acknowledged => scheduled
2009-01-21 14:31	rafaroda	fix_in_branch	=> trunk
2009-01-21 16:32	AinhoaPagola	Issue cloned	0007059
2009-01-21 16:32	AinhoaPagola	Relationship added	depends on 0007059
2009-01-21 16:37	svnbot	Checkin
2009-01-21 16:37	svnbot	Note Added: 0012459
2009-01-21 16:37	svnbot	Status	scheduled => resolved
2009-01-21 16:37	svnbot	Resolution	open => fixed
2009-01-21 16:37	svnbot	svn_revision	=> 12094
2009-01-23 11:32	AinhoaPagola	Tag Attached: comsup_sprint4
2009-04-21 12:36	psarobe	Status	resolved => closed

Notes
(0012459) svnbot (reporter) 2009-01-21 16:37	Repository: openbravo Revision: 12094 Author: AinhoaPagola Date: 2009-01-21 16:37:00 +0100 (Wed, 21 Jan 2009) Fixes bug 0007046 create period function fixed for Oracle --- U trunk/src-db/database/model/functions/C_YEARPERIODS.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12094&sc=1 [^]