0003672: Error in the Edi File import - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003672

Openbravo ERP

02. Master data management

public

2008-04-04 12:33

2008-06-12 09:44

Reporter

cromero

Assigned To

pheenan

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.35MP4

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

0003672: Error in the Edi File import

Description

Related to bug:
0002807

Insert clause is wrong in EdiFileImport.xsql. The wrong line is:
VALUES(TO_NUMBER(?) TO_NUMBER(?), TO_NUMBER(?), 'Y', now(), TO_NUMBER(?),
now(), TO_NUMBER(?), ?, ?, ?, ?, ?, to_date(?, 'yyyymmdd'), to_date(?,
'yyyymmdd'), ?, ?, TO_NUMBER(?), ?, ?, ?, ?, ?, ?)

take a look to the two first parameters without ','.

Right line is:
VALUES(TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), 'Y', now(), TO_NUMBER(?),
now(), TO_NUMBER(?), ?, ?, ?, ?, ?, to_date(?, 'yyyymmdd'), to_date(?,
'yyyymmdd'), ?, ?, TO_NUMBER(?), ?, ?, ?, ?, ?, ?)

Steps To Reproduce

Proposed Solution

Additional Information