AGIS Transactions are Stuck In Approved And Submitted Status transactions will not pass to Receivables (Doc ID 1983945.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

New Setup attempting to generate AGIS data that when the transaction is approved will transfer data to Receivables (using batch mode)
via the program Program: Transfer Intercompany Transactions to Receivables.    Currently this is not working as expected.
The status of the batch remains in Submitted status for the Outbound transaction and Approved for the inbound transaction.

Review of the workflow shows the following:

 Current Location:
Update Transaction Status Process/Receive Transaction is Approved by
Recipient Event

Error Message:
3103: Attribute 'RECEIVE_EVENT_NAME' does not exist for item
'FUNIMAIN/79069_775260EF8831455B54B84E0533784040A96DD'.

The following is found in the FND log generated for a transaction having this issue:

What is being found in the FND log are the following errors (summary):

checking distributions
fetched details from headers
Unexpected Error
ORA-06508: PL/SQL: could not find program unit being called FND_FUNCTION.GET_FUNCTION_ID(p_function_name =>WF_G_RESPONSES); returning v_function_id:12490

Not deferring denormalization, so using session's settings
"subject(Error in Workflow FUNRMAIN/79076_775610EF8831456184B84E0533784040A96DD ORA-04061: existing state of  has been invalidated
ORA-04061: existing state of package ""APPS.FUN_XLA_TAB_PKG"" has been invalidated ORA-04065: not executed, altered or d)"


  BEGIN   END   Not deferring denormalization, so using  session's settings   subject(Error in Workflow  FUNIMAIN/79076_775610EF8831456214B84E0533784040A96DD 3103: Attribute
 'RECEIVE_EVENT_NAME' does not exist for item  'FUNIMAIN/79076_775610EF8831456214B84E0533784040A96DD'.)   END   Parameters
passed   p_nlsLanguage: AMERICAN, p_nlsTerritory:  AMERICA   p_nid: , p_nlsDateFormat: DD-MON-RR   p_nlsDateLanguage: AMERICAN, p_nlsSort:
 BINARY   p_nlsNumericCharacters: .,,  p_nlsCalendar:    END

   oracle.apps.fnd.framework.OAException:
 Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE =  java.sql.SQLException: ORA-01403: no data found ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1951
   ORA-06512: at line 1

This has not worked in the past and occurs for all Batches.
AME is not being used in this case.                        


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