Thursday, 23 November 2017

Oracle Forms objects did not generate successfully : ar forms/US ARXRWRCT.fmx and ARXRWMAI.fmx



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