My Oracle Support Banner

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

Last updated on AUGUST 28, 2023

Applies to:

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

Symptoms

When adding the IP_ADDRESS & IP_ALIAS scan field name to the Physical Inventory Control, it causes 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.

Replication 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 Results,
4. The process returns 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.