ORA-01730 on T_RV_RECONCILIATION
Description
Environment
relates to
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;
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