Error ORA-01792 after migration

[davidk46719882]

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

[Vipul_Raghav · Accepted solution]

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 .