Looking for some XOG expertise when trying to generate transaction entries. Running 14.3 On Premise and getting into another headache trying to activate financials within CA PPM.
Trying to generate a transaction entry for each investment to bring ACWP up to match the Actual Cost displaying for the project under the Hierarchy tab since past time slices were not configured to include Actual Cost from the get go. Rate matrix, classes, time periods, etc. are all configured correctly from what we can tell. Doing these transactions manually through CA PPM appears to update the ACWP as expected, but the XOG version isn't behaving quite as well. Since we're looking at around 4k projects (yes, I know - it's a lot...), doing this manually is NOT an alternative.
Attempted to run a XOG file generated based on the "imp_transactions_write.xml" format. XOG appears to execute without error, as we can see the transaction hit the system under the "Admin -> Invalid Transactions" list as "New" and it does disappear once we run the jobs.
Ran the following jobs in this order:
- Post Transactions to Financials
- Post to WIP
- Import Financial Actuals
- Update Earned Value and Cost Totals
After running the financial jobs, ACWP does NOT match the expected value. Also, pretty disappointed there isn't a way to backfill this type of information if financials weren't configured before the first timesheet being posted. If there's a way that I'm not aware, please share!
Any guidance is appreciated.