What Should Be The Value For SCAN_TYPE, LAST_SCAN_DTTM, PI_OVERWRITE_LOC, SCAN_BY_OPTION In PI_SCAN (Doc ID 2214167.1)

Last updated on DECEMBER 14, 2016

Applies to:

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

Goal

Qn1:

There were new fields added to the Physical Inventory table, PS_PI_SCAN, in Image 21. What values need to be populated in this fields: SCAN_TYPE, LAST_SCAN_DTTM, PI_OVERWRITE_LOC, SCAN_BY_OPTION

Qn2:

Are these new pages or fields? I do not see these in our Demo environment. We are on Peopletools 8.53 Image 21.
* SCAN_BY_OPTION - default is T. optional value: T- Tag number or S - serial id. So depend on your scanning option, if using Tag or Serial ID.
This option can be setup in Setup Financials/Supply Chain > install>installation option>asset management

*PI_OVERWRITE_LOC can be set to blank, Y or N. If you force asset location update then the value is Y. Otherwise you can leave this blank
This option can be setup in: Setup Financials/Supply Chain > Product Related > Asset Management > Physical Inventory > Scan Options> Scan by Location tab.

Qn3:

What is the minimum Peopletools requirement?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms