Tracking Collection Triggers

In the past I have struggled to track the triggers for ADM, and whilst it is possible to see where the values are added to the table (see my earlier posting in relation to overdue processing), since the process deletes the trigger records on completion of the run, it results in no indication historically of what the associated value was which triggered this process.

I have since discovered that the system records the NEXT_CR_RVW_DT on the CI_BILL records, in addition to CI_ADM_RVW_SCH, and as a result this can be used as part of the investigation into why ADM reviewed particular records, and when this review was scheduled to occur.

Whilst it is by no means a complete solution, since Insufficient Funds payment Cancellations, Non-Billed Budgets and Payment Plans can also affect the CI_ADM_RVW_SCH table, it does provide an indication of the dates associated with bill-related reviews. Analysis of the Account Financial History, and Events is normally sufficient to track these other triggers.
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Stuart Ramage

I am a Consulting Technical Manager for Oracle Corporation, and a member of the OU Black Belt Team, based in Hobart Tasmania.
I have worked in the Utility arena since 1999 on the Oracle UGBU product line, in a variety of roles including Conversion, Technical and Functional Architect.

Contact me on:

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today