Patch Application Error: Applying Patch 8722501 Fails to Compile Forms ARXRWBOE.fmb and ARXRWMAI.fmb

(Doc ID 1304290.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Applying <patch 8722501> fails compiling ARXRWBOE.fmb and ARXRWMAI.fmb with the following error:

Error for ARXRWBOE.fmb
===================
FRM-30064: Unable to parse statement select
distinct
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',INS.ACCOUNT_NUMBER,
'CREDITCARD', INS.CARD_NUMBER) INSTR_NUMBER,
ins.instrument_id INSTR_ASSIGNMENT_ID,
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',ins.bank_name,
'CREDITCARD', ins.card_issuer_name) INSTR_NAME,
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',ins.currency_code,Null) ACCOUNT_Currency,
DECODE(INS.INSTRUMENT_TYPE,'CREDITCARD',ins.masked_card_expirydate,Null) Expiration_date
from
iby_fndcpt_payer_assgn_instr_v ins
where
instrument_type = decode(:BOE_REMIT_RECEIPTS,'CREDIT_CARD','CREDITCARD',
'BANK_ACCT_XFER','BANKACCOUNT')
and party_id = arp_trx_defaults_3.get_party_Id(1006)
and ( account_number is not null or card_number is not null)
.
ORA-00904: "INS"."MASKED_CARD_EXPIRYDATE": invalid identifier
Record Group BOE_REMIT_INSTR_NUMBER
Form: ARXRWBOE
FRM-30085: Unable to adjust form for output.


Error for ARXWMAI.fmb
==================
FRM-30436: Parent window not specified for canvas.View Canvas MAIN
FRM-30064: Unable to parse statement select
distinct
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',INS.ACCOUNT_NUMBER,
'CREDITCARD', INS.CARD_NUMBER) INSTR_NUMBER,
ins.instrument_id INSTR_ASSIGNMENT_ID,
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',ins.bank_name,
'CREDITCARD', ins.card_issuer_name) INSTR_NAME,
DECODE(INS.INSTRUMENT_TYPE,'BANKACCOUNT',ins.currency_code,Null) ACCOUNT_Currency,
DECODE(INS.INSTRUMENT_TYPE,'CREDITCARD',ins.masked_card_expirydate,Null) Expiration_date
from
iby_fndcpt_payer_assgn_instr_v ins
where
instrument_type = decode(:BOE_REMIT_RECEIPTS,'CREDIT_CARD','CREDITCARD',
'BANK_ACCT_XFER','BANKACCOUNT')
and party_id = arp_trx_defaults_3.get_party_Id(1006)
and ( account_number is not null or card_number is not null)
.
ORA-00904: "INS"."MASKED_CARD_EXPIRYDATE": invalid identifier
Record Group BOE_REMIT_INSTR_NUMBER
Form: ARXRWMAI
FRM-30085: Unable to adjust form for output.


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