Home » Applications » Oracle Fusion Apps & E-Business Suite » Compile Standard From (R12.1.2)
Compile Standard From [message #527385] Tue, 18 October 2011 00:22 Go to next message
alaa_fouad2004
Messages: 64
Registered: January 2009
Member
Dear All

please I have do on the clone server add a new nondatabase item on this form 'INVTTMTX' which called miscellaneous transactions. and try to compile this form by this command
frmcmp_batch module=/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/INVTTMTX.fmb userid=APPS/apps output_file=/oracle/PROD/apps/apps_st/appl/inv/12.0.0/forms/US/INVTTMTX.fmx module_type=form compile_all=special

it give me error in compilation it was

Quote:

Compiling package body TRX...
Compilation error on package body TRX:
PL/SQL ERROR 49 at line 115, column 30
bad bind variable 'parameter.chart_of_accounts_id'
PL/SQL ERROR 49 at line 115, column 30
bad bind variable 'parameter.chart_of_accounts_id'
PL/SQL ERROR 49 at line 148, column 30
bad bind variable 'parameter.chart_of_accounts_id'
PL/SQL ERROR 49 at line 167, column 30
bad bind variable 'parameter.org_id'
PL/SQL ERROR 49 at line 167, column 30
bad bind variable 'parameter.org_id'
PL/SQL ERROR 49 at line 318, column 32
bad bind variable 'PARAMETER.ORG_ID'
PL/SQL ERROR 49 at line 318, column 32
bad bind variable 'PARAMETER.ORG_ID'

Compiling package specification TRX...
No compilation errors.

Compiling package specification HEADER...
No compilation errors.

Compiling package body HEADER...
Compilation error on package body HEADER:
PL/SQL ERROR 49 at line 118, column 45
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 118, column 45
bad bind variable 'parameter.org_code'

Compiling package specification DETAIL_LAYOUT...
No compilation errors.

Compiling package body DETAIL_LAYOUT...
Compilation error on package body DETAIL_LAYOUT:
PL/SQL ERROR 49 at line 188, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 188, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 282, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 382, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 488, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 625, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 706, column 26
bad bind variable 'parameter.org_code'

Compiling package specification LOT_ENTRY_CUSTOM...
No compilation errors.

Compiling package body LOT_ENTRY_CUSTOM...
No compilation errors.

Compiling package specification SERIAL_ENTRY_CUSTOM...
No compilation errors.

Compiling package body SERIAL_ENTRY_CUSTOM...
No compilation errors.

Compiling package specification INTERORG_FH...
No compilation errors.

Compiling package body INTERORG_FH...
Compilation error on package body INTERORG_FH:
PL/SQL ERROR 49 at line 77, column 23
bad bind variable 'PARAMETER.CHART_OF_ACCOUNTS_ID'
PL/SQL ERROR 49 at line 77, column 23
bad bind variable 'PARAMETER.CHART_OF_ACCOUNTS_ID'

Compiling package specification RMA_RECEIPT_FH...
No compilation errors.

Compiling package body RMA_RECEIPT_FH...
Compilation error on package body RMA_RECEIPT_FH:
PL/SQL ERROR 49 at line 54, column 31
bad bind variable 'parameter.org_id'
PL/SQL ERROR 49 at line 54, column 31
bad bind variable 'parameter.org_id'

Compiling package specification RMA_LAYOUT...
No compilation errors.

Compiling package body RMA_LAYOUT...
Compilation error on package body RMA_LAYOUT:
PL/SQL ERROR 49 at line 91, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 91, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 180, column 26
bad bind variable 'parameter.org_code'

Compiling package specification RMA_RETURN_FH...
No compilation errors.

Compiling package body RMA_RETURN_FH...
No compilation errors.

Compiling package specification FORM_UPDATE...
No compilation errors.

Compiling package body FORM_UPDATE...
No compilation errors.

Compiling package specification INTERORG_LAYOUT...
No compilation errors.

Compiling package body INTERORG_LAYOUT...
Compilation error on package body INTERORG_LAYOUT:
PL/SQL ERROR 49 at line 107, column 26
bad bind variable 'parameter.org_code'
PL/SQL ERROR 49 at line 107, column 26
bad bind variable 'parameter.org_code'

Compilation errors have occurred.


Form not created


when i back to the old form it give me the same error in compilation

when i try to see why this compilation error occur I found that these parameters ('parameter.org_code','parameter.org_id','parameter.CHART_OF_ACCOUNTS_ID') are already exists but inherited from another modules like ('INVTTELT','INVSTAND','INVTTESR')
so I don't know why the compilation give error

Regards
Alaa Fouad
Re: Compile Standard From [message #527455 is a reply to message #527385] Tue, 18 October 2011 03:28 Go to previous messageGo to next message
eric62
Messages: 24
Registered: January 2009
Junior Member
hello.

In $FORMS60_PATH, you have $AU_TOP/resource (for pll) and $AU_TOP/forms/US (for fmb) ?

Regards
Re: Compile Standard From [message #528142 is a reply to message #527455] Sat, 22 October 2011 02:30 Go to previous message
alaa_fouad2004
Messages: 64
Registered: January 2009
Member
Please
can can you explain how to do this because i'm developer not DBA so i didn't understand your answer.Note that our server is lunix. and also i haven't any experiance in lunix.

Alaa fouad
Previous Topic: wsh_delivery_details_pub.update_shipping attributes
Next Topic: Is there any API or Interface to update steps activities resource on Production batch
Goto Forum:
  


Current Time: Wed Dec 11 17:01:14 CST 2024