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
ORA-01790: expression must have same datatype as corresponding expression
How to display 1st region invoice date into tabular form invoice date column.