EEX 9.0+: Error Message (9000,421) Prevents User from Save or Submit a Time Report Revision if it Contains a Blocked Project Activity (Doc ID 1565803.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

Employees are unable to Save or Submit the changes performed in a Revision from an existing Time Report, if it includes Lines making reference to a Project Activity that has a Blocked status. This happens even if:

 - The Period End Date of the Time Report whose Revision is to be Saved/Submitted is for a date way before the Effective Date used to place the Project Activity Status to Blocked
 - The only changes created in the Time Report Revision affect Lines making reference to other Projects included in the same transaction, and whose status are still Open.

The Error Message received by the users is preventing them from going forward with the changes performed in the Time Report Revision.

REPLICATION STEPS:

 - Log into the FSCM Online Application as User ID VP1
 - Navigate to: Set Up Financials/Supply Chain > Install > Installation Options > Project Costing Integration
 - Make sure that the option 'Enable Status Control' is properly selected
 - Navigate to: Set Up Financials/Supply Chain > Product Related > Project Costing > Project Options > Status Types
 - Open existing Status Type 'B' (Budgeted), change the Description to 'Blocked', make sure the Processing Status is set to 'Active', and save the changes
 - Navigate to: Project Costing > Project Definitions > General Information
 - Create new Project ID GCS_PROJECT3 under PC Business Unit US001, with Start date of 01-01-2012, End date 31-12-2013, a Project Status of Approved, and Processing Status of Active
 - Create a second Project ID GCS_PROJECT2 under PC Business Unit US001, with Start date of 01-01-2012, End date 31-12-2013, a Project Status of Approved, and Processing Status of Active
 - Navigate to: Project Costing > Activity Definitions > Project Activities
 - Open Project ID GCS_PROJECT3, and create Activity ID 000000000000001 with an Activity Status of Open with an Effective Date of 01-01-2012, and a Processing Status of Active
 - Open Project ID GCS_PROJECT2, and create Activity ID 000000000000001 with an Activity Status of Open with an Effective Date of 01-01-2012, and a Processing Status of Active
 - Navigate to: Project Costing > Project Definitions > Team
 - Open existing Project ID GCS_PROJECT3, and add to it, and its Activity 000000000000001, the following Resources: Employee ID KU0006 as Project manager, and Employee ID KU0021 as Project Consultant
 - Open existing Project ID GCS_PROJECT2, and add to it, and its Activity 000000000000001, the following Resources: Employee ID KU0006 as Project manager, and Employee ID KU0021 as Project Consultant
 - Log into the FSCM Online Application as User ID EXA1
 - Navigate to: Employee Self-Service > Travel and Expense Center > Time Report > Create
 - Create a new Time Report for Employee ID KU0021, with a Period End Date of 21-12-2012, and enter two TR Lines, one for each Project ID (GCS_PROJECT3, and GCS_PROJECT2), with their respective Activities, and booking 3 and 4 hours every week day
 - Submit the Time Report For Approval
 - Log into the FSCM Online Application as the proper Time Report approvers, and make sure the transaction gets fully approved at all levels
 - Log into the FSCM Online Application as User ID VP1
 - Navigate to: Travel and Expenses > Process Expenses > Expense Processing
 - Create a new Run Control ID, selecting the option of 'Stage Time To Project Costing' and for Business Unit US001, and launch the EX_TRAN_PRCS Application Engine Program to Success
 - Navigate to: Project Costing > Activity Definitions > Project Activities
 - Open existing Project ID GCS_PROJECT3 under PC Business Unit US001, and in the Project Activities section, click on the Details tab. On the Activity Status column, click on the available link
 - Add a new effective dated row for 31-12-2012, with a Status of 'B' (Blocked), and save the changes
 - Log into the FSCM Online Application as User ID EXA1
 - Navigate to: Employee Self-Service > Travel and Expense Center > Time Report > View
 - Open the created Time Report, select the value of 'Create Revision' from the Version Action drop down list, and click on the GO button
 - On the Time Report Line referring to Project ID GCS_PROJECT2 (The one still Open), change the booked daily hours from 4 to 5
 - Click on the Update Totals button, and then Submit button
 - Click on the OK button
 - The system throws an Error Message
 - Click on the Save For Later button to at least be able to save the changes performed without yet submitting
 - The system once again throws the Error Message

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

ERROR MESSAGE:

 " The status of "Blocked" for project GCS_PROJECT3 and activity 000000000000001 prevents additional transactions. (9000,421) "

BUSINESS IMPACT:

Employees are unable to create new Revisions on existing Time Reports to book new Time Report Lines, or change booked hours on existing Lines for a period where changes should be allowed. This is preventing corrections or new bookings on existing transactions, affecting the capacity of generating revenue of the company by delaying or preventing to interface the new changes to Project Costing, and eventually Billing and Accounts Receivable to send invoices to customers for the billed hours in company Projects.

EXPECTED BEHAVIOR:

As long as an existing Time Report has a Period End Date with a value prior to the actual effective date when any of its contained Project Activities have been Blocked, the creation and submission of new Revisions on those Time Report transactions should be allowed by the system. It is understood that on that period range, before the blocking of the Project Activity, this one was actually open, and transaction changes should be possible.

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