PL/SQL (MOSC)

MOSC Banner

Getting APPS.HR_Security error for a Particular table/view in 11i

edited Mar 9, 2022 11:05AM in PL/SQL (MOSC) 1 commentAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center