Physical Inv Control Page : Adding Scan Fieldname IP_ADDRESS & IP_ALIAS Causes The Process To Fail
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms