Issue:-
while applying patch 23201078, we have found below Oracle
Forms objects did not generate successfully in Non-Prod instance.
ar
forms/US ARXRWRCT.fmx
ar
forms/US ARXRWMAI.fmx
Cause:-
Issue was caused due to below error, which we found in
worker log. Oracle suggest to apply R12.AR.B: Patch 18370021 to fix the issue.
FRM-30064: Unable to parse statement select distinct
c.cust_account_id ,
arp_etax_util.get_taxpayer_masked_value(party.jgzz_fiscal_code)
jgzz_fiscal_code,
substrb(party.party_name,1,50)
party_name,
c.account_number,
arp_etax_util.get_taxpayer_masked_value(party.tax_reference) tax_reference ,
party.party_number,
party.party_id,
party.person_first_name,
party.person_last_name
,
c.account_name
account_description
from hz_cust_accounts c,
hz_parties party
where c.party_id = party.party_id
order by party.jgzz_fiscal_code.
ORA-01791: not a SELECTed expression
Record Group RGW_FIND_TAXPAYER_ID
Form: ARXRWRCT
FRM-30085: Unable to adjust form for output.
Solution:-
To apply a Pre-requisites Patch 18370021: R12.AR.B
Note id : Several
Patches Cause Forms ARXRWRCT.fmb and ARXRWMAI.fmb to Fail Generating with
Following Error: "ORA-01791: not a SELECTed expression" (Doc ID
1931760.1)
No comments:
Post a Comment