My Oracle Support Banner

EGL9.2: When Using PC Business Unit and Project Activity In Combo Edit for ARDEFN and BIDEFN The AR Journals Got Posted With Missing Chartfields (Doc ID 2100240.1)

Last updated on APRIL 08, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


On :  9.2 version, Combo Edit

AR Journals posting in GL with missing Chartfields  

The customer is using Prepaid billing where in the Deferred Revenue Distribution tab, the chartfields coming from Project Costing module are not available: PC Business Unit and Activity as per the documents below:

Enhancement request:

<Bug 11460479> - PSFT 1690022000-CA: CANNOT POPULATE THE PROJECT BUSINESS UNIT (PCBU) AND ACTIVITY . The enhancement was implemented by <Bug 24314910>, starting with PUM 22.

<Note 1333425.1> - For Prepaids, The Deferred Revenue Distribution Has Project ID Filed Only. It Should Also Include Project Costing Business Unit and ACTIVITY_ID Fields.

Due to this issue, the project chartfields are not populated in General Ledger when running Journal Generator and the customer needs to use a workaround, using Project ID from Design Chartfields > Design values.
After the implemented workaround, the user is facing different behavior:

When running FS_JGEN for BIDEFN, the Journal ID generated would not post because of the missing Chartfields.
When running FS_JGEN for ARDEFN, the journal is posted even though the PC BU and Activity Chartfields are missing.
The question is why does the system stop the Journal ID from posting when it comes from the Billing module but it doesn't stop it when it comes from the AR module?

The Billing and Accounts Receivables should have the same behavior and do not let the journal to be posted if there are missing chartfields.


a) Activated Chartfield 2 for PC Business Unit and Chartfield 3 for Activity

b) Relabeled Chartfield 2 as Chartfield 2/PC BU and Chartfield 3 as Chartfield 3/ Project Activity

c) Used the delivered project chartfields ( From Project Costing module) in Billing and Accounts Receivables

d) For GL journals added the new chartfields in the Accounting Entry Definition ( Chartfield 2/ PC BU and Chartfield 3/Project Activity):

BIDEFN for Billing

ARDEFN for Accounts Receivables

Issue: When running the Journal Generator for BIDEFN and ARDEFN the results are different:

a) For ARDEFN the journals are posted - which is not desired , since the user needs to manually change the project related info

b) For BIDEFN the journals are not posted - which is desired, so user will manually update the journal with the project related info




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.