Replies posted by Roy Almeida

22 Replies

TierajengSidekick (Partner)

asked in Service (Touch Apps, MWO, MRO)

Column Chooser Option for Custom Fields

The above suggestions worked.. thanks!

9 days ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

LEFT OUTER joins syntax versus older version of outer joins. Any performance gains?

Thanks!

1 month ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WARNING: too many parse errors? What is the reason for the error?

Hi It’s been more than 1 year since I logged this. Have not heard any more complaints from the customer regarding this matter. Some database changes were done by the ITAR cloud team which probably alleviated performance issues. The customer has also signed up for UPD22 at this time and patches 157677;163572 will be part of the solution which might help. In addition, going from UPD8 to UPD22 could also mean ORACLE updates/upgrade.If I hear anything more on this matter, I shall revisit this post. Thanks for your help and advice. Roy

1 month ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

The table IAM_LOGIN_EVENT_DETAIL_TAB - is there a cleanup routine? This is growing alarmingly

The JIRA link is https://ifsdev.atlassian.net/browse/PACZSECA-5619

7 months ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

The table IAM_LOGIN_EVENT_DETAIL_TAB - is there a cleanup routine? This is growing alarmingly

IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS did not have a provision to remove rows from IAM_LOGIN_EVENT_DETAIL_TAB. It only removes/cleans up rows fromiam_login_event_tabiam_admin_event_tab Per the latest from R&D:i.e. the fix is in 22R1 SU20 .

7 months ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

The table IAM_LOGIN_EVENT_DETAIL_TAB - is there a cleanup routine? This is growing alarmingly

sounds like a good idea...

7 months ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WARNING: too many parse errors? What is the reason for the error?

It cloud be due to the Oracle Bug 34775863 (Patch 34775863 ). Solution is any of the following (from Oracle): 1. Upgrade to a database version where this fix is included, note this will be included in 19.19.0.0.230418DBRU which will release April 2023. 2. Apply Patch 34775863 if available for your platform and database version, if a patch is not available please create an SR with support to request one. 3. Use the following workaround: alter system set "_nlj_batching_enabled"=0; Thanks for this information….

1 month ago

Roy AlmeidaSidekick (Employee)

posted in Document Management (DocMan)

Attachments/Document object connections do not show in Aurena - but it works fine in IEE client

Thanks...

1 year ago

ctaylor56Hero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Adding Attachments in Aurena

do you need to grant the DocumentHome projection to the permission set(s) connected to the user to make it work in Aurena and display the document object connections?

1 year ago

reimccabeDo Gooder (Customer)

asked in HCM (Human Capital Management, Payroll)

Unpredicted application error in time card day

forgot to mention that you get this error when you create an absence record in time card day. It does not happen when you key in Normal in or Normal out in Time card day...workaround is to generate the calendar connected to the employee resource detail

7 months ago

reimccabeDo Gooder (Customer)

asked in HCM (Human Capital Management, Payroll)

Unpredicted application error in time card day

Hello We get similar issue form time to time. Without going in to the details, did anyone found a solution? It looks like Time Card gets corrupted to the point that no matter what adjustments are made it cannot be fixed and error stays. I came across this error in timecard day for an employee who was connected to a resource detail with resource type “Person” and the calendar connected to the resource was in NotGenerated state.Once I generated the calendar or used a different calendar in generated state, the error in time card day went away after an RMB - Recalculate.

7 months ago

reimccabeDo Gooder (Customer)

asked in HCM (Human Capital Management, Payroll)

Unpredicted application error in time card day

I came across this error in timecard day for an employee who was connected to a resource detail with resource type “Person” and the calendar connected to the resource was in NotGenerated state.Once I generated the calendar or used a different calendar in generated state, the error in time card day went away after an RMB - Recalculate.

7 months ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WARNING: too many parse errors? What is the reason for the error?

Also, the database slowdowns could be happening due to the following errors extracted from the ORACLE alert log:(and this happened on Tuesday) 2023-01-31T17:11:12.229145-06:00WARNING: pga_aggregate_limit value is too high for theamount of physical memory on the system PGA_AGGREGATE_LIMIT is 192512 MB PGA_AGGREGATE_TARGET is 16384 MB. physical memory size is 131071 MB limit based on physical memory and SGA usage is 31948 MB SGA_MAX_SIZE is 86016 MB

1 month ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WARNING: too many parse errors? What is the reason for the error?

Hi Sajith Thanks for your response. We have requested the AWR reports and will review them when they become available. Also if you looked closely at the above errors, they point to ORA-12850 and ORA-12872 which I googled as follows.I dont know if these errors happen every day or sometimes and these are seen in the alert logs.Does it mean that something needs to be tweaked or tuned in the ORACLE database parameter settings? (or even JDBC)? ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocatedError code: ORA-12872Description: First slave parse gave different planCause: First hard parse on slave given QC-supplied environment and parameters gave different plan from QC. Try again with outline.Action: No external action. Internally used for outline-based reparse.

1 month ago

Roy AlmeidaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WARNING: too many parse errors? What is the reason for the error?

When I ran a Google search on the ORACLE errors, it reported the following.What needs to be done to the database to prevent such errors? ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocatedError code: ORA-12872Description: First slave parse gave different planCause: First hard parse on slave given QC-supplied environment and parameters gave different plan from QC. Try again with outline.Action: No external action. Internally used for outline-based reparse.

1 month ago

Roy AlmeidaSidekick (Employee)

asked in Projects Based (Contract/Resource Management, Project Management, Engineering Design & Deliverables)

Unable to publish a custom field due to ORA-20150: COMPILE_ERROR2: Error during compilation of LU [ProjectProgram]

Update: Customer seems to be missing comments on PROJECT_PROGRAM view and also has a custom column called DESCRIPTION. Possibly the reason for the error.

6 months ago

Roy AlmeidaSidekick (Employee)

asked in Products (Manufacturing, Products, Engineering)

Shop order page: - Operations List - command Operation Split/Split dialog does not popup because QUAMAN is not installed?

Thanks… will do so.

1 year ago

Roy AlmeidaSidekick (Employee)

asked in Supply Chain

Slowness/Application freeze in Shop orders material planning?

yes, thanks. I noticed that the customer that I am working on already has that patch. I found another UPD13 customer who exhibits the same slowness after continuous use of the screen. I could recreate the slowness when I started using NA Project Explorer to access IEE client. We have logged this to R&D and also asked System Engineers/DBA’s to examine the database/middleware settings.

2 years ago

IFS_ShekharSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error during creating Inventory Part "domain index is marked LOADING/FAILED/UNUSABLE"

You might also want to check if your customer is on Apps9 or Apps10. An Apps9 patch 144955 is supposed to let you know which index is unusable rather than the “domain index is marked LOADING/FAILED/UNUSABLE” which does not identify the domain index.But at the time of writing this patch is only done for Apps9 and the Apps10 line is still openandpending since 2018. R&D will be notified/asked whether a patch for Apps10 will be forthcoming.

2 years ago

IFS_ShekharSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error during creating Inventory Part "domain index is marked LOADING/FAILED/UNUSABLE"

Maybe to identify which domain index has gone rogue, run the following SQL as appowner: SELECT * FROM all_indexesWHERE DOMIDX_OPSTATUS != 'VALID' OR STATUS != 'VALID' OR DOMIDX_STATUS != 'VALID' When I checked the LCS knowledgebase and one particular case, they hinted at an ORACLE bug and this was from 1 year ago:Q1: Is there a patch for this error? NoQ2: When does this error occur?This error occurs when an attempt has been made to access a domain index that is being built or is marked failed or is marked unusable by a DDL operation. (DDL - Data Definition Language). Indexes can become unusable due to several reasons such as maintenance operations in the relevant table, etc.Q3: There was information in the following communities. Is this information valid for IFS10 Update6?Yes. But this is not a bug in IFS Application. This issue applies to Oracle version 12.1.3 and later.If you have an oracle support account you can learn more about this error from the below link.https://support.oracle

2 years ago

First EmployeeSidekick (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

MRP does not take shop order into account

does the parent part have a scrap factor on inventory part? Is the remaining net supply on shop order different from the lot size?

2 years ago

jabousSuperhero (Employee)

posted in Buying (Procurement, Demand Planner, ASC, SRM)

IFS Users, remember 2020 is a Leap Year. Please check your February 2020 Periods.

To be proactive, it is better to ask your customers to key in periods for the following years well in advance in the statistics period screen. (applicable for leap year and non leap year as well)Customers tend to forget when the year changes and that they need to update the above screen. e.g. if they have data in the above screen up to 12/31/2021 and new transactions come in on 1/1/2022 and they forget to update the above screen to include new period ranges, it could cause serious problems and could need data repair to statistic_period_tab.

3 years ago

Replies posted by Roy Almeida

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded