Upload Payment Records in the Pre-Staging Area
Oracle Revenue Management and Billing allows you to validate the payment records before you move them to the staging area. You can upload and validate the payment records in the pre-staging area. 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.
While uploading a payment data file, you need to specify the file type using which you want to upload the payment data file. The file type indicates the mapping and validation algorithms that you want to use for the payment data file. Therefore, while defining a file type using which you want to upload a payment data file, you need to:
-
Set the feed type to Payment Upload Data
-
Attach mapping algorithm which is created using the C1-CSVUPLPAY algorithm type
-
Attach validation algorithm which is created using the C1-PUPLVALID algorithm type
On uploading a payment data file, the mapping algorithm does the following:
-
Validates whether the file is in the CSV format
-
Validates whether at least one payment record is available in the CSV file
-
Parses the flat file in the CSV format and maps the columns in the CSV file to various tables in the database
-
Uploads the payments records in the pre-staging area
The validation process starts immediately after the payment data file is uploaded in the system. During the validation process, the system and custom validations (if any) are executed. The system checks whether:
-
The data is available in the Tender ID, Tender Amount, Payment Amount, Date Received, Bank Account, and Payment Type columns in the CSV file.
-
The data is available in the Match Type and Match Value columns in the CSV file.
Note: This validation is done when the Is Match Type Validation Required (Y/N) parameter is set to Y in the validation algorithm. -
The payee and payor accounts specified in the payment record exists in the system.
-
The payee account with the specified account identifier type and account identifier combination exists in the system.
-
A valid currency code is specified in the payment record.
Note: If the currency code is not specified, the currency is set to the payor account’s invoice currency. -
The payment type (i.e. tender type) specified in the payment record exists in the system.
-
The account identifier type specified in the payment record exists in the system.
Note: This validation is done when the payee account ID is not specified in the payment record. -
The match type specified in the payment record exists in the system.
Note: This validation is done when the Is Match Type Validation Required (Y/N) parameter is set to Y in the validation algorithm. -
The characteristic type specified in the payment record exists in the system.
-
The characteristic value matches any predefined value when the characteristic value type is set to Predefined Value.
-
The characteristic value is specified in the payment record when the characteristic type is specified and vice-versa.
You can upload a file by clicking the Upload link in the Payment Upload screen. On uploading a payment data file, the payment records are copied to the pre-staging area and the status of the payment data file is set to Pending. The validation process starts immediately after the payment data file is uploaded in the system. If a payment record is successfully validated, the status of the payment record is set to Valid. If a payment record contains incorrect or missing data, the status of the payment record is set to either Invalid or Error depending on the scenario. For more information about the scenarios when a payment record is set to the Invalid or Error status, see Payment Record Status Transition.
Once the validation process is completed, the status of the payment data file is changed to Validated. Once the payment records are uploaded and validated in the pre-staging area, you can do either of the following:
-
Move the payment records to the staging area
-
Cancel a payment data file
-
Replace the existing payment data file