What Are the Criteria Used by the 'Event Creation' Process (INPCCREA) For Selecting Rows from the PS_PHYSICAL_INV Table?
Last updated on AUGUST 12, 2016
Applies to:PeopleSoft Enterprise SCM Inventory - Version 8 SP1 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2013***
According to PeopleBooks (see below), the 'Event Creation' process (INPCCREA) (navigation: Inventory, Inventory Counts, Prepare Counting Event, Create Counting Event) obtains the Item data from the PS_PHYSICAL_INV table or the Manual Count table, but what criterion is being used by the process to account for the variety of transaction types for each line in the PS_PHYSICAL_INV table? How are the Return To vendors, Inventory Adjustments In/Out, etc removed or included in the result sets? The Items themselves are chosen based off the Last Count Date, Utilization Types, etc, but how are the lines in the PS_PHYSICAL_INV table filtered out?
You create counting events by launching the Event Creation process. You can create counting events before or after entering the count quantity data. A counting event includes a header and a list of the items being counted. The item information includes storage location, lot ID, serial ID, container ID, staged date, quantity, and unit of measure (UOM). The system obtains this information from the Manual Count table for manual counting events or from the PHYSICAL_INV for system-defined counting events.
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