Thank you for your response. I've tried above documents but the issue is not yet resolved.
I executed the scripts mentioned in doc id 459005.1 and found there were many .plx files which version were lesser than .pll. I complied them manually using frmcmp.sh and frmcmp_batch.sh but when I execute the scripts again I get following files even I recompiled the them:
[oracle@visionerp tmp]$ sdiff -s pll.txt plx.txt
$Header CSFDCLIB.pld 120.2.12010000.3 |
$Header FNDMOAC.pld 120.21 |
$Header GMDQSRCH.pld 120.1 |
$Header GMDSRCH.pld 120.10 |
$Header IEXHIPAD.pld 120.10.120 | $Header IEXHIPAD.pld 120.10.12010000.2
$Header JAINTAX1.pld 120.18.12010000.6 |
$Header JAINTAX.pld 120.9.12010000.8 |
$Header JAINVMTX.pld 120.2.12010000.3 |
$Header JTFTREE.pld 120.0 |
$Header QOTHDCFG.pld 120.9 | $Header QOTHDCFG.pld 12
This if Receivables -> transaction -> lines form.
After giving quantity and unit price at line items when I save it, Transaction - Lines becomes zero and doesn't show any value at Total and raises the subject error.
There is no error in forms log directory file:
listener = 1
config = default
pid = 14489
connect = Thu Sep 26 16:39:03 2013 PKST
ip = 192.168.0.100
user = APPLSYSPUB
db_string = CLONE
When you open the form, click on (Help > About Oracle Application) and post the details of Form Name and Version please.
Ok here is the detail of the form:
Form Application : Receivables
Form Name : ARXTWMAI
Form Version : 184.108.40.20610000.19
Form Last Modified : $Date: 2010/04/15 23:04 $
Please also obtain FRD log file for details about the error.
I've uploaded the FRD log file here.
Please review notes:
Transaction Workbench Error: FRM-40735 ON-UPDATE Trigger Raised Unhandled Exception (Doc ID 781264.1)
Tax Group Code Errors with ORA-06502 When Creating Invoice or Order (Doc ID 190410.1)
Transactions Workbench Error: In a Latin America Instance, Saving a Transaction Raises Error - FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-01502 (Doc ID 1575194.1)
Transaction Workbench Error: FRM-40735 ON-INSERT Trigger Raised Unhandled Exception (Doc ID 365553.1)
Troubleshooting Assistant: Receivables Transactions WORKBENCH (Search Helper) (Doc ID 1458368.2)