Best Of
Re: DD changes from upgrade 8.11 to 9.2
In E1 8.11 instance, open F9210 in Databrowser. Find above DD Alias, look up columns (UserID, Date Updated, Program ID, Workstn ID, Time Updated). I think these DD items have been customized in 8.11 changing the original Display Decimals (as displayed in 9.2).
I thought upgrade from 8.11 to 9.2 would retain DD custom changes. Justin can confirm.
I reviewed this post from Design Tools side.
Re: DD changes from upgrade 8.11 to 9.2
From the upgrade guide, under What Custom Modifications an Upgrade Preserves and Replaces\Control Table Rules:
An upgrade preserves these changes:
• Data dictionary custom changes.
These include such as changes to row, column, and glossary text. The upgrade process uses your data
dictionary as the base.
During the upgrade a R98403 runs to copy the Data Dictionary from the previous release to the new release and then the R989200P runs to merge in the new release changes.
Table conversions should run against a pristine data dictionary to make sure your data doesn't get messed up, in particular the display decimals.
-The Pristine Environment uses the Pristine data dictionary which does NOT have the changed data decimals in it.
-Therefore JDB doesn't think there is a difference between the saved input specs and the output specs and it does not do the multiply / divide.
I'm not sure what you should be changing the display decimals to in 9.2, but you might want to post something to an applications community or open an SR with the applications support group.
Might also want to review the following document:
E1: DD: Frequently Asked Questions on Data Dictionary (Doc ID 626537.1)
-Question 2: What is the Difference between File Decimals and Display Decimals?
-Question 3: What Attributes Should Not be Changed on an Existing EnterpriseOne Data Item?
Re: in EBS R12.2.6 Is there a way to see what Role ALL Users Responsibilities were inherited from?
Hi Joe DiRubbo,
Get the roles and role inheritance details from below tables
wf_local_user_roles
wf_role_hierarchies
In wf_local_user_roles table any entry with role name UMX| those are inherited from responsibility.
Below query is for reference. You may modify according to your data
select wfur.user_name,wfur.role_name,
wrh.super_name from
wf_local_user_roles wfur,
wf_role_hierarchies wrh
where user_name='TEST_USER' and
wrh.sub_name=wfur.role_name;
Thanks,
Hari
Re: 2nd Application and Process Scheduler - Miscellaneous Questions
Hi - Refer below answer.
Ren Server:Since the Ren Server runs on the application server, you don’t need to configure it on a second app server if you’re spinning one up just for IB. If you do want it for load sharing, you’ll need a load balancer with both app servers behind a VIP. Set it up as active/passive so if one goes down, the other takes over.
Report Node:No need to create a second report node. The existing one is fine since you’re not adding a second web server. Just create the new Process Scheduler server, and in its Distribution tab, select your existing distribution node.
Jolt Failover:Keep it simple with server1:port1, server2:port2. That setup works reliably and usually performs better than the more complex failover parameters.
-Velu
Re: Query to find the details related to position hierarchy
Hi
Thanks Nirmal and Anantha,
Regards,
Re: Service Calendar adding new Computational period... where is it?
Hello,
I am requesting this post to be moved to "Human Resources and ELM - PSFT (MOSC)".
Regards,
Re: Service Calendar adding new Computational period... where is it?
Hi,
I have moved this question into the PeopleSoft (MOSC)› Human Capital Management - PSFT (MOSC)› Human Resources and ELM - PSFT (MOSC) subcategory for those subject matter experts to further engage.
If an answer resolves your question, please choose the "YES" on that comment for "Did this answer the question?".
In the meantime, feel free to review the following information to learn more about our Community:
- How to Find and "Follow" Categories - Learn how to Follow Categories of interest
- Setting Up Category Notifications for New Content - Learn how to get notifications on content
- How to Search and Do Advanced Search - Learn how to get to advanced search and filter options
- Visit our MOSC Resource Center,
- Browse all of our represented Product Categories.
- How to Edit Your Community Username - Details are provided to change your default display name, which will allow for a more personalized profile.
- How to Ask Questions and View Answers - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question.
- Community Guidelines: https://community.oracle.com/mosc/kb/articles/27-my-oracle-support-community-guidelines
- How to be a good Community citizen" -- https://community.oracle.com/mosc/kb/articles/23-my-oracle-support-community-posting-etiquette
- Not posting Private Information: https://community.oracle.com/mosc/kb/articles/15-what-is-pi-information-and-why-is-it-important
- How to be a Community Star: https://community.oracle.com/mosc/kb/articles/30-how-to-be-a-community-star-six-behaviors-to-promote-mosc-success
Best Regards,
Margi
My Oracle Support Community Administrator
Re: Service Calendar adding new Computational period... where is it?
The service calendar can be accessed at navigation: Workforce Development > Faculty Events > Define Faculty Events Data > Calendar. For reference, please see PeopleBooks at
Regards,
Ben
Re: Reports 14c - standalone server error: java.lang.StackOverflowError "process reaper"
@Gerrit van der Linden @Matej D.
Adding below in the reports.sh should resolve the issue and also this increases the overall Reports Server performance.
REPORTS_JVM_OPTIONS="-Djdk.lang.processReaperUseDefaultStackSize=true"; export REPORTS_JVM_OPTIONS
Re: Machine Name table
Hello @2011 ,
Please do not duplicate the questions in different threads.
You addressed the same question in this thread:
Thank you!
Best regards,
Cezar
