-1- you can create an ODBC connection link to Oracle database, then use X++ to read the data(find some example online about reading from ODBC, pay attention to SqlStatementExecutePermission ) if it’s string, use str2int() or str2int64() function to convert the data;
-2- Why sales order cannot be confirmed? I guess you should somehow confirm it, as this step is posting to Journal (custConfirmJour / custConfirmTrans), when these are missing, you probably will have problems, not sure.
-3- linkActive() Calls the FormDataSource.exeuteQuery method on data sources that are linked to the current data source. So, without it, the related data won’t get updated when you move to another record on the master data source.
Please use descriptive titles for your threads. Ax_@2012r2 is a useless name, because it doesn’t say anything about your question and the version should be attached as a tag. Of course, it’s difficult to come with a good name if you actually ask three unrelated question. You wouldn’t have such a problem if you created a new thread for each question.