R12: AGIS Batch Status Goes Submitted To Approved But Never Complete,3103: Attribute 'RESP_ID' does not exist for item 'FUNGLINT/
Last updated on MARCH 08, 2017
Applies to:Oracle General Ledger - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Oracle Financials Common Modules - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
AGIS transactions are successfully entered and submitted. The Recipient approves the transaction, but the transaction never goes to Complete status.
If the batch is resubmitted it goes into a loop of submit -> approve -> submit -> approve. The transaction is never completed.
The GL Transfer option is set to Online.
Invoicing is not required.
Manual Approval is required.
The Workflow Status Monitor shows the following information for the workflows that have status Error:
Error Activity Label: GL_TRANSFER:GET_ATTR_GL
Error Message: 3103: Attribute 'RESP_ID' does not exist for item 'FUNGLINT/561866_........'
The issue can be reproduced at will with the following steps:
1. Enter an AGIS transaction. Submit it.
2. Recipient approves the transaction
3. Review the Workflow Status:
(a) Login as User SYSADMIN
(b) Responsibility -> Workflow Administrator Web Applications -> Administrator Workflow -> Status Monitor
(c) Search for the workflow with the following values -
Internal Name: FUN%
Item Key: <Batch Id%>
Note: Make sure that Workflow Owned By is "All Employees and Users / Your
User" (Otherwise you will not be able to view any workflows).
For the workflows that have status Error, click on the Child Workflows icon.
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