Upload Validated Payment Data

Oracle Revenue Management and Billing until now provided you with an ability to interface payments from an external source, such as remittance processor. The system supported two mechanisms to upload payment data - one using which you can populate payment upload staging records and another using which you can populate payment event upload staging records. The system now enables you to validate the payment records before you move them to the staging area. The system provides the pre-staging area where you can upload and validate the payment records. The system provides a user interface which helps you to upload a payment data file in the pre-staging area. It also helps you to perform various tasks, such as:

• Track the status of the payment records and the payment data file

• Move the payment records to the staging area

• Cancel a payment data file

• View the log of a payment data file

• Apply payments on the unpaid bills of an account or a statement

You can upload a payment data file in the CSV format. You need to ensure that the CSV file is in the required format; otherwise the file will not be uploaded in the system. For more information about the CSV file format, see CSV File Format. At present, the system supports only the CSV file format. This is because the payment data mapping algorithm type shipped with the product is designed to support the CSV format. If you want to use any other file format, you need to define custom mapping algorithm type that supports the required file format.

The file type using which you upload a payment data file indicates the mapping and validation algorithms that you want to use for the payment data file. On uploading a payment data file, the mapping algorithm parses the CSV file and uploads the payments records in the pre-staging area. The validation process starts immediately after the file is uploaded in the system. During the validation process, the system and custom validations (if any) are executed. Once the validation process is complete, you can move the payment records from the pre-staging to staging area. Once the payment records are moved to the staging area, the system creates payment events, tenders, payments and payment segments through a batch process. For more information about the payment upload process, see Payment Upload Process.

During the payment upload process, a payment data file and each record of the file goes through various statuses until the payment events and payments are created. For more information about the payment data file and payment record statuses, see Payment Data File Status Transition and Payment Record Status Transition, respectively.

Related Topics

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes