Post Upgrade, Autoinvoice Import Program Error: APP-AR-11526: ORA-28113: policy predicate has error (Doc ID 2546654.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

Autoinvoice Import Program error Post Upgrade

ERROR
===============

In Autoinvoice Log File

-------------------------
APP-AR-11526: ORA-28113: policy predicate has error
  
insert into RA_INTERFACE_ERRORS (INTERFACE_LINE_ID,MESSAGE_TEXT,INVALI
APP-AR-11526: 12715851/ar/lib/raavpm.lpc 536
Error calling raavpm()
Error calling raapic()

In Trace File

--------------

Error information for ORA-28113:
Logon user     : APPS
Table/View     : AR.AR_RECEIPT_METHOD_ACCOUNTS_AL#
VPD Policy name    : ZD_SEED
Policy function: APPS.AR_RECEIPT_METHOD_ACCOUNTS_AL=
RLS view  :
SELECT  "REMIT_BANK_ACCT_USE_ID","RECEIPT_METHOD_ID","CASH_CCID","CREATED_BY","CREATION_DATE","EARNED_CCID","LAST_UPDATED_BY","LAST_UPDATE_DATE","ON_ACCOUNT_CCID","START_DATE","UNAPPLIED_CCID","UNEARNED_CCID","UNIDENTIFIED_CCID","BANK_CHARGES_CCID","END_DATE","FACTOR_CCID","FACTOR_PRINT_PROGRAM_ID","FACTOR_TRANSMISSION_PROGRAM_ID","LAST_UPDATE_LOGIN","MIN_RECEIPT_AMOUNT","RECEIPT_CLEARING_CCID","REMITTANCE_CCID","REMIT_PRINT_PROGRAM_ID","REMIT_TRANSMISSION_PROGRAM_ID","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","PRIMARY_FLAG","CLEARING_DAYS","SHORT_TERM_DEBT_CCID","OVERRIDE_REMIT_ACCOUNT_FLAG","RISK_ELIMINATION_DAYS","ORG_ID","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15","GLOBAL_ATTRIBUTE16","GLOBAL_ATTRIBUTE17","GLOBAL_ATTRIBUTE18","GLOBAL_ATTRIBUTE19","GLOBAL_ATTRIBUTE20","GLOBAL_ATTRIBUTE_CATEGORY","EDISC_RECEIVABLES_TRX_ID","UNEDISC_RECEIVABLES_TRX_ID","BR_COLLECTION_DAYS","BR_STD_RECEIVABLES_TRX_ID","BR_REMITTANCE_CCID","BR_FACTOR_CCID","CLAIM_RECEIVABLES_TRX_ID","OLD_BANK_ACCOUNT_ID","ZD_EDITION_NAME","ZD_SYNC" FROM "AR"."AR_RECEIPT_METHOD_ACCOUNTS_AL#"   "AR_RECEIPT_METHOD_ACCOUNTS_AL#" WHERE (ZD_EDITION_NAME = 'SET1') 
ORA-04098: trigger 'APPS.AR_RECEIPT_METHOD_ACCOUN_AI' is invalid and failed re-validation
-------------------------------------------------------------
Parent policy predicate:
Synonym        : APPS.AR_RECEIPT_METHOD_ACCOUNTS
VPD Policy name    : ORG_SEC
Policy function: APPS.MO_GLOBAL.ORG_SECURITY
RLS predicate  :
org_id = sys_context('multi_org2','current_org_id')
=====================
PARSE ERROR #139984360286344:len=1074 dep=0 uid=211 oct=2 lid=211 tim=2420536280121 err=28113
insert into RA_INTERFACE_ERRORS  ............

Compiling the Trigger AR_RECEIPT_METHOD_ACCOUN_AI 

---------------------------------------------------------------------

SQL> alter trigger APPS.AR_RECEIPT_METHOD_ACCOUN_AI compile
 2  /

Warning: Trigger altered with compilation errors.

SQL> show error
Errors for TRIGGER APPS.AR_RECEIPT_METHOD_ACCOUN_AI:

LINE/COL ERROR
-------- ---------------------------------------------------------------
3/37     PLS-00049: bad bind variable 'OLD.BANK_ACCOUNT_ID'
10/37    PLS-00049: bad bind variable 'NEW.BANK_ACCOUNT_ID'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Navigation: Receivables Responsibility > Control > Autoinvoice

Changes

 Instance is recently upgraded

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.