Getting APPS.HR_Security error for a Particular table/view in 11i
Hi Gurus,
We are trying to invoke a package from fusion web service. The package is in APPS schema.
I am getting below error while using org_organization_definitions table/view in my package. If I remove this table or create a custom table using above table there is no issue.
I can't remove this table from my package as there is a number of validations happening.
" Abnormal Error at Get Organization Code Campbellsville (CBV). Error: ORA-01722: invalid number
ORA-06512: at "APPS.HR_SECURITY", line 361
ORA-06512: at "APPS.HR_SECURITY", line 654"
Thank you.
Regards,
Homesh