0 Replies Latest reply: Oct 25, 2012 5:17 AM by Vedant RSS

    Display 1st region invoice date into tabular form invoice date column.

    Vedant
      Dear Friend,

      i have created two region.1st region have some item .using these item i have created invoice header.after creaing invoice header i have added no of line w.r.t invoice header.
      in 1st region i have take text item to enter invoice date it's data type is date type.

      in 2nd region which has created using tabular form here is i ma using one column invoice date.

      i want to display 1st region invoice date into tabular form invoice date column.so i have use item (application or page item) and pass :p1_invoice_date.

      i have use :p1_invoice_date as a text field but data type is date type date format is 'DDMMYY' and i am try to display it into tabular form invoice date column. it's also date type but i have display it as a text field and os i have put :p1_invoice_date into Tabular Form Element item default type (application or page item) .

      But it display me error

      report error:
      ORA-01790: expression must have same datatype as corresponding expression
      How to display 1st region invoice date into tabular form invoice date column.

      How can i do this.

      Thanks