There was a need to change existing cost center id of a license,in the BA I just linked Name and used this for matching existing data , and the cost center id which needed to be changed but it gives error as Ambiguous column name "Cost Center ID" this happens when the update rule is set as Always update this column and when I choose Never update this column the simulation shows as 1 record updated (on testing one record via excel file) but there are no changes that take place.
‎Apr 07, 2020 02:33 AM
You cannot directly manipulate the Internal Database ID values as you are attempting to do in your adapter. For example, to change the Cost Center assigned to a license, you must
1) Create a file that has the License Name and the new Cost Center value
2) Create a Business Adapter
3) Add the Cost Center object to the adapter. On the main Cost Center object, uncheck the "All levels provided" check box, since you are not providing the entire path of the cost center, only the new Cost Center value. Match on the Cost Center Name from your spreadsheet.
4) Add the License object to the adapter and match on the License Name.
5) Within the License object, click on the Cost Center ID field. From the drop-down, select the CostCenter_ID value, which will be generated from the prior Cost Center match.
‎Apr 13, 2020 06:43 AM
Can you post your adapter and a debug log (or at last some more details from the logging you are seeing) here? It is hard to tell from the information provided what might be wrong, but seeing the actual details may help somebody to give a more specific pointer to help resolve the problem.
‎Apr 08, 2020 06:28 PM
I wonder if it is running into a problem because the column heading in the spreadsheet "CostCenterID" is the same as an table column name in the FNMS compliance database. Maybe try changing the column heading in the spreadsheet to something different, and update the adapter to use the new column heading name. Don't forget to change the reference to the spreadsheet column in the "trace field" setting in the adapter too!
‎Apr 09, 2020 05:39 AM
‎Apr 09, 2020 06:28 AM
‎Apr 12, 2020 11:46 PM
You cannot directly manipulate the Internal Database ID values as you are attempting to do in your adapter. For example, to change the Cost Center assigned to a license, you must
1) Create a file that has the License Name and the new Cost Center value
2) Create a Business Adapter
3) Add the Cost Center object to the adapter. On the main Cost Center object, uncheck the "All levels provided" check box, since you are not providing the entire path of the cost center, only the new Cost Center value. Match on the Cost Center Name from your spreadsheet.
4) Add the License object to the adapter and match on the License Name.
5) Within the License object, click on the Cost Center ID field. From the drop-down, select the CostCenter_ID value, which will be generated from the prior Cost Center match.
‎Apr 13, 2020 06:43 AM
‎Apr 13, 2020 09:30 AM