Extending View Object and getting bind variable error.
I am trying to extend SupHrchyChildVO.xml. I am simply adding a table to the query, a join condition, and changing paf.supervisor_id to hsft.segment2 supervisor_id. So the attribute name is not changing.
I get the following errors when I try to access the page
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Bind_PersonId
The sql statement has bind variables, but not Bind_PersonId or PersonId. The only thing I have done is extend the View Object. The view object has a view link object. I think I have to extend that as well, but I am unsure how to extend the view link object because it does not appear in JDeveloper. It is in the windows folder.