4.5 Bill Details

This topic describes the information about Bill Details.

• When bill details for existing delinquent accounts are updated, the changes are loaded into the OBC staging area with RECORD_TYPE = 'U' (Update) or RECORD_TYPE = 'D' (Delete). An automated batch process then validates and processes these staging records and applies the corresponding updates to the main entity table. Each record is uniquely identified by the combination of Record Type, Product Processor, Account Number, and Bill Generation Date.
• For RECORD_TYPE = 'U': Oracle Banking Collections checks whether a record exists for the specified Account Number, and Bill Generation Date. If a match is found, the record is updated; if not, a new record is inserted.
• For RECORD_TYPE = 'D': Oracle Banking Collections checks whether a record exists for the specified Account Number, and Bill Generation Date. If a match is found, the record is deleted; otherwise, the request is rejected with an appropriate error.