CIS:Need an ORDER BY clause in CIPBBLSG.DMS.
Last updated on MAY 29, 2007
Applies to:PeopleSoft Enterprise Revenue Management Billing - Version: 8.9 - Release: 8.9
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 713413
During conversion, accounts that were too recent to have been billed in customer's Legacy system had bill segments (PS_CI_BSEG table) generated with the same START_DT and END_DT. When a new bill segment is generated during the billing process, the START_DT is obtained by selecting all bill segments for the current SA, sorted in START_DT descending order, and using the END_DT from the first row returned as the new START_DT. In the second billing, when the START_DT and END_DT are equal, there is a possibility that the wrong END_DT will be used to get the new START_DT.
Here is the SQL statement in STORE CIPBBLSG_S_PREVBS:
SA_ID = :1
AND START_DT < :2
AND BSEG_STAT_FLG <> '60'
The following is an example of the
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms