My Oracle Support Banner

Transfer InterCompany Transactions to Receivables Program is Not Picking the Payment Terms (Doc ID 1987537.1)

Last updated on MAY 15, 2018

Applies to:

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


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

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.
where site_use_code = 'BILL_TO'
and site_use_id = p_site_use_id;

If there is no value here then calling the below.
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


To view full details, 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 a vibrant support community of peers and Oracle experts.