AGIS Intercompany Import Program ERROR: Combination of Source and Group ID not found in Interface Table or user does not have access to initiator for any batch in the group
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.
On : 12.1.3 version, AGIS Reports
The customer is having AGIS Intercompany Import Program Failure
Error information from log:
ERROR: Combination of Source and Group ID not found in Interface Table or user does not have access to initiator for any batch in the group.
Have just applied the latest FUN RPC . Confirmed Security permissions are correct.
FUNXIMPB version information.
$ strings -a $FUN_TOP/patch/115/sql/funximpb.pls | grep '$Header'
$Header: funximpb.pls 120.22.12010000.18
Data is being placed in the AGIS interface tables via PL/SQL insert script
and being imported. This was working until application of <Patch:20238179:R12.FUN.B> RPC FOR FUN FEB 2015.
Similar issue in reported and resolved in:
<Bug:10030555> - GSI: R12.1.3: GSIBB: INTERCOMPANY IMPORT PROGRAM CAN'T FIND INTERFACE DATA
That was to be fixed in funximpb.pls 120.22.12010000.10
Finding that if WEB ADI is used with the seeded template that the import is successful. Issue is specific to the custom PL/SQL loaded data.
Data being uploaded to FUN_INTERFACE_BATCHES at this time:
and this was working before the patch being applied.
Application of <Patch:20238179:R12.FUN.B> RPC FOR FUN FEB 2015.
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