My Oracle Support Banner

PC_IN_TO_PC Process Is Not Processing Transactions Into PROJ_RESOURCE From CM_ACCTG_LINE (Doc ID 2093926.1)

Last updated on JANUARY 06, 2020

Applies to:

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


On : 9.2 version, Interfaces

In version 9.2 some transactions are not pulling from CM_ACCTG_LINE table into PROJ_RESOURCE for inventory transactions. The transactional data appears to be complete and has the PC_DISTRIB_STATUS flag set to an 'N', all project-related fields are populated correctly, the projects/activities are open and available to charge to, and some transactions have flowed correctly, but others did not. We have ran the PC_IN_TO_PC process multiple times, trying to pull in the un-distributed rows from inventory, but to no avail. This has been happening since we recently upgraded (October 26) to version 9.2 - transactions prior to that were all processed successfully. Because of this we cannot reconcile our projects to G/L for October, November, and soon December. As of right now, there are about 6350 rows in CM_ACCTG_LINE that will not flow to PROJ_RESOURCE.

PC_IN_TO_PC should process the expected CM_ACCTG_LINE data to PROJ_RESOURCE

The issue can be reproduced at will with the following steps:
1. Run PC_IN_TO_PC
2. Notice that the rows no rows are getting processes by it.




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

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