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.


When adding the IP_ADDRESS & IP_ALIAS scan field name to the Physical Inventory Control, it causes the Generate Result step to fail.

Transaction Loader
c:\bld\g\e920\ora\e920zxzx\sqr\ampi1000.sqr: AMIF1000 - SQL Statement =
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.


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

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