When I tried to run a mapping using SmartConnect with the taPoLine and taPoHdr, i received this error, "Invalid Object name 'PA01901'". I know that this table is related to Project Accounting but we don't license for Project Accounting that is why we didn't install it our server. Should I need to install the PA module?
This issue is caused by PR 60024, which is currently scheduled to be fixed in year end releases of GP 10.0 and GP 2010.
The Work Around - is to script the table create from Fabrikam/TWO database.
Go to SQL Server Management Studio, expand out TWO and Tables, right click on PA01901 and Script Table As > Create to > New Query.
Change the USE statement to your company database instead of TWO.
Add the following line to the end of the script:
grant all on PA01901 to DYNGRP
Business Applications communities