My Oracle Support Banner

EAP: First Voucher Line Distribution Line does not automatically populate the Affiliate field for InterUnit Supplier (Doc ID 2007690.1)

Last updated on FEBRUARY 07, 2019

Applies to:

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


When creating a Regular Voucher, and adding the Supplier ID value from the Voucher's "Add A New Value" initial page, the first Invoice Distribution Line does not have the Affiliate chartField automatically populated even though it is expected to be populated.  When adding a new Distribution Line, whether this one is from a new Voucher Line, or the current one, the same ChartField Affiliate is correctly populated.

On the contrary, when adding the Supplier ID value directly from the newly created Voucher > Invoice Information page, the same Affiliate chartField is completed on the first line.

   - Log into the FSCM Online Application as User ID = VP1
   - Navigate to PeopleTools > Utilities > Administration > TableSet Control
   - Dispaly Set Control Value = CAN01, and make sure that the following list of Record Groups are all pointing to delivered Set ID = CAN01:
        - AM_19 - Suppliers
        - AP_01 - AP Business Unit Options
        - AR_03 - Business Unit Options
        - BI_01 - Billing Business Unit Options
        - EX_01 - Business Unit Options
        - FS_04 - Detail Ledgers
        - FS_21 - Tree Node & Tree Level Tables
        - FS_44 - VAT Apportionment
        - PO_01 - Purchasing BU Options
        - SAC_01 - SCM Approval Workflow
        - WM_02 - Work Order Service Group
   - Navigate to Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition
   - Display Business Unit = CAN01
   - At the Definition tab, select the check box for 'Customer Supplier Affiliate'
   - Navigate to Set Up Financials/Supply Chain > Common Definitions > Distribution Accounting > Distribution Code
   - Create a new Distribution Code with the below values:
        - Set ID = SHARE
        - Distribution Code = CAN01
        - Effective Date = 01-01-1900
        - Status = Active
        - Distribution Type = Accounts Receivable
        - Account = 100000
        - Alternate Account = 530000
   - Navigate to Suppliers > Supplier Information > Add/Update > Supplier
   - Display Supplier ID = CAN0000001, and at the Identifying Information tab, set up the below settings:
        - InterUnit Supplier = Y
        - InterUnit Supplier ID = CAN01
   - Navigate to Set Up Financials/Supply Chain > Product Related > Procurement Options > Vouchers > Session Defaults
   - Create a new Session with the below defaults:
        - Type = All Users
        - Name = TEST:ACCRUAL
        - Business Unit = CAN01
        - Rate Type = CRRNT
        - Acctg Date = 01/01/2015
        - Origin = NET
        - GL Business Unit = CAN01
        - Account = 100000
   - Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
   - Set Business Unit = CAN01
   - Click on ADD button
   - At the 'Invoice Information' tab, click on ‘Session Defaults’ link
   - Select the created Session, and click Apply button
   - Back at the Voucher Entry page, click on Add button
   - At the 'Add A New Value' page, define the below values:
        - Business Unit = CAN01
        - Select Supplier ID CAN0000001
   - Click on Add button
   - Check Voucher Line Distribution section, and confirm Affiliate field is blank, and grayed out

The Affiliate field at the Voucher Line Distribution level should be automatically populated, regardless of defining the Supplier ID at the time of entering the data in 'Add A New Value' page, or already at the 'Invoice Information' tab.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.