My Oracle Support Banner

EPC: PC_PRICING Creating Target Rows in PS_PROJ_RESOURCE With the FA_STATUS of 'D' Rather Than 'N'. This Is Causing The GM_GMFACS Process Not to Create Target SFA Rows As Needed. (Doc ID 2758249.1)

Last updated on MARCH 09, 2021

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

PC_PRICING creating target rows in PS_PROJ_RESOURCE with the FA_STATUS of 'D' rather than 'N'. This is causing the GM_GMFACS process not to create target SFA rows as needed.

Replication Steps:

  1. Create a Cost Rate set "COST" that creates a 'BUR' row from the source "PAY" transaction. Also, configure the FNA analysis group to have 'PAY' and 'BUR' listed as analysis types.
  2. Create a Proposal, Submit and generate an award that generates a contract with amount based contract line.
  3. Associate the Contract line with a Project and Activity.
  4. Finalize the Project Budget.
  5. Make sure Project Activity has FA rates associated and no Rate sets are associated.
  6. Create a 'PAY' transaction using Add transactions with proper chart fields that generate SFA row.
  7. Run GM_GMFACS process. The process generates the target 'SFA' rows.
  8. Now associate the "COST" rate set to the project activity.
  9. Run PC_PRICING (Project Costing > Utilities > Pricing).
  10. This generates the "BUR" target row as expected. But this row is populating the "FA_STATUS" as "D". This is incorrect.
  11. Run the GM_GMFACS process (Grants > Awards > Process Facilities Admin).
  12. The process did not create any 'SFA' rows for the 'BUR' transactions as expected. This is incorrect.

Replication Screenshots

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.