CM_ACCTG_LINE DT_TIMESTAMP Does Not match on TRANSACTION_INV

(Doc ID 2224413.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

The DT_TIMESTAMP field on CM_ACCTG_LINE sub-ledger does not match the same field on TRANSACTION_INV.  The DT_TIMESTAMP on CM_ACCTG_LINE appears to get the date timestamp of the run of the journal process.

Problem steps:
1) Create any inventory transaction.
2) Cost these transactions using CM_CSTACCTG program
3) Run Generate Journals
4) Now notice that the DT_TIMESTAMP field on PS_CM_ACCTG_LINE table sub-ledger does not match the same field on PS_TRANSACTION_INV inventory transactions table.

 

Changes

Not applicable. 

Cause

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