Custom Projection Deployment Error

Hi ​@SENPA,

ORA-04050: invalid or missing procedure, function, or package name

The error ORA-04050 during projection deployment usually indicates that a referenced PL/SQL object (package, function, or procedure) is either missing, invalid, or not accessible in the target environment.

We recommend checking the following:

1. Ensure all dependent packages used by the projection are successfully deployed and in VALID state
2. Verify that the projection does not reference any incorrect or non-existing API methods
3. Confirm that the ACP includes all required database objects and that the deployment order is correct
4. Compare with a working environment (if available) to identify any missing dependencies

Reviewing the ACP logs should help identify the exact object causing the issue.

Hi ​@ashen_malaka_ranasinghe,

Thank you for the suggestions.

I've already reviewed the ACP and deployment logs and haven't found any missing, invalid, or inaccessible PL/SQL objects. All dependent packages appear to be deployed successfully and are in a VALID state. At this point, the cause of the ORA-04050 error is still unclear. Please let me know if there are any additional troubleshooting steps or logs I can review to help identify the root cause of the error.