samedi 18 juin 2016

Invalid Objects and What issue they can cause in application?

I just wanted to know about some invalid objects which are from Oracle ebs 12.1.3. The list is

  1. CST_LAYER_ACTUAL_COST_DTLS_V
  2. IGW_BUDGET_CATEGORY_V
  3. IGW_REPORT_PROCESSING
  4. FV_FACTS_TBAL_TRX
  5. FV_FACTS_TRX_REGISTER
  6. FV_SF133_ONEYEAR
  7. FV_SF133_NOYEAR
  8. FV_FACTS_TRANSACTIONS
  9. FV_FACTS_TBAL_TRANSACTIONS
  10. ENI_DBI_CO_OBJIDS_MV
  11. PJI_TIME_PA_RPT_STR_MV
  12. POA_MID_BS_J_MV
  13. POA_IDL_BS_J_MV
  14. POA_ITEMS_MV
  15. GL_ACCESS_SET_LEDGERS
  16. LNS_LOAN_DTLS_ALL_MV
  17. OZF_CUST_FUND_SUMMARY_MV
  18. FV_SLA_FV_PROCESSING_PKG
  19. OE_ITEMS_MV
  20. PA_DEDUCTIONS_W
  21. PA_DEDUCTIONS_PUB
  22. PA_DEDUCTIONS_PUB
  23. PA_DEDUCTIONS_W
  24. PA_DCTN_APRV_NOTIFICATION

--object types--

CST_LAYER_ACTUAL_COST_DTLS_V    VIEW 
IGW_BUDGET_CATEGORY_V   VIEW 
IGW_REPORT_PROCESSING   
PACKAGE BODY FV_FACTS_TBAL_TRX  PACKAGE BODY 
FV_FACTS_TRX_REGISTER   PACKAGE BODY 
FV_SF133_ONEYEAR    PACKAGE BODY 
FV_SF133_NOYEAR PACKAGE BODY 
FV_FACTS_TRANSACTIONS   
PACKAGE BODY FV_FACTS_TBAL_TRANSACTIONS PACKAGE BODY 
ENI_DBI_CO_OBJIDS_MV    MATERIALIZED VIEW 
PJI_TIME_PA_RPT_STR_MV  MATERIALIZED VIEW 
POA_MID_BS_J_MV MATERIALIZED VIEW
POA_IDL_BS_J_MV MATERIALIZED VIEW 
POA_ITEMS_MV    MATERIALIZED VIEW 
GL_ACCESS_SET_LEDGERS   MATERIALIZED VIEW 
LNS_LOAN_DTLS_ALL_MV    MATERIALIZED VIEW 
OZF_CUST_FUND_SUMMARY_MV    MATERIALIZED VIEW 
FV_SLA_FV_PROCESSING_PKG    PACKAGE BODY 
NIB_MV_TB   MATERIALIZED VIEW 
OE_ITEMS_MV MATERIALIZED VIEW 
PA_DEDUCTIONS_W PACKAGE 
PA_DEDUCTIONS_PUB   PACKAGE 
PA_DEDUCTIONS_PUB   PACKAGE BODY 
PA_DEDUCTIONS_W PACKAGE BODY 
PA_DCTN_APRV_NOTIFICATION   PACKAGE BODY

So I wanted to know that If I keep them invalid what problem they can cause?

Steps I took to know myself:-

I have searched over Oracle support and google by object name but the only thing i get there is patch no to resolve the issue or in some case that ignore these objects they will do nothing.

If anyone have information about these object and what problem they can cause in application. Please do share.

Thanks in Advance!!!

Aucun commentaire:

Enregistrer un commentaire