compile invalid objets

[Roshan]

Hello,

when opening a Purchase Order form, we are getting the frm form shown below.
IMG_27062016_110059.png

I did Help -> Diagnostics -> Chooese Custom Code only. Still same issue after retest.

There are 48 invalid objects, mostly PO. I compiled with adadmin, restarted database invalid objects are still there.

invalidobjects.xlsx

[ErmanArslansOracleBlog]

You don't have custom triggers or personalization on that form , right?
Check those if you have any...

Also, Recompile all PO's forms(fmb files) and libraries(pll files) and having proceeded to bounce the application's form server.

Compile those invalids also. But before the compilation, check why they get errors..
 Try manual compile for couple of those and see the error. Then try to create an action plan accordingly.

Also, check what is their last DDL time. Think about what did you change before that.
If it was a patch that caused them to be invalid. Investigate the patching actions and logs. Ensure you did everything in patch readme. Also check oracle support for that patch specific known issues and problems.

[ErmanArslansOracleBlog]

I checked it again.
This is caused by invalid db objects .
We need to see the real ORA error during the compilations of these invalid objects.

So, the things that I wrote in my previous update still applies.

Compile those invalids also. But before the compilation, check why they get errors..
 Try manual compile for couple of those and see the error. Then try to create an action plan accordingly.

Also, check what is their last DDL time. Think about what did you change before that.
If it was a patch that caused them to be invalid. Investigate the patching actions and logs. Ensure you did everything in patch readme. Also check oracle support for that patch specific known issues and problems.
See the error during your manual compiles and try to understand the real factor lying behind.

[Roshan]

Thanks. Is it o.k if I transfer the PO form from a working instance, for example to the instance where there is form error?

[ErmanArslansOracleBlog]

your objects are invalid and the error you are encountring are directly related with them.


ORA-04045: errors during recompilation/revalidation of string.string
Cause: This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation/revalidation of the object.

so , even if you copy the form from any other instance, it will give the same error.

If you copy an earlier version of the form , then  your envionment will be become incosistent.
I suggest you to solve the compilation errors.

[Roshan]

I compiled the PO forms. I am getting the following error:

The following Oracle Forms objects did not generate successfully:

au      resource        POXAPAPC.pll
au      resource        POXDOCON.pll
au      resource        POXPOREL.pll
au      resource        POXPOEPO.pll
po      forms/US        POXDOFDO.fmx
po      forms/US        POXPOERL.fmx



An error occurred while generating Oracle Forms objects.

I have already contacted Support about the patch issue.

Regards,
SRL Support.