E9.2 APP and UBE used in All ORCH

[BetoJDE]

Hi friends
I have an issue, y need search every SREQ contained in all ORCH in order to extract the APPs and UBE used for security configuration, i hope there was a automatic or semiautomatic form to do this task.

I hope you guys now a way to do this task in order to avoid doing this manually.

Thanks in advance for your help

 

[DaveWagoner]

My orchestrator parser included a way to write components out to a workfile to give a sort of cross reference. I think that could be leveraged to do what you want.

See "HC_OR_PopulateUDORef_P5598700_R1" within the attached file. I think if I had to do it over again I'd do the file i/o in LEX-- would remove the need for a frontend for the FR. One for the "future improvements when my time frees up" list.

 

[DaveWagoner]

Sorry, forgot a piece. Get all orchs via data request, then iterate over the orch parser.

 

[JasonDorough]

You can also find the orchestration in P98220U, select it, click row->advanced->view dependencies

 

[AdrianKaly]

Building on what Jason said above, you can use SQL or a BI tool like ReportsNow to look at the F98700D - Object Dependencies table. Your SREQ are the Calling Object and then filter the Called Object by P* or R* for APP/UBE list.

 

[BetoJDE]

My orchestrator parser included a way to write components out to a workfile to give a sort of cross reference. I think that could be leveraged to do what you want.

See "HC_OR_PopulateUDORef_P5598700_R1" within the attached file. I think if I had to do it over again I'd do the file i/o in LEX-- would remove the need for a frontend for the FR. One for the "future improvements when my time frees up" list.

Hi Dave, thanks for your help i will install the files and study to reach the goal.

You can also find the orchestration in P98220U, select it, click row->advanced->view dependencies

Thanks for your contribution i tried to find some automatic way to do that.

I let you now when i find a solution for this case

​

 

[eydeak]

You can also find the orchestration in P98220U, select it, click row->advanced->view dependencies

Problem is, when you have several hundred to look through, checking them all one at a time isn't really a good option.

There is an enhancement request in Quest: "Fully integrate Orchestrator objects into the Cross Reference Facility"

https://cloudnnf.questoraclecommunity.org/questenhancementtool/ViewEnhancement.aspx?id=16744

I'd encourage anyone who is a Quest member to prioritize it if you want to see it. In the meantime, Dave's parser is the best option I've seen for this kind of thing.

 

[Kevin Long]

You can also find the orchestration in P98220U, select it, click row->advanced->view dependencies

As far as I know, the dependencies you can view are UDO only with the exception of composite pages and CafeOne. It will not display the application/form being called from the form request or the UBE from a report service request. I would certainly love to see dependencies extended to the root JDE objects for all UDOs, where applicable.

 

[BetoJDE]

As far as I know, the dependencies you can view are UDO only with the exception of composite pages and CafeOne. It will not display the application/form being called from the form request or the UBE from a report service request. I would certainly love to see dependencies extended to the root JDE objects for all UDOs, where applicable.

Yes Kevin you right, in orden to do this taks i put a category to all SREQ objects (in this clients doesn't use the category), export using export by category, then merge all XML in only one (almost 104 files)
For APP you got something like this



For Reports (UBE) you got this:


By time restrictions i use a find in Notepad in order to extract the information semi manualy, but this information is include in the blob field from F9524840 (SREQ Table).

To complete the task i will need the dependences to track the orchestrator that use every service request. For do that i will use the recomendations for Dave and eydeak.