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 (Doc ID 2002476.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

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:
SOURCE
GROUP_ID
BATCH_ID
BATCH_NUMBER
INITIATOR_ID
CURRENCY_CODE
DESCRIPTION
TRX_TYPE_ID
GL_DATE
BATCH_DATE
REJECT_ALLOWED_FLAG

and this was working before the patch being applied.

Changes

 Application of <Patch:20238179:R12.FUN.B>  RPC FOR FUN FEB 2015.

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