Related to issue 16020: error in oracle when creating the Reconciliations tab based on the view.
authorEduardo Argal Guibert <eduardo.argal@openbravo.com>
Tue, 08 Mar 2011 12:04:58 +0100
changeset 11081 d5474885bfee
parent 11080 b0b6a4571a0b
child 11082 a1a779920af6
Related to issue 16020: error in oracle when creating the Reconciliations tab based on the view.
em_aprm_process_reconciliation identifier too long
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml	Tue Mar 08 11:22:20 2011 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml	Tue Mar 08 12:04:58 2011 +0100
@@ -1,6 +1,6 @@
 <?xml version="1.0"?>
   <database name="VIEW APRM_RECONCILIATION_V">
-    <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id, fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive, fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno, fin_reconciliation.c_doctype_id, fin_reconciliation.dateto, fin_reconciliation.statementdate, fin_reconciliation.endingbalance, fin_reconciliation.startingbalance, fin_reconciliation.docstatus, fin_reconciliation.processing, fin_reconciliation.processed, fin_reconciliation.posted, fin_reconciliation.printdetailed, fin_reconciliation.em_aprm_process_reconciliation, fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no, COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt, COALESCE(outstanding.payment_no, 0) AS payment_no, COALESCE(outstanding.payment_amt, 0) AS payment_amt, COALESCE(outstanding.deposit_no, 0) AS deposit_no, COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT ad_table.ad_table_id
+    <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id, fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id, fin_reconciliation.ad_org_id, fin_reconciliation.created, fin_reconciliation.createdby, fin_reconciliation.updated, fin_reconciliation.updatedby, fin_reconciliation.isactive, fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno, fin_reconciliation.c_doctype_id, fin_reconciliation.dateto, fin_reconciliation.statementdate, fin_reconciliation.endingbalance, fin_reconciliation.startingbalance, fin_reconciliation.docstatus, fin_reconciliation.processing, fin_reconciliation.processed, fin_reconciliation.posted, fin_reconciliation.printdetailed, fin_reconciliation.em_aprm_process_reconciliation as process_reconciliation, fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no, COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt, COALESCE(outstanding.payment_no, 0) AS payment_no, COALESCE(outstanding.payment_amt, 0) AS payment_amt, COALESCE(outstanding.deposit_no, 0) AS deposit_no, COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT ad_table.ad_table_id
 FROM ad_table
 WHERE lower(ad_table.tablename) = 'fin_reconciliation') AS forced_table_id
 FROM fin_reconciliation
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Tue Mar 08 11:22:20 2011 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Tue Mar 08 12:04:58 2011 +0100
@@ -674,7 +674,7 @@
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <NAME><![CDATA[Process Reconciliation]]></NAME>
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <DESCRIPTION><![CDATA[Process Reconciliation Document]]></DESCRIPTION>
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <HELP><![CDATA[Used to process and reactivate reconciliation documents]]></HELP>
-<!--63454E73F07B4C908EB1268C41F5DE8A-->  <COLUMNNAME><![CDATA[EM_APRM_Process_Reconciliation]]></COLUMNNAME>
+<!--63454E73F07B4C908EB1268C41F5DE8A-->  <COLUMNNAME><![CDATA[Process_Reconciliation]]></COLUMNNAME>
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <AD_TABLE_ID><![CDATA[0DFF5BACFB964FDABAA5042C8809C813]]></AD_TABLE_ID>
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
 <!--63454E73F07B4C908EB1268C41F5DE8A-->  <AD_REFERENCE_VALUE_ID><![CDATA[36972531DA994BB38ECB91993058282F]]></AD_REFERENCE_VALUE_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Mar 08 11:22:20 2011 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Mar 08 12:04:58 2011 +0100
@@ -230,7 +230,7 @@
 <!--C8E8009C6BF5427EA930515F217F768E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--C8E8009C6BF5427EA930515F217F768E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--C8E8009C6BF5427EA930515F217F768E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--C8E8009C6BF5427EA930515F217F768E-->  <COLUMNNAME><![CDATA[EM_APRM_Process_Reconciliation]]></COLUMNNAME>
+<!--C8E8009C6BF5427EA930515F217F768E-->  <COLUMNNAME><![CDATA[Process_Reconciliation]]></COLUMNNAME>
 <!--C8E8009C6BF5427EA930515F217F768E-->  <NAME><![CDATA[Process Reconciliation]]></NAME>
 <!--C8E8009C6BF5427EA930515F217F768E-->  <PRINTNAME><![CDATA[Process Reconciliation]]></PRINTNAME>
 <!--C8E8009C6BF5427EA930515F217F768E-->  <DESCRIPTION><![CDATA[Process Reconciliation Document]]></DESCRIPTION>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Tue Mar 08 11:22:20 2011 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Tue Mar 08 12:04:58 2011 +0100
@@ -40,7 +40,7 @@
 <!--FF8080812E2F8EAE012E2F98D9680030-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
 <!--FF8080812E2F8EAE012E2F98D9680030-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--FF8080812E2F8EAE012E2F98D9680030-->  <ISRANGE><![CDATA[N]]></ISRANGE>
-<!--FF8080812E2F8EAE012E2F98D9680030-->  <DEFAULTVALUE><![CDATA[@EM_APRM_Process_Reconciliation@]]></DEFAULTVALUE>
+<!--FF8080812E2F8EAE012E2F98D9680030-->  <DEFAULTVALUE><![CDATA[@Process_Reconciliation@]]></DEFAULTVALUE>
 <!--FF8080812E2F8EAE012E2F98D9680030-->  <AD_ELEMENT_ID><![CDATA[152]]></AD_ELEMENT_ID>
 <!--FF8080812E2F8EAE012E2F98D9680030--></AD_PROCESS_PARA>
 
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml	Tue Mar 08 11:22:20 2011 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml	Tue Mar 08 12:04:58 2011 +0100
@@ -40,7 +40,7 @@
 <!--FF8080812E448A62012E44943A160017-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--FF8080812E448A62012E44943A160017-->  <NAME><![CDATA[APRM_Process Reconciliation valid actions]]></NAME>
 <!--FF8080812E448A62012E44943A160017-->  <TYPE><![CDATA[S]]></TYPE>
-<!--FF8080812E448A62012E44943A160017-->  <CODE><![CDATA[((@EM_APRM_Process_Reconciliation@ = 'P' AND AD_Ref_List.value='P') OR (@EM_APRM_Process_Reconciliation@ = 'R' AND AD_Ref_List.value='R') OR (@EM_APRM_Process_Reconciliation@ is null))]]></CODE>
+<!--FF8080812E448A62012E44943A160017-->  <CODE><![CDATA[((@Process_Reconciliation@ = 'P' AND AD_Ref_List.value='P') OR (@Process_Reconciliation@ = 'R' AND AD_Ref_List.value='R') OR (@Process_Reconciliation@ is null))]]></CODE>
 <!--FF8080812E448A62012E44943A160017-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--FF8080812E448A62012E44943A160017--></AD_VAL_RULE>