We are currently working on a client requirement where in a csv/xml file is provided on a periodic basis containing budget actuals that need to be updated in PPM.
What's the best way to achieve this. PL/SQL or Webservices?
Are backend budget updates discouraged from this PPM version onwards?
Is it possible to use webservices to update data by reading a csv/xml file or webservices can only be implemented between PPM and an external system which supports webservices and provides an API for it.
Reading thru 7.1 webservices doc, my understanding is that web service operations for Budget Create, read and update have been deprecated in this version and will be re-implemented in future release.
Looking for any pointer/code/doc to achieve this requirement.
I just finished an PL/SQL implementation of importing financial data from SAP into both the Plan and Actual portions of the budget. Of course, with the client I am working at, there are some User_data fields that come into play when figuring out where the data needs to go, but I can send the code that I used for this implementation.
Here's the two procedures that I wrote for updating the budget entries. Like I said before, they use some User Data fields to hold some other cost data elements that I use for finding which Lines and Cells I need to put the data into. This shouldn't be too hard to adapt to your needs.
SAP Generates pipe (|) separated files nightly with the data in this format
There sre Scheduled Reports in PPM that processes the lines of the files and make the SQL Calls to the functions to update the Budget entity. The Actuals import went live into production on 1/31 and the Plan (Forecasting) went live on 4/11. I've attached the Functional Design Doc. This details out the table mappings for the data import. The Tech Doc that was written was geared towards the SAP side and didn't include anything useful for the PPM side.