EAR 9.2: Record Field PS_PAY_MISC_DST.PC_DISTRIB_STATUS Remains As 'D' (Distributed) For Un-posted Direct Journals Accounting Entries Affecting Further Interface To Project Costing Module (Doc ID 2215808.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

ISSUE:

When Direct Journal Deposit transactions get unposted, the value in the PC_DISTRIB_STATUS Field within Record PS_PAY_MISC_DST stays as 'D' (Distributed), which prevents such transactions from getting picked up by the Receivables to Projects AE Program (PC_AR_TO_PC) to populate the Table PS_PROJ_RESOURCE.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as User ID VP1
     2.- Navigate to: Project Costing > Project Definitions > General Information
     3.- Create a brand new Project with the below values:
           - PC Business Unit = US001
           - Project ID = GCS_PROJECT
           - Description = GCS Project
           - Integration = US001
           - Start Date = 01-01-2016
           - End Date = 12-31-2016
           - Project Status = Approved
     4.- Save the changes
     5.- Navigate to: Project Costing > Activity Definitions > Project Activities
     6.- Create a brand new Activity ID for the Project just created, as follows:
           - PC Business Unit = US001
           - Project ID = GCS_PROJECT
           - Activity Name = GCS Project Activity
           - Activity ID = 000000000000001
           - Start Date = 01-01-2016
           - End Date = 12-31-2016
     7.- Save the changes
     8.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     9.- Create a new Deposit as follows:
           - Deposit Unit = US001
           - Deposit ID = NEXT
           - Accounting Date = Today's Date
           - Bank Code = USBNK
           - Bank Account = CHCK
           - Deposit Type = M
           - Control Currency = USD
           - Control Total Amount = 2500
           - Count = 1
     10.- Go to the Payments tab, and fill in the following values:
           - Payment ID = DIR-DEP-01
           - Amount = 2500 USD
           - Accounting Date = Today's Date
           - Journal Directly = Y
           - Save the changes
     11.- Navigate to: Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries
     12.- Open the Direct Journal Deposit created
     13.- At the Distribution Lines section, fill in the following values:
           - GL Unit = US001
           - Line Amount = -2500
           - Account = 403000
           - Department ID = 15000
           - PC Business Unit = US001
           - Project ID = GCS_PROJECT
           - Activity ID = 000000000000001
           - Source Type = OTHER
           - Category = ADMIN
           - Subcategory = G&A
           - Analysis Type = REV
     14.- Click on the lightning bolt icon, to generate the balancing line
     15.- Select the Complete flag
     16.- Save the changes
     17.- Navigate to: Project Costing > Revenue Collection > Adjustments from Receivables
     18.- Create a new Run Control ID as follows:
           - Run Control ID = GCS
           - Option = Business Unit/Project
           - Business Unit = US001
           - Project - GCS_PROJECT
           - Process Frequency = Always
           - Date Option = All
     19.- Launch the PC_AR_TO_PC AE Program to success
     20.- Querying Record PS_PROJ_RESOURCE to confirm the Project ID data is present
     21.- Navigate to: General Ledger > Journals > Subsystem Journals > Generate Journals
     22.- Run Journal Generator for ARDIRJRNL Accounting Definition Name for the Direct Journal Deposit transaction
     23.- Navigate to: Accounts Receivable > Payments > Direct Journal Payments > Unpost Direct Journal
     24.- Find the Deposit in question, and mark it for Unpost
     25.- Querying Record PS_PAY_MISC_DST for the affected Payment, and notice that the unpost row where SYSTEM_DEFINED = ‘U’ has a PC_DISTRIB_STATUS = 'D', when it should be 'N'
     26.- Navigate to: Project Costing > Revenue Collection > Adjustments from Receivables
     27.- Open Run Control ID GCS, and launch the PC_AR_TO_PC AE Program to success
     28.- Confirm that the process has not handled any transactions, and PS_PROJ_RESOURCE Record has no change

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ACTUAL RESULTS:

The unposted amounts from Direct Journal Deposit transactions is not getting interfaced into the Project Costing module, inflating the amounts incorrectly.

EXPECTED BEHAVIOR:

The PC_DISTRIB_STATUS on the reversal entries in PAY_MISC_DST should be reset to 'N', so that when running PC_AR_TO_PC, reversal rows get generated in Project Costing.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms