SPS/PAM File And Payment Batch Treasury Symbol Listing Report Contain Invalid BETC (Doc ID 1941886.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle U.S. Federal Financials - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

SPS/PAM File and Payment Batch Treasury Symbol Listing Report contain invalid BETC

It appears that when payment of an Invoice partially offset with a Prepayment that results in a value of 1 within the FV_TP_TS_AMT_DATA.is_credit the system isn't citing the proper BETC value (i.e.; it cites DISB as was defined on the record). The resulting PAM file as well as the report include the BETC value cited on the PREPAY line item vs. citing the corresponding Adjustment BETC as its been configured within FV_BETC_CODES.adjustment_betc (i.e.; the adjustment BETC value is configured as DISBAJ). When attempting to certify the payment file within SPS it indicates that the BETC value of DISB cannot be a credit (nagative amount) and forces the Certifying officer to certify the file using another BETC (i.e.; DISBAJ) for which a credit is valid. Since this BETC wasn't included in the PAM file this change results in a Statement of Differences (SOD) that must then be resolved/reconciled downstream.

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