My Oracle Support Banner

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

Last updated on NOVEMBER 23, 2019

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.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.