Unable to Compile Form JAINBOEI.fmb (Doc ID 2294779.1)

Last updated on DECEMBER 27, 2021

Applies to:

Symptoms

Unable to Compile Form JAINBOEI.fmb

adadmin log shows:

Compiling package body JA_IN_BOE_HDR_PRIVATE...
Compilation error on package body JA_IN_BOE_HDR_PRIVATE:
PL/SQL ERROR 390 at line 32, column 6
undefined column 'BOL_NUMBER' in INSERT statement
PL/SQL ERROR 0 at line 27, column 3
SQL Statement ignored
PL/SQL ERROR 417 at line 259, column 7
unable to resolve "STATUS" as a column
PL/SQL ERROR 0 at line 256, column 3
SQL Statement ignored

Compiling package body JA_IN_BOE_DTL_PRIVATE...
Compilation error on package body JA_IN_BOE_DTL_PRIVATE:
PL/SQL ERROR 414 at line 780, column 23
no column 'STATUS' in table
PL/SQL ERROR 0 at line 768, column 7
SQL Statement ignored
PL/SQL ERROR 414 at line 804, column 22
no column 'STATUS' in table
PL/SQL ERROR 0 at line 791, column 8
SQL Statement ignored
PL/SQL ERROR 414 at line 828, column 20
no column 'STATUS' in table
PL/SQL ERROR 0 at line 817, column 7
SQL Statement ignored

Compiling package body JA_IN_ITEM_ASSIGN...
Compilation error on package body JA_IN_ITEM_ASSIGN:
PL/SQL ERROR 201 at line 8, column 12
identifier 'CURRENCY_CODE' must be declared
PL/SQL ERROR 0 at line 8, column 5
SQL Statement ignored
PL/SQL ERROR 414 at line 103, column 43
no column 'STATUS' in table
PL/SQL ERROR 0 at line 81, column 23
SQL Statement ignored
PL/SQL ERROR 364 at line 116, column 38
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 116, column 8
Statement ignored
PL/SQL ERROR 364 at line 117, column 42
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 364 at line 118, column 48
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 118, column 8
Statement ignored
PL/SQL ERROR 364 at line 119, column 40
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 119, column 8
Statement ignored
PL/SQL ERROR 364 at line 120, column 42
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 364 at line 121, column 34
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 121, column 8
Statement ignored
PL/SQL ERROR 364 at line 122, column 44
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 122, column 8
Statement ignored
PL/SQL ERROR 364 at line 123, column 48
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 123, column 8
Statement ignored
PL/SQL ERROR 364 at line 124, column 41
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 124, column 8
Statement ignored
PL/SQL ERROR 414 at line 167, column 46
no column 'STATUS' in table
PL/SQL ERROR 0 at line 143, column 27
SQL Statement ignored
PL/SQL ERROR 364 at line 182, column 41
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 182, column 11
Statement ignored
PL/SQL ERROR 364 at line 183, column 45
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 183, column 11
Statement ignored
PL/SQL ERROR 364 at line 184, column 51
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 184, column 11
Statement ignored
PL/SQL ERROR 364 at line 185, column 43
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 185, column 11
Statement ignored
PL/SQL ERROR 364 at line 186, column 45
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 186, column 11
Statement ignored
PL/SQL ERROR 364 at line 187, column 37
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 187, column 11
Statement ignored
PL/SQL ERROR 364 at line 188, column 47
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 188, column 11
Statement ignored
PL/SQL ERROR 364 at line 189, column 51
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 189, column 11
Statement ignored
PL/SQL ERROR 364 at line 190, column 44
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 190, column 11
Statement ignored
PL/SQL ERROR 414 at line 229, column 45
no column 'STATUS' in table
PL/SQL ERROR 0 at line 209, column 26
SQL Statement ignored
PL/SQL ERROR 364 at line 238, column 41
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 238, column 11
Statement ignored
PL/SQL ERROR 364 at line 239, column 45
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 239, column 11
Statement ignored
PL/SQL ERROR 364 at line 240, column 51
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 240, column 11
Statement ignored
PL/SQL ERROR 364 at line 241, column 43
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 241, column 11
Statement ignored
PL/SQL ERROR 364 at line 242, column 45
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 242, column 11
Statement ignored
PL/SQL ERROR 364 at line 243, column 37
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 243, column 11
Statement ignored
PL/SQL ERROR 364 at line 244, column 47
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 244, column 11
Statement ignored
PL/SQL ERROR 364 at line 245, column 51
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 245, column 11
Statement ignored
PL/SQL ERROR 364 at line 246, column 44
loop index variable 'REC_LINE' use is invalid
PL/SQL ERROR 0 at line 246, column 11
Statement ignored
PL/SQL ERROR 201 at line 321, column 11
identifier 'CURRENCY_CODE' must be declared
PL/SQL ERROR 0 at line 321, column 4
SQL Statement ignored

Compiling package body HDR_CONTROL...
No compilation errors.

Compiling package body BOE_WRITEOFF...
Compilation error on package body BOE_WRITEOFF:
PL/SQL ERROR 417 at line 425, column 33
unable to resolve "STATUS" as a column
PL/SQL ERROR 0 at line 425, column 5
SQL Statement ignored

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.