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 OCTOBER 27, 2021

Applies to:

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


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.

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.

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.


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.