We are running into an unexpected issue when attempting to customize the Sales order data model and add additional attributes to the data model. We are following the following recommended oracle guide (2344883.1)
-We have copied the data model to a custom folder.
-We then attempted to modify the data source XML
-We were able to download the xml file, append additional xml properties to the file ad re uploaded.
-We then created an SQL data source.
The main issue is occurring after we save and try to work with the custom copy of the sales order data model. We are unable to bring in any additional fields as the data model is unmodifiable. When we try to do so using a custom data model, the format of the custom data model makes the report not render any of the fields.
Please note the following attachments
1.) Account Owner Field - This is the additional field that we are wanting added to the data model
2.)Image of the custom vs seeded data model - This is where the problem lies.
You'll notice that the data for the seeded data model shows a single order in XML file, but the custom copy shows a list of orders so we are unsure how to create the appropriate query. See attached image that shows difference when copy and saving a custom version of the data model and seeing them side by side. You will notice the structure has changed so at this moment the only means to add additional attributes with copying from the original means we would need to rebuild every field in the RTF file which would be very time consuming.
3.) Oracle doc - This shows the recommended steps for extending Sales Order DM.
https://support.oracle.com/knowledge/Oracle%20Cloud/2344883_1.html