Skip to Content
0
Former Member
Aug 07, 2013 at 05:00 PM

How to handle user defined data types, etc. defined at the back-end(ORA) on the Business layer

166 Views

SAP BO 4.0
Back-end: Oracle 11g.

Data source: Oracle 11g examples(HR & OE Data Schemas)

Issue description:
How to handle following datatypes

  1. Custom Data types defined at the back-end.
  2. MDSYS.SDO_GEOMETRY
  3. SYS.XMLTYPE
  4. "INTERVAL YEAR(2) MONTH" or "Interval Day to Sec"

These are the data type of the columns specified at the back-end.

When the Business layer's integrity is checked for "Table Structure" and "Business Objects expression" i get the errors(Image attached) stating "Undetermined data type" for and "Incorrect Data type".

Has anyone experienced this and how were these data types handled?

Attachments

pic.jpg (106.5 kB)