Patch: 12803250:R12.AP.B : Oracle Forms objects did not generate successfully: ont forms/US OEXOEOR
Hi,
While applying the patch 12803250:R12.AP.B . While generating the oracle form files, the patch is failing with the below error
The following Oracle Forms objects did not generate successfully:
ont forms/US OEXOEORD.fmx
The worker log contains the below error
FRM-30064: Unable to parse statement SELECT DISTINCT OH.ORDER_NUMBER
, OH.HEADER_ID
,OT.NAME
,OH.ORDERED_DATE
,OH.SOLD_TO_ORG_ID
,HZ_P.PARTY_NAME
FROM OE_ORDER_HEADERS OH
,OE_TRANSACTION_TYPES_TL OT
,OE_ORDER_LINES_ALL L
,HZ_CUST_ACCOUNTS HZ
,HZ_PARTIES HZ_P
WHERE OT.TRANSACTION_TYPE_ID=:LINE.SVC_REF_ORDER_TYPE_ID