Transfer InterCompany Transactions to Receivables Program is Not Picking the Payment Terms
(Doc ID 1987537.1)
Last updated on FEBRUARY 21, 2019
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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!