My Oracle Support Banner

Accounting Issues With Project Class Code Source Due To Value Set Validation Where Clause (Doc ID 2226588.1)

Last updated on MARCH 17, 2019

Applies to:

Oracle Fusion Project Costing Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Project Costs-Allocate Project Costs


Projects Class Code LOV is showing up all the classification source which are accounting enabled and attached to a project.

Basically Projects Class Code List Of Values  should display all class codes that are associated to an accounting  enabled class category irrespective of whether it is attached to a project or not.

The issue can be reproduced at will with the following steps:
When using 2 primary and secondary ledgers in GL and all subledgers post journal entries in both
Use a project class codes assigned to each project header in order to derive the segment “Project” of our accounting key. The project class code values match the project segment values in GL.

In Procurement, project information are mandatory
In project costing, every Purchase Order receipt or Supplier Invoice transaction can be adjusted by project accountant then SLA(PJC) manages adjustment journal entries accordingly

In Procurement, the TAB is setup and use some mapping set based on the project costing source “Project Class Code”
In Project costing, the supplier cost adjustment JERS is setup in SLA based on the same project costing source “Project Class Code”

In project foundation we setup new a project as soon as financial controller ask for a new one. Each project must have a class code assigned, but it can be either the default value in GL (000) or any other valid values (from several tens to hundreds according to the company size).
Multiple projects can be assigned the same GL value, and it is often the case that class code values created in project are not assigned to any project yet.

The “Project Class Code” source is validated against a standard value set “PJC_CLASS_CODE_VS”




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.