My Oracle Support Banner

R12: AP: The Payables Payment Workbench Form (APXPAWKB.fmx) Object Fails With Compilation Error Messages FRM-30064 ORA-00932 and FRM-30085 When PO Patch 31202857:R12.PO.D Is Applied (Doc ID 2999005.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Payables - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply Patch 31202857:R12.PO.D, the following error occurs in the adpatch:

The following Oracle Forms objects did not generate successfully:

ap forms/US APXPAWKB.fmx



The issue can be reproduced at will with the following steps:

  1. Apply Patch 31202857:R12.PO.D
  2. Review the AD Worker Log


The AD Worker Log shows:

FRM-30064: Unable to parse statement SELECT bank_account_name,
bank_account_id,
bank_account_number,
currency_code,
iban_number,
bank_name,
bank_number,
bank_branch_name,
branch_number,
country_code,
alternate_account_name,
bank_account_type,
account_suffix,
description,
foreign_payment_use_flag,
payment_factor_flag,
eft_swift_code
FROM (
SELECT b.bank_account_name,
b.ext_bank_account_id bank_account_id,
b.bank_account_number,
b.currency_code,
b.iban_number,
b.bank_name,
b.bank_number,
b.bank_branch_name,
b.branch_number,
b.country_code,
b.alternate_account_name,
b.bank_account_type,
b.account_suffix,
b.description,
b.foreign_payment_use_flag,
b.payment_factor_flag,
b.eft_swift_code,
rank() over(partition by ibyu.instrument_id, ibyu.instrument_type
order by ibyu.instrument_payment_use_id) not_dup
FROM IBY_PMT_INSTR_USES_ALL ibyu,
IBY_EXT_BANK_ACCOUNTS_V b,
IBY_EXTERNAL_PAYEES_ALL ibypayee
WHERE ibyu.instrument_id = b.ext_bank_account_id
AND ibyu.instrument_type = 'BANKACCOUNT'
AND (b.currency_code = :PARAMETER.P_PBA_PMT_CURRENCY OR b.currency_code is null)
AND ibyu.ext_pmt_party_id = ibypayee.ext_payee_id
AND ibyu.payment_flow = 'DISBURSEMENTS'
AND ibypayee.payment_function = :PARAMETER.P_PBA_PMT_FUNCTION
AND ibypayee.payee_party_id = :PARAMETER.P_PBA_PAYEE_PARTY_ID
/* Bug 22309491 */
AND trunc(nvl(:parameter.p_check_date,sysdate)) between trunc(NVL(ibyu.start_date,nvl(:parameter.p_check_date,sysdate)-1)) AND trunc(NVL(ibyu.end_date-1,sysdate+1))
AND trunc(nvl(:parameter.p_check_date,sysdate)) between trunc(NVL(b.start_date,nvl(:parameter.p_check_date,sysdate)-1)) AND trunc(NVL(b.end_date-1,sysdate+1))
AND (ibypayee.party_site_id is null OR ibypayee.party_site_id = :PARAMETER.P_PBA_PAYEE_PARTY_SITE_ID)
AND (ibypayee.supplier_site_id is null OR ibypayee.supplier_site_id = :PARAMETER.P_PBA_SUPPLIER_SITE_ID)
AND (ibypayee.org_id is null OR
(ibypayee.org_id = :PARAMETER.P_PBA_ORG_ID AND ibypayee.org_type = :PARAMETER.P_PBA_ORG_TYPE)))
WHERE not_dup=1
/*UNION
SELECT bank_account_name,
bank_account_id,
bank_account_number,
currency_code,
iban_number,
bank_name,
bank_number,
bank_branch_name,
branch_number,
country_code,
alternate_account_name,
bank_account_type,
account_suffix,
description,
foreign_payment_use_flag,
payment_factor_flag,
eft_swift_code
FROM (
SELECT b.bank_account_name,
b.ext_bank_account_id bank_account_id,
b.bank_account_number,
b.currency_code,
b.iban_number,
b.bank_name,
b.bank_number,
b.bank_branch_name,
b.branch_number,
b.country_code,
b.alternate_account_name,
b.bank_account_type,
b.account_suffix,
b.description,
b.foreign_payment_use_flag,
b.payment_factor_flag,
b.eft_swift_code,
rank() over(partition by ibyu.instrument_id, ibyu.instrument_type
order by ibyu.instrument_payment_use_id) not_dup
FROM IBY_PMT_INSTR_USES_ALL ibyu,
IBY_EXT_BANK_ACCOUNTS_V b,
IBY_EXTERNAL_PAYERS_ALL ibypayer
WHERE ibyu.instrument_id = b.ext_bank_account_id
AND ibyu.instrument_type = 'BANKACCOUNT'
AND (b.currency_code = :PARAMETER.P_PBA_PMT_CURRENCY OR b.currency_code is null)
AND ibyu.ext_pmt_party_id = ibypayer.ext_payer_id
AND ibyu.payment_flow = 'FUNDS_CAPTURE'
AND ibypayer.payment_function = 'CUSTOMER_PAYMENT'
AND :PARAMETER.P_PBA_PMT_FUNCTION <> 'PAYABLES_DISB' -- Bug 14118654
AND ibypayer.party_id = :PARAMETER.P_PBA_PAYEE_PARTY_ID
AND trunc(sysdate) between trunc(NVL(ibyu.start_date,sysdate-1)) AND trunc(NVL(ibyu.end_date-1,sysdate+1))
AND trunc(sysdate) between trunc(NVL(b.start_date,sysdate-1)) AND trunc(NVL(b.end_date-1,sysdate+1))
AND (ibypayer.org_id is null OR
(ibypayer.org_id = :PARAMETER.P_PBA_ORG_ID AND ibypayer.org_type = :PARAMETER.P_PBA_ORG_TYPE)))
WHERE not_dup=1*/

.
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
Record Group RG_PAYEE_BANKACCOUNT
Form: APXPAWKB
FRM-30085: Unable to adjust form for output.

 

The form "APXINWKB.fmb" is compiled successfully through adadmin utility.

But after retrying to apply the PO patch 31202857:R12.PO.D was completed again with the same errors.

Changes

Applying Patch 31202857:R12.PO.D.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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