Skip to main content
Solved

Resource Structure Error

  • June 9, 2022
  • 5 replies
  • 228 views

Forum|alt.badge.img+4

Hi,

Good Day.

When creating a company using STD template on App10, the below error is coming.

“ORA-20110: Resource.COMPSTRUCTEXIST: The default Resource Structure TESTXIT for the company cannot be created because there already exists a Resource Structure having the same Resource ID.”

(SS)

 

This is the company Resource Structure.

 

 

Tried to connect a resource and update the company, but error was still available.

Kindly Assis on the above.

 

Thank you.

Best Regards!

Best answer by Nethmini Kosvinna

Hi @ChathuraM 

This happens only when you have a resource structure with the same name as the company name you are creating. In your scenario, Structure ID TESTXT has been there even before you start creating the company.

 I could recreate the same error by creating the resource structure before creating the company.

Here I have created the resource structure with the same name as the company name that I am expecting to create:

Then Created the company using the same structure name and the same error was noted.

 

Therefore, please make sure you do not have an already created resource structure using the same name as the company name before creating a company. You can open ‘Resource Structures’ window and query from the structure Id in order to find records with the same structure ID.

 

Hope this will clarify your issue .

 

Thanks & Best Regards,

Nethmini

5 replies

Nethmini Kosvinna
Superhero (Partner)
Forum|alt.badge.img+18

Hi @ChathuraM 

This happens only when you have a resource structure with the same name as the company name you are creating. In your scenario, Structure ID TESTXT has been there even before you start creating the company.

 I could recreate the same error by creating the resource structure before creating the company.

Here I have created the resource structure with the same name as the company name that I am expecting to create:

Then Created the company using the same structure name and the same error was noted.

 

Therefore, please make sure you do not have an already created resource structure using the same name as the company name before creating a company. You can open ‘Resource Structures’ window and query from the structure Id in order to find records with the same structure ID.

 

Hope this will clarify your issue .

 

Thanks & Best Regards,

Nethmini


Forum|alt.badge.img+4
  • Author
  • Sidekick (Partner)
  • June 13, 2022

Hi Nethmini,

Thank you very much for your effort.

However I didn't create any resource structure with same ID before creating the company. 

Before creating the company, I confirmed that the Resource ID is not available in the Resource structures screen. But after creating the Company, this error was occurred.

Is there any possible way to resolve this issue?


Nethmini Kosvinna
Superhero (Partner)
Forum|alt.badge.img+18

Hi @ChathuraM ,

If you update the company after deleting the resource structure you will be able to avoid this error. However, in your scenario as the resource structure is auto created when creating the company, you will not be allowed to delete the structure. 

Is this happening repeatedly in your environment ? Could you please mention what is the UPD you are in ?

Thanks & Best Regards,

Nethmini


Forum|alt.badge.img+4
  • Author
  • Sidekick (Partner)
  • July 1, 2022

Hi Nethmini,

Really appreciate your effort. it was an upgrade issue. Thank you very much for the information.


Nethmini Kosvinna
Superhero (Partner)
Forum|alt.badge.img+18

You are most welcome 🙂 !