Invalid XX_BPEL_SUPPLIERPARTYLISTEBIZA Package (Doc ID 1286994.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Financial Management Integration Pack for Oracle Transportation Management and EBS - Version 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

AIA 2.5
Oracle Financial Management Integration Pack for Oracle Transportation Management and EBS

Following 2 packages are invalid which is causing sync of suppliers to fail.

  XX_BPEL_INITIALLOADSUPPLIERPAR
  XX_BPEL_SUPPLIERPARTYLISTEBIZA

Details of compilation errors

Compilation errors for PACKAGE BODY APPS.XX_BPEL_SUPPLIERPARTYLISTEBIZA
#13#10Error: PLS-00306: wrong number or types of arguments in call to 'PL_TO_SQL2'
Line: 851
Text: aSqlItem.SITE_REC := PL_TO_SQL2(aPlsqlItem.SITE_REC);
#13#10Error: PL/SQL: Statement ignored
Line: 851
Text: aSqlItem.SITE_REC := PL_TO_SQL2(aPlsqlItem.SITE_REC);
#13#10Error: PLS-00382: expression is of wrong type
Line: 859
Text: aPlsqlItem.SITE_REC := SQL_TO_PL2(aSqlItem.SITE_REC);
#13#10Error: PL/SQL: Statement ignored
Line: 859
Text: aPlsqlItem.SITE_REC := SQL_TO_PL2(aSqlItem.SITE_REC);

Compilation errors for PACKAGE BODY APPS.XX_BPEL_INITIALLOADSUPPLIERPAR
#13#10Error: PLS-00306: wrong number or types of arguments in call to 'PL_TO_SQL2'
Line: 1

Changes

AP <Patch 9844445>

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