CHRS Knowledge Base

LCD Troubleshooting Guide

Updated on

Purpose

The purpose of this article is to assist campuses with troubleshooting common CSU Labor Cost Distribution (LCD) errors and warnings.

If you are unable to resolve the warnings or errors based on the information below, please submit a ServiceNow ticket.

General

ISSUE: Changing Offset Account Values

Offset Account values are used by the LCD process for “zero-balance accounting”. Most campuses set their Offset Account values once for their Department Offset Group and leave them alone. 

However, if Offset Account values need to be changed or updated, campuses must:

  1. Navigate to: Menu > Set Up HRMS > Product Related > Commitment Accounting > Budget Information > Department Offset Groups
  2. Enter a new Effective Dated row by pushing the ‘+’ button on the top right.
  3. Under the Payroll Information scroll, enter the new Offset Account values for each row of Payroll Activity. 

    Optional: enter even more detailed information down to the Plan Type or Deduction Code level.

  4. Press Save.
Offset account values
ISSUE: PS_CSU_LCD_JOB_DTL and PS_JOB are not in sync

The PS_CSU_LCD_JOB_DTL and PS_JOB tables are not in sync and therefore, the wrong department is populated in PS_PAY_CHECK.

A possible reason for this is that the CSU_UNIT value does not match when it comes in on the SCO Pay Tape file. 

This value either gets set directly in the SCO system or is transmitted to the SCO (depending on how the employee's time gets entered).

To correct this, you need to have the CSU_UNIT values match.

CSU Create Paycheck Data Job - CSULCDCR (CSULCD15 & CSULCD20)

CSU Check Creation Warning Message report produces results

Where in the Process: CSU Create Paycheck Data (CSULCD20)

Meaning: These warnings can be ignored. This is simply a list of the employee rows you will need to manually correct on the CSU Check Errors Correction page after you run the CSU Create Paycheck Data Job.

report sample

CSU Paycheck Data Finalize Job - CSULCDFN (CSULCD20 & CSULCD30)

WARNING: Program Terminated successfully, but with nothing to process -- see message above. Manually Queue next program if OK to continue.

Where in the Process: CSU Paycheck Data Finalize Job (CSULCDFN)

Meaning: This occurs when a campus runs the CSU Backout YTD Balances but not the CSU Backout Paycheck Create and then runs the CSU Paycheck Data Finalize Job. The message means that there was nothing to process, and it is okay to continue.

Next Steps: 

  1. Once the Process goes to a Run Status of “Warning”, click on the Job Name and then CSULCD20:
  2. Review the Output file to review the warning message.
  3. Once confirmed, click on CSULCD30
  4. Under Update Process click “Queue Request” then “OK”
  5. On the Process Monitor page, refresh until the Distribution Status says “Posted”.
  6. Once it does, click on the Process Name and then the CSULCD30 process and review results.
ERROR: Employer Ded Class Missing on PS_DEDUCTION_CLASS table for Deduction Code ####

Where in the Process: Paycheck Create

Meaning: This error means that you need to set up a ‘Non-Taxable’ tax class set up for Deduction Code ‘######’.

Next Steps:

  1. Set this up in CHRS
  2. Once this is set up, you can run the CSU Backout Paycheck Create process.
  3. Once that runs successfully, you can re-run the CSU Create Paycheck Data Job and then continue with your LCD processing.

CSU Distribute Paychecks (CSULCD40)

Account not defined for job function $Job_Func: [XXX]

Where in the Process: CSU Distribute Paychecks (CSULCD50)

Meaning: The data has not been setup for your campuses Job Function mapping.

Note: Job function values (example: LON) can change based on the setup the campus needs to complete. 

The GL Account value that the Job Function maps to is determined by the campus.

Next Steps: 

  1. Setup the Job Function by navigating to CSU Acct Mapping- Job Function

    Navigation: Menu > Set Up HCM > CSU Product Related Setup > CSU LCD Setup > CSU Acct Mapping - Job Function

  2. Once you map these, run the CSU Backout Check Distribution process, 

    Navigation: Menu > Payroll for North America > CSU Labor Cost Distribution > CSU LCD Backouts > CSU Backout Check Distribution

  3. Re-run the CSU Distribute Paychecks process.

    Navigation: Menu > Payroll for North America > CSU Labor Cost Distribution > CSU LCD Processes > CSU Distribute Paychecks

GL Interface (CSULCD50)

During the GL Interface process you may encounter one or more of these errors mentioned below. If you are unable to resolve the errors based on the information below, please submit a ServiceNow ticket.

WARNING: Calculated Net Pay amount does not match with the Net Pay Liability for PAYCHECK_NBR

Where in the Process: GL Interface (CSULCD50)

Meaning: This may mean that the amounts are not matching down to the penny.

Next Steps: This warning can be ignored.

ERROR: Encumbrance Control is locked with a status of “Actual Expense in Progress”

Where in the Process: GL Interface (CSULCD50)

Meaning: This means that you have already attempted to run the GL Interface and then attempted to run it again without completing the Backout GL Interface process.

Next Steps: Uncheck the “Encumbrance Processing Flag” located under CSU General Setup. 

If you do not have access to this page, you will need to submit a ServiceNow ticket.

Navigation: Menu > Set Up HCM > CSU Product Related Setup > CSU General Setup > CSU General Setup

Under the "CSU Installation" tab, this is how the Encumbrance Process setup should look:

ERROR: Accounting Calendar Not Found

Where in the Process: CSU General Ledger (GL) Interface (CSULCD50)

Meaning: This may mean that the Accounting Calendar has not been setup on the CFS side.

Next Steps: 

  1. Work with your campus CFS team to create the Accounting Calendar in CFS.
  2. Once created, run the Backout GL Interface process (CSULCD51).
  3. Once the CSU Backout GL Interface process completes successfully, you can re-run the CSU Actuals GL Interface process
ERROR: Offset Account not found for Department ### and Activity FME

Where in the Process: CSU General Ledger (GL) Interface (CSULCD50)

Meaning: This could mean that the DEPTID values do not have a Fiscal Year row setup in the Department Budget Table. This can be caused by how data was converted or if your campus has recently updated their DEPTID Values.

Next Steps: 

  1. In CHRS, enter the DEPTID values on the Department Budget Table for the Fiscal Year that you are missing.
  2. Run the CSU Backout GL Interface process (CSULCD51).
  3. Once the CSU Backout GL Interface process completes successfully, you can re-run the CSU Actuals GL Interface process
ERROR: ORA-01400: cannot insert NULL into (“SYSADAM”. “PS_HR_ACCTG_LINE”. “ACCOUNT”)

Where in the Process: CSU General Ledger (GL) Interface (CSULCD50)

Meaning: This could mean multiple things:

  • The GL Interface has run into a problem trying to insert data; some data may be missing.
  • It could be that the DEPTID values do not have a Fiscal Year row setup in the Department Budget Table.
  • This can be caused by how data was converted or if your campus recently updated their DEPTID Values.

Next Steps: 

  1. In CHRS, enter the DEPTID values on the Department Budget Table for the Fiscal Year that they are missing on.
  2. Run the CSU Backout GL Interface process (CSULCD51).
  3. Once the CSU Backout GL Interface process completes successfully, you can re-run the CSU Actuals GL Interface process

CSU Export Accounting Lines (CSULCD60)

ISSUE: Export Accounting Lines has been run and I can no longer back out GL Interface.

The LCD process sets the process instance of the CSU Export Accounting Lines process on HR_ACCTG_LINE rows when the data has been sent to CFS for Journal Generation. 

Once this process instance is set on your HR_ACCTG_LINE rows, GL interface can no longer be backed out as the data now exists in two systems (CHRS and CFS), and the GL Interface backout requires the process instance for the HR_ACCTG_LINE entries you wish to backout to be = "0", which is initially set in the previous step when you run the CSU General Ledger (GL) Interface process.

Addressing any issues with HR_ACCTG_LINE data once this has occurred requires coordination between CHRS and CFS to remove the HR_ACCTG_LINE entries in both systems before you are able to back out the GL Interface process. The CHRS LCD team will then be able to reset the process instance on the accounting lines so that you may back out GL interface and re-generate the accounting lines.

Next Steps:

  1. Submit a ServiceNow ticket to CHRS
    1. Type: Request
    2. Category: CMS-CHRS
    3. Subcategory: LCD
    4. Ticket Short Description: Request to have CSULCD60 Backed Out - [Campus Name] - [Pay Period]
    5. Description: provide the following:
      1. Pay Period
      2. Run Date
      3. Reason for Request

         

  2. Submit two(2) ServiceNow Ticket(s) to CFS:
    1. Ticket 1 (CFS Trouble Ticket):
      • Type: Request
      • Category: CMS-CFS
      • Subcategory: General Ledger
      • Ticket Short Description: [Campus Name]  HR_ACCTG_LINE Data Removal
      • Description: provide the following:
        • Pay Period
        • Run Date
        • Reason for Request
    2. Ticket 2 (CFS Production Data Change Ticket):
      • Type: Request
      • Category: CMS-CFS
      • Subcategory: Production Data Change
      • Ticket Short Description: [Campus Name] Production Data Change Request
      • Description: provide the following:
        • Pay Period
        • Run Date
        • Reason for Request
          • please reference the ServiceNow incident number (i.e. INC#######) from the first "CFS Trouble Ticket" above.

Note: The CFS Production Data Change ticket will require campus controller or AVP approval, which should be attached to the ticket.

CSU Labor Cost Table Refresh (CSUBE009)

WARNING: Journal Data not populated for adjustment listed below:

Where in the Process: CSU Labor Cost Table Refresh (CSUBE009)

Meaning: The CSU LCD Labor Cost Table Refresh process gives you a warning when HR_ACCTG_LINE Adjustment rows do not have Journal Data populated. This may mean that those adjustment rows may not have been Journal Generated yet in CFS, or, if they were Journal Generated, the Journal ID was not sent from CFS to CHRS.

Next Steps: This does not mean you need to back out the LCD Table Refresh process. All it means is that you will need to re-run the LCD Table Refresh process AFTER you populate the Journal Data in the HR_ACCTG_LINE Adjustment rows to process those rows and populate the Journal ID from CFS.

 ERROR: ORA-02289: Sequence does not exist

Where in the Process: CSU Labor Cost Table Refresh (CSUBE009)

Meaning: LCD Sequence Number did NOT get created

Next Steps: Open a ServiceNow ticket and attach the error message.

CSU Pre Check Audit Report

ISSUE: CSU Pre Check Audit report is missing deduction codes

To run the report successfully you need ensure that you are entering the following required fields in the Run Control page:

  • Pay Tape Period
  • Pay End Date
  • Default Pay Group
report parameters
Pre Check Audit Report Errors
Jobcode #### is not an active jobcode as of [DATE]

Meaning: The job codes is no longer active and is being attributed to a some data set in the paycheck create process for the Pay Tape you're looking at.

Next Steps: These are ok to ignore, because they will be addressed or corrected in the Check Errors process where you can assign the correct Job to each record/employee.

SSN Not Found - Not in PeopleSoft

Meaning: The employee in the data set is missing or cannot otherwise be found in the system.

Next Steps: You may need to work with the appropriate group on your campus to get the employee created in the system with an SSN.

Not Found on JOB Data

Meaning: Data for the employee cannot be found in Job Data (PS_JOB).

Next Steps: You may need to work with the appropriate group on your campus to get the data entered in Job Data.

Deduction Code not found on PS_DEDUCTION_CLASS table

Meaning: Deduction Class needs to be reviewed for any missing Tax Classes.

Next Steps: Submit a ServiceNow ticket requesting that CMS and Systemwide HR (SWHR) review and add/update a deduction code.

Note: New deduction codes impact all campuses in CHRS.

Earnings Code Value not found.

Meaning: Earnings Code value is missing from the table and needs to be setup.

Next Steps:

  1. Navigate to setup the Earnings Code page.
    • Navigation: Main Menu > Setup HCM > CSU Product Related Setup > CSU LCD Setup > CSU Acct Mapping - Earnings Cd)
  2. Setup the Earnings Code.

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) LCD Frequently Asked Questions (FAQ)
Next Article (job aid) LCD Checklist for Implementing Campuses
Do you need an article? Contact Us