Demantra Solutions - EBS (MOSC)

MOSC Banner

Procedure PARTITION_POP_TEMP_LOAD going invalid after sales_data partition

After the table partition on sales_data we are seeing that there is a procedure PARTITION_POP_TEMP_LOAD which became invalid. We could not recompile it as it keeps failing with errors. I see this procedure refers to table PT_SALES_DATA in the system but it does not exist and end up with error when we recompile it. Is there any significance to this procedure?

PFB output:-

OWNER OBJECT_NAME OBJECT_TYPE

-------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------

DEMANTRA12251 PARTITION_POP_TEMP_LOAD PROCEDURE

SQL> alter procedure DEMANTRA12251.PARTITION_POP_TEMP_LOAD compile;

Warning: Procedure altered with compilation errors.

SQL> show errors;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center