Best Of
Re: How to generate move order for material in work order
This set up is must for the process to work please.
Re: Three hours of red alert in OCOM. Have you ever seen something like this?
Hello,
These red and yellow bands are considered to be a software bug. I got following instructions on how to get rid of them from Support:
We analyzed the logs and could see the frames are getting dropped.
Jul 29 02:08:16 OCOM vsi[1693323]: ERROR (pktsub.c:825 handle_seqno) connection 'tcp://127.0.0.1:18010' lost 7244 frames
Jul 30 00:40:04 OCOM vsi[1740960]: ERROR (pktsub.c:825 handle_seqno) connection 'tcp://127.0.0.1:18010' lost 1 frames
Jul 30 00:40:04 OCOM vsi[1740960]: ERROR (pktsub.c:825 handle_seqno) connection 'tcp://127.0.0.1:18010' lost 7664 frames
Jul 30 00:44:51 OCOM vsi[1740960]: ERROR (pktsub.c:825 handle_seqno) connection 'tcp://127.0.0.1:18010' lost 76 frames
Jul 30 00:44:51 OCOM vsi[1740960]: ERROR (pktsub.c:825 handle_seqno) connection 'tcp://127.0.0.1:18010' lost 6183 frames
To address this we recommend you to please create new files namely apid.local.conf and vsi.local.conf with the below recommended values:
=> apid.local.conf
[publisher/sip]
hwm=100000
=> vsi.local.conf
[broker]
connsock_hwm=100000
these files should be under /opt/oracle/ocsm/etc/iptego/
Restart all processes in order to apply the change as below. Note that this will create a short service interruption and you will see a sudden drop in graphs. Perform this action within a maintenance window.
# systemctl restart pld-apid.service
# systemctl restart pld-vsi.service
Regards,
Daureen
Re: Hostname must be <= 30 characters in length
Hi.. I have rarely seen systems with more than 30 character names. In future it might be a limitation. Please post an idea in community and if other customers also feel it's required in future releases... They will vote for it and it will be considered for enhancement.
Regards,
Balaji P.
Setting Up Forms Personalization to Trigger Events Based on Sales Order Conditions
Learn how to display messages, based on specific criteria, on the sales order form using forms personalization. Doc ID 3046082.1. https://bit.ly/47Cful7
#EBS #OrderManagement
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,