Transfer InterCompany Transactions to Receivables Program is Not Picking the Payment Terms

(Doc ID 1987537.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Global Accounting Engine - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Transfer Inter company Transactions to Receivables program is not picking the payment terms as expected.
Package being called is funartrb.pls.

Expectation:
Following is the hierarchy that should be used to default the payment term while transferring the AGIS transaction to Receivables:
1. Customer bill-to site level
2. Customer account level
3. Customer level transaction type
4. Default value '4'

Current functionality:
If the payment term is defined at site use level, then the same values is passed to AR interface tables.

If the payment term is null at site use level, then it should pick from site level.
But this is not happening.
This is picking the default value 4 directly. Package is not checking the values at site/account/Transaction type level.

Package is first checking at site use level using the below query.
select PAYMENT_TERM_ID
from HZ_CUST_SITE_USES_ALL
where site_use_code = 'BILL_TO'
and site_use_id = p_site_use_id;

If there is no value here then calling the below.
select STANDARD_TERMS
from HZ_CUSTOMER_PROFILES
where cust_account_id = p_cust_acct_id;

There is no condition for site level in this query.

package version : funartrb.pls 120.15.12010000.14

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