The Configuration Account Analysis template is not generating correct values for two scenarios:
- A project cost transaction is sourced from Payments; therefore, the GL Journal Source is Payables and the GL Journal Category is Payments. The expenditure_item_identifier is populated but has PROJECT_ID of -99999 in OAX$OAC.DW_FA_Y_CAA_APP_GL_TO_SLA. This results in all project attributes returning ~No Value~.
- Miscellaneous project cost transactions with a GL Journal Source of Projects that have a supplier populated have supplier_party_id of -99999 in OAX$OAC.DW_FA_Y_CAA_APP_GL_TO_SLA. This results in the Supplier Name field returning ~No Value~.
For both of these scenarios, the PPM - Project Costs subject area is reflecting the data correctly.
SR 4-0003054154 was created for this and it was advised to create an idea in the Idea Lab. It seems that the ID columns aren't populated in CAA for these scenarios which is affecting GL to SLA analysis.
Regards,
Angel
