EAP: Reporter Category Not Correctly Determined when Bank SetID and Vendor SetID are Different

(Doc ID 1915841.1)

Last updated on FEBRUARY 11, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

In page peoplecode for page AP_IPAC_SEC.Activate, the same Set ID (Bank SetID) is used to determine the Reporter Category.

      SQLExec("SELECT A.GWA_REPORTER_CATG FROM PS_AGENCY_LOC_CD2 A WHERE
A.SETID = :1 AND A.ALC = :2 AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT
MAX(I.EFFDT) FROM PS_AGENCY_LOC_CD2 I WHERE I.SETID = A.SETID AND I.ALC =
A.ALC AND I.EFF_STATUS = 'A' AND I.EFFDT <= %DATEIN(:3) )", &ipac_bank_setid,
&CUSTOMER_ALC, VOUCHER.INVOICE_DT, &alc_rep_catg);
      SQLExec("SELECT A.GWA_REPORTER_CATG FROM PS_AGENCY_LOC_CD2 A WHERE
A.SETID = :1 AND A.ALC = :2 AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT
MAX(I.EFFDT) FROM PS_AGENCY_LOC_CD2 I WHERE I.SETID = A.SETID AND I.ALC =
A.ALC AND I.EFF_STATUS = 'A' AND I.EFFDT <= %DATEIN(:3) )", &ipac_bank_setid,
&SENDER_ALC, VOUCHER.INVOICE_DT, &alc_rep_catg_s);
      
When the SETIDs differ, it is possible to save incomplete IPACinformation.  For instance if the the Reporter Category is 'IPAC Only' it is possible to save the IPAC information without entering a Receiver TAS ID.

STEPS
1.  Define Agency Codes under set id's SHARE and SHR03.   Assign Reporter Category of 'IPAC Only'
Set Up Financials / Supply Chain > Common Definitions > Agency Location Codes > Location Codes

2.  Define Vendors under Set ID's SHARE and SHR03
Vendors > Vendor Information > Add/Update > Vendor

3.  Table Set Control for FED01
    FS_39 (Banks) SHARE
    FS_S8 (Vendors) SHR03
PeopleTools > Utilities > Administration > TableSet Control

4.  Enter voucher in BU FED01 for vendor, bank account FDBNK/IPAC
Accounts Payable > Vouchers > Add/Update > Regular Entry

5.  Enter information on IPAC page.  Do not Enter Receiver TAS.

6.  Click Ok to Save.

For same steps when FS_38 is SHARE the information on the IPAC page cannot be saved unless a value is entered for Receiver TAS.

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