Why Is the Analysis Type Field (ANALYSIS_TYPE) in the PS_IN_DEMAND Table Not Getting Populated Anymore from Release 8.9? (Doc ID 1992618.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8.9 and later
PeopleSoft Enterprise SCM Order Management - Version 8.9 and later
Information in this document applies to any platform.

Goal

In releases < 8.9, when a demand line is created the Analysis Type field (ANALYSIS_TYPE) in the PS_DEMAND_INF_INV table is populated with a value which categorized the source of the transactions (for example 'ORD' when the demand line was created for a Sales Order in Order Management).

From release 8.9, the Inventory tables PS_DEMAND_INF_INV, PS_DEMAND_INV, and PS_SHIP_INF_INV have been combined into one table called PS_IN_DEMAND. At the same time, the Analysis Type field is not getting populated anymore when a demand line is created. Why is that?

Note that demand lines which are upgraded from a release < 8.9 to a release >= 8.9 still have an Analysis Type value in the PS_IN_DEMAND table.

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