PC_EXPRSS_AM Abended At Step PC_EXPRSS_AM.NEWASSTS.ACTLOC - RC = 1407 (Doc ID 2091411.1)

Last updated on DECEMBER 28, 2015

Applies to:

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

Symptoms

On : 9.1 version, Other

When attempting to PC_EXPRSS_AM,
the following error occurs.

ERROR
-----------------------
-- 09:49:32.723 Process 4389576 ABENDED at Step PC_EXPRSS_AM.NewAssts.ActLoc (Action SQL) -- RC = 1407
ROLLBACK
/
-- 09:49:32.785 SQL Error: ORA-01407: cannot update ("SYSADMIN"."PS_PC_AM_DEFN"."LOCATION") to NULL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the PC_EXPRSS_AM to clear any pending transaction that need to be processed
2. Create a Project and Activity with the Asset Integration rules. Asset Integration Rule : "One Asset per Activity" , Asset Creation Trigger - Activity Status 'A', Asset Location Source : "Activity".
3. No Location information provided for activity under Location tab of Activity General Information.
4. Create an Activity Status of 'A' for this Activity
5. Create an Express Asset Definition.
6. No Location information is provided on the Asset Definition
7. Run PC_EXPRSS_AM process using the navigation : Project Costing > Assets > Express Capitalization Process. You can choose "Summarize" as Asset Processing Destination.
8. The process abends with message : Process 12802 ABENDED at Step PC_EXPRSS_AM.NewAssts.ActLoc (SQL) -- RC = 1407

 

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