Skip to main content
Question

-942 in Grant_Privileged_Users__ when publishing CF in OutgoingInvoice

  • August 8, 2025
  • 3 replies
  • 50 views

Forum|alt.badge.img+8

Hello

I meet an issue when trying to publish new custom field in LU OutgoingInvoice next to the other published already. But, unfortunately i got an error PLS-0020: identifier … must be declared.

 

I assumed something got wrong with the whole LU Custom Fields, then i unpublish the only existing.

Unfortunately, when trying to publish the newly created i’m getting above error, but when trying to publish the one which was published, i’m getting: 

 

 

There is no issue to deploy/publish custom fields in other LUs.

I assume -942 is an ORA 00942 table or view doesn’t exist error, then when look into body of the CUSTOM_OBJ_SYS.Grant_Privileged_Users__ procedure the only suspicious thing is reading from system view dba_users.

What could be a reason behind these issues?

 

Best regards,

Wiktor

 

 

 

 

 

3 replies

MWitczak
Hero (Customer)
Forum|alt.badge.img+10
  • Hero (Customer)
  • August 8, 2025

What kind of custom field is this?  Persistent?  Read only?  If read only, is it an expression or select statement?


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • August 9, 2025

Hi

Persistent field.

Since this is the only LU I have a problem with custom fields, my guess is that it relates somehow to IFS modification done, since originally the LU did not have base table defined.


Sandun Madola
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • September 8, 2025

Hi ​@Wiktor ,

The latest IFS Apps 10 code does not allow the creation of persistent fields for the OutgoingInvoice Logical Unit (LU). 

This LU is already included in the list of Excluded Logical Units and is not intended to be extended for configuration purposes in the latest Apps 10 Updates.