You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to convert column to reference during business object creation from file

edited Dec 15, 2017 8:00AM in Visual Builder

Summary

Unable to convert column to reference during business object creation from file

Content

I'm trying to create multiple business objects from an Excel file with multiple sheets. The import can create all the business objects, but when I change an attribute to Reference and point to the reference object, I get error message "Data coercion failed for property pers from TEXT(VARCHAR2(4000)) to REFERENCE (NUMBER)"

My master object TASKS contains a column called PERS containing values like PF, JF, FAM. My import file contains both a TASKS and a PERS sheet. I select the PERS column in TASKS and change it into a Reference and select the value to be displayed as described in the documentation

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!