Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8

Customer January 18, 2025 at 12:56 pm

During the Oracle Enterprise Command Center Framework installation and integration phase in our EBS 12.2.8 environment, specifically when running `perl patchEccFiles.pl`, we encountered an `ORA-00904: invalid identifier` error related to the package `FND_ECC_UTIL_MLS_PVT`. What is the likely cause and resolution for this critical error?

Viewing 10 reply threads

Author
Replies
- Support January 19, 2025 at 6:13 am
  The `ORA-00904` error during `patchEccFiles.pl` execution, particularly referencing `FND_ECC_UTIL_MLS_PVT.CONVERTORALANGCODETOBCP47`, indicates that necessary database objects or prerequisite code (often related to multilingual support or base ECC objects) are either missing or invalid. This typically points to an issue where core ECC or required FND patches have not been fully or correctly applied, compiled, or loaded into the database.
- Customer January 20, 2025 at 12:03 am
  We successfully completed the integration step, checking system profile options like `s_ecc_protocol` and running autoconfig. Why would this package still be missing or invalid?
- Support January 22, 2025 at 1:05 am
  While basic integration steps like running autoconfig confirm profile option values and OHS configuration , the `patchEccFiles.pl` script runs post-database object application. The issue suggests a preceding database patch application failure or an environmental setup issue that prevented the necessary PL/SQL packages from compiling correctly in the APPS schema.
- Customer January 23, 2025 at 5:55 pm
  If we are troubleshooting similar HTTP 400 errors post-installation, what specific resource should we check? We are seeing ‘No function from PO_PCC_ECC_ODERS_FUNC is available to current logged in responsibility id’.
- Support January 24, 2025 at 6:39 pm
  That specific `400 Bad Request` error is commonly linked to missing security grants or functional exclusions for the ECC dashboards. You should check the corresponding MOS document, Error 400 Bad Request ‘No function from’ Is Appearing For Procurement ECC Dashboard (Doc ID 2660547.1), to ensure the responsibility ID has the necessary permissions and functions assigned.
- Customer January 26, 2025 at 3:34 pm
  We need to quickly diagnose if critical base patches (AD/TXK) are missing, which could cause compilation issues.
- Support January 27, 2025 at 2:03 pm
  The quickest diagnostic method is to use a customized Blitz Report to verify patch application status. Your DBA team can run an instantaneous check using the AD_PATCH.IS_PATCH_APPLIED function directly from EBS, bypassing SQL*Plus access latency.
- Customer January 28, 2025 at 11:08 am
  Once the ECC installation is confirmed complete, can we use Blitz Report to export the data powering ECC dashboards?
- Support January 28, 2025 at 4:56 pm
  Yes, Blitz Report allows you to develop EBS reports using the Oracle Enterprise Command Center SQLs directly, often in under five minutes. This facilitates the export of enriched dashboard data to Excel for deeper analysis or archival.
- Customer January 30, 2025 at 2:53 am
  We’ve confirmed ECC V5 installation is complete on 12.2.9. Thank you for the guidance.
- Support January 30, 2025 at 8:29 pm
  I am happy to hear that your installation and configuration were successful. Feel free to leverage the extensive features of Blitz Report for ongoing ECC administration and reporting needs.
Author
Replies

Viewing 10 reply threads

You must be logged in to reply to this post.