ORA-01730 on T_RV_RECONCILIATION

Description

Hi,

I've just downloaded daily installer (windows32) and launch a setup.
Then, i've imported the base using RUN_ImportIdempiere.bat

One error : ORA-01730: invalid number of column names specified for T_RV_Reconciliation

Also, the creation script is missing on db\ddlutils\postgresql\views or db\ddlutils\oracle\views.

Regards,

Nicolas

Environment

None

Activity

Carlos Ruiz 
April 21, 2013 at 5:47 AM

Thanks Nicolas, solved.

Nicolas Micoud 
April 11, 2013 at 12:29 AM

The script is (copy/paste from the base) :

CREATE OR REPLACE FORCE VIEW "IDEMPIEREDAILY"."T_RV_RECONCILIATION" ("AD_CLIENT_ID", "AD_ORG_ID", "ISACTIVE", "CREATED", "CREATEDBY", "UPDATED", "UPDATEDBY", "FACT_ACCT_ID", "C_ACCTSCHEMA_ID", "ACCOUNT_ID", "DATETRX", "DATEACCT", "C_PERIOD_ID", "AD_TABLE_ID", "RECORD_ID", "LINE_ID", "GL_CATEGORY_ID", "GL_BUDGET_ID", "C_TAX_ID", "M_LOCATOR_ID", "POSTINGTYPE", "C_CURRENCY_ID", "AMTSOURCEDR", "AMTSOURCECR", "AMTSOURCE", "AMTACCTDR", "AMTACCTCR", "AMTACCT", "RATE", "C_UOM_ID", "QTY", "M_PRODUCT_ID", "C_BPARTNER_ID", "AD_ORGTRX_ID", "C_LOCFROM_ID", "C_LOCTO_ID", "C_SALESREGION_ID", "C_PROJECT_ID", "C_CAMPAIGN_ID", "C_ACTIVITY_ID", "USER1_ID", "USER2_ID", "A_ASSET_ID", "DESCRIPTION", "ORGVALUE", "ORGNAME", "ACCOUNTVALUE", "NAME", "ACCOUNTTYPE", "BPARTNERVALUE", "BPNAME", "C_BP_GROUP_ID", "PRODUCTVALUE", "PRODUCTNAME", "UPC", "M_PRODUCT_CATEGORY_ID", "AD_PINSTANCE_ID", "MATCHCODE") AS
SELECT f.*, t.ad_pinstance_id, t.matchcode
FROM rv_fact_acct f
JOIN t_reconciliation t ON f.fact_acct_id = t.fact_acct_id;

Fixed

Details

Assignee

Reporter

Components

Priority

Created April 11, 2013 at 12:25 AM
Updated March 13, 2014 at 2:19 PM
Resolved April 21, 2013 at 5:47 AM