Error ORA-01792 after migration

Avatar

Avatar

davidk46719882

Avatar

davidk46719882

davidk46719882

24-05-2017

Hi all,

I'm doing a migration from v6.1.0 build 8161 to v6.1.1 build 8770 and after completing the migration, I have an error when i'm trying to open deliveries or to see deliveries dashboard.

Can you help on that?

Thanks

David

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

24-05-2017

Dis you also move to Oracle 12c?

It is a bug for Oracle, please see 

https://community.oracle.com/message/12970776#12970776


As suggested by Oracle experts, it can be resolved by


Turning  OFF the FIX_CONTROL will resolve the issue


The workaround is to set "_fix_control"='17376322:OFF'
SQL> alter session set "_fix_control"='17376322:OFF';
or at system level :
SQL> alter system set "_fix_control"='17376322:OFF';


OR


Apply Patch 19509982 if available for your DB Version and Platform 
https://support.oracle.com/rs?type=patch&id=19509982


Can you please contact your DBA for making these changes and see if the problem is resolved .

Answers (0)