Compile Standard From [message #527385] |
Tue, 18 October 2011 00:22 |
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 #528142 is a reply to message #527455] |
Sat, 22 October 2011 02:30 |
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
|
|
|