12.1.3 : Post DB upgrade to 11.2.0.3.0 : Invalid Objects
Hi Kent :This thread will address your following issue -
After migrating to a new 64-bit 11.2.0.3.0 database server (from a 32-bit 11.2.0.3.0 database server) for our R12.1.3 Oracle E-Business Suite application, the following objects are invalid:
APPS.IGW_BUDGET_CATEGORY_V
APPS.IGW_REPORT_PROCESSING
APPS.XNB_QUEUE_HANDLERS_PKG (spec and body)
For APPS.IGW_BUDGET_CATEGORY_V, I receive the following error when trying to compile it manually:
ORA-00979: not a GROUP BY expression (on pbcv.oh_cost)
The error for APPS.IGW_REPORT_PROCESSING is due to the above APPS.IGW_BUDGET_CATEGORY_V being invalid.
For the APPS.XNB_QUEUE_HANDLERS_PKG, I receive the following error when trying to compile the package specification manually:
APPS.IGW_BUDGET_CATEGORY_V
APPS.IGW_REPORT_PROCESSING
APPS.XNB_QUEUE_HANDLERS_PKG (spec and body)
For APPS.IGW_BUDGET_CATEGORY_V, I receive the following error when trying to compile it manually:
ORA-00979: not a GROUP BY expression (on pbcv.oh_cost)
The error for APPS.IGW_REPORT_PROCESSING is due to the above APPS.IGW_BUDGET_CATEGORY_V being invalid.
For the APPS.XNB_QUEUE_HANDLERS_PKG, I receive the following error when trying to compile the package specification manually:
Tagged:
0