Federal SPS Program Generates File That Fails With Treasury

(Doc ID 2391036.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle U.S. Federal Financials - Version 12.2.3 and later
Information in this document applies to any platform.
Requirement
-----------
The SPS Summary File generated by Oracle should not insert detail record for a TAS if total payment amount for the TAS is $0

Test case details
----------------
1) Created invoice: TEST and matched to a PO Line

2) PO Line had two distributions.
Dist 101 for $0 with one code combination
Dist 102 for xxxx for another distribution

3) Validated invoice

4) Ran a PPR

5) PPR selected many invoices including this one

6) Completed the PPR

7) Generated SPS Summary Schedule for the PPR in "SPS Summary File" form

I will upload attachment of the SPS generated by Oracle
you will notice that all the payments that are part of the PPR are summarised by TAS (treasury account symbol)

For TAS XXXXXXXXXXXX , in the output file , the total amount is 0

You can see it in the record
XXXXXXXXXXXXXXXXX XXXXXXXXXXXXX 1000000000000000

Because of this $0 record, Treasury rejects this file.
Treasury expects only non-zero records.

Symptoms

On : 12.2.3 version, Payables

"SPS Summary File" form in Payables generates SPS file (440 file) that is uploaded to Treasury for Treasury to make payments.
This file generates a summary level information of total payment amount for each Treasury Account Symbol (TAS)
If there is an invoice with a $0 invoice distribution against an account that maps to a TAS  and there are no other invoices with that distribution account , the summary SPS file for the PPR
that pays the invoice will indicate $0 as total payment for the TAS

This $0 total information is causing Read Error on Treausry's system.
If  we remove this entire detail record (TAS and corresponding amount) and retry , the file is accepted by Treasury.


Requirement
-----------
The SPS Summary File generated by Oracle should not insert  detail record for a TAS if total payment amount for the TAS is $0

Test case details
----------------
1) Created invoice: TEST and matched to a PO Line

2) PO Line had two distributions.
Dist 101 for $0  with one code combination
Dist 102 for xxxx for another distribution

3) Validated invoice

4) Ran a PPR

5) PPR selected many invoices including this one

6) Completed the PPR

7) Generated SPS Summary Schedule for the PPR in "SPS Summary File" form

I will upload attachment of the SPS generated by Oracle
you will notice that all the payments that are part of the PPR are summarised by TAS (treasury account symbol)

For TAS XXXXXXXXXXXX , in the output file , the total amount is 0

You can see it in the record
XXXXXXXXXXXXXXXXX XXXXXXXXXXXXX    1000000000000000     

Because of this $0 record, Treasury rejects this file.
Treasury expects only non-zero records.

Changes

 

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