AGIS Transactions are Stuck In Approved And Submitted Status transactions will not pass to Receivables
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.
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:
Update Transaction Status Process/Receive Transaction is Approved by
3103: Attribute 'RECEIVE_EVENT_NAME' does not exist for item
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):
fetched details from headers
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
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.
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