Dm_fusa Send Files Do not Have All Required Fields (Doc ID 788745.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
The fusa send files created from OOB dm_fusa do not contain the T record at the end as required by
paymentech to process the file. The following are last 3 lines from 7.3.1 dm_fusa

A3DENVER , CO 80222
B RECS=000000005 ORDS=000000001 $TOT=00000000000795 $SALE=00000000000795 $REFUND=00000000000000
PID=090909 XXXXXX SID=090909 XXXXXX END 090129
EOFEOFEOF

This is part of the 6.7 -> 7.3.1 upgrade project.
These are the last 3 lines from 6.7 dm_fusa:

A3LOS ANGELES , CA 90024
B RECS=000000016 ORDS=000000015 $TOT=00000000024420 $SALE=00000000024420 $REFUND=00000000000000
T RECS=000000017 ORDS=000000015 $TOT=00000000024420 $SALE=00000000024420 $REFUND=00000000000000
PID=563999 BOINGO96 SID=563999 WIRELESS END 090121
EOFEOFEOF

-- Steps To Reproduce:
1) run pin_bill_day
2) run pin_collect or any other collections process that uses dm_fusa
3) check the fusa_temp/fusas* file



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms