AGIS Transaction Shows Error Status After Recipient Approval With No Oter Details (Doc ID 1931653.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

AGIS transaction shows Error status after the Recipient approved the transaction.

There are no specific error messages thrown.

The issue happens only for transactions against a newly defined Recipient organization.

Transaction Account Definition is used in order to derive the Intercompany Accounts.

Run script wfstat.sql and find the following error message:

Unable to generate intercompany account. Error:  The Intercompany account generated by the Intercompany Balancing Rules is invalid. Unable to generate intercompany account. Error :  The Intercompany account generated by the Intercompany Balancing Rules is invalid. ORA-01400: cannot insert NULL into ("FUN"."FUN_INTER_ACCOUNTS_ADDL"."CCID") in Package FUN_BAL_UTILS_GRP Procedure Get_Intercompany_Account

 

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