Physical Inv Control Page : Adding Scan Fieldname IP_ADDRESS & IP_ALIAS Causes The Process To Fail (Doc ID 2276449.1)

Last updated on JUNE 13, 2017

Applies to:

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

Symptoms

On : 9.2 version, Physical Inventory

Physical Inv Control page : Adding Scan Fieldname IP_ADDRESS & IP_ALIAS causes the process to fail

When adding the IP_ADDRESS & IP_ALIAS scan fieldname to the page it cases the Generate Result step to fail.

ERROR
-----------------------
Transaction Loader
 
Generate-PI-Results
c:\bld\g\e920\ora\e920zxzx\sqr\ampi1000.sqr: AMIF1000 - SQL Statement =
Execute-PI-Result-SQL2
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("EMDBO"."PS_PI_RES_IP"."IP_ALIAS")

Error on line 71:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Asset Management > Physical Inventory > Physical Inventory Control
2. Add the Scan Fields IP_ADDRESS & IP_ALIAS
3. Run the Physical Inventory process for Generate Result,
4. The process return with error.

Changes

 

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