11.5.10 to R12.1.1 : xleupg01.sql failed
Hello,
We did a test upgrade last week. During R12.1.1 upgrade xleupg01.sql failed . We skipped and continued with upgrade . After that we finished R12.1.1 to R12.1.3 upgrade
sqlplus -s APPS/***** @/u01/app/oracle/apps/apps_st/appl/xle/12.0.0/patch/115/sq
l/xleupg01.sql
DECLARE
*
ERROR at line 1:
ORA-20025: Enables GRE/LE location as Legal location : ORA-20006: Enables
GRE/LE location as Legal location101 le id 101 : ORA-20001: Invalid
Receiving_site_flag value. Must be set to 'Y' if Ship_to_site_flag is set to
'Y'.
ORA-06512: at line 3645
I found similar note : Receipts Workbench: Querying an Upgraded Receipt Raises Error: FRM-40735: POST-QUERY Trigger Raised Unhandled Exception ORA-01403 [ID 1540022.1]
We did a test upgrade last week. During R12.1.1 upgrade xleupg01.sql failed . We skipped and continued with upgrade . After that we finished R12.1.1 to R12.1.3 upgrade
sqlplus -s APPS/***** @/u01/app/oracle/apps/apps_st/appl/xle/12.0.0/patch/115/sq
l/xleupg01.sql
DECLARE
*
ERROR at line 1:
ORA-20025: Enables GRE/LE location as Legal location : ORA-20006: Enables
GRE/LE location as Legal location101 le id 101 : ORA-20001: Invalid
Receiving_site_flag value. Must be set to 'Y' if Ship_to_site_flag is set to
'Y'.
ORA-06512: at line 3645
I found similar note : Receipts Workbench: Querying an Upgraded Receipt Raises Error: FRM-40735: POST-QUERY Trigger Raised Unhandled Exception ORA-01403 [ID 1540022.1]
Tagged:
0