The Transaction Date (TRANSACTION_DATE Field in the PS_CM_CST_NSSHIP Table) Is Stamped Differently when Using the 'Mark Lines For Billing' Page or SQR Report (OMMARKLN)
Last updated on AUGUST 04, 2016
Applies to:PeopleSoft Enterprise SCM Order Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
The Transaction Date (TRANSACTION_DATE field in the PS_CM_CST_NSSHIP table) is not updated in the same way depending on how a Sales Order line is marked for Billing. When using the 'Mark Lines For Billing' page the Ship Date is used and when running the OMMARKLN SQR report the current date is used (navigation: Order Management, Quotes and Orders, Create OM Billing Entries).
Steps to replicate the issue:
- Create 2 Sales Orders for a non-Inventory Item.
- Wait for one day.
- Mark the Sales Order # 1 for Billing using the 'Mark Lines For Billing' page and use Ship Date = yesterday.
- Run the OMMARKLN SQR report for Sales Order # 2.
- Check PS_CM_CST_NSSHIP.TRANSACTION_DATE. It's yesterday for Sales Order # 1 and today for Sales Order # 2.
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