Replies posted by Harikrishnangr

28 Replies

Is it possible to add custom fields in ‘Purchase Receipt History’ Screen.?

Hi, in our test environment this works fine with local, persistent and also reference custom field. At first I could not make it work, but after reloading configurations several times and then restarting the session it seems fine. Have you also restarted and checked again? Let me know how it goes. :) Thank you ELJO, it worked after a restart like you said.

6 months ago

HarikrishnangrSidekick (Customer)

asked in Getting Started with IFS

Is it possible to add custom fields in ‘Purchase Receipt History’ Screen.?

I just published one in the IFS10 Reference environment and it didn’t work for me either :( It worked for me after a restart, my version is IFS10 UPD13

6 months ago

HarikrishnangrSidekick (Customer)

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

How to create Output Logs for procedures

Hi @Harikrishnangr, You can use debug console. Check PL/SQL tab for input and ouputs. Tools → Debug Console Thank you

6 months ago

HarikrishnangrSidekick (Customer)

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

Copy inventory part characteristics values

Hi Hari, I would like to add: The View brakes down to the inventory_part_char_tab: CREATE OR REPLACE FORCE EDITIONABLE VIEW "IFSAPP"."INVENTORY_PART_CHAR_ALL" ("CONTRACT", "PART_NO", "CHARACTERISTIC_CODE", "UNIT_MEAS", "ATTR_VALUE", "ATTR_VALUE_NUMERIC", "ATTR_VALUE_ALPHA", "OBJID", "OBJTYPE", "OBJVERSION", "OBJKEY") AS SELECT contract contract, part_no part_no, characteristic_code characteristic_code, unit_meas unit_meas, attr_value attr_value, TO_NUMBER(DECODE(characteristic_API.Get_Search_Type_Db(characteristic_code), 'N',attr_value)) attr_value_numeric, DECODE(characteristic_API.Get_Search_Type_Db(characteristic_code), 'A',attr_value) attr_value_alpha, rowid objid, rowtype objtype, ltrim(lpad(to_char(rowversion,'YYYYMMDDHH24MISS'),2000)) objversion,

6 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

View/table for screen 'inventory part availability planning'

Hi @Harikrishnangr, I checked this myself. You are correct. The view is ORDER_SUPP_DEM_EXT_TMP_VIEW. This is built using supply_demand_info_tmp table. The query used for the view is SELECT order_no order_no, line_no line_no, rel_no rel_no, line_item_no line_item_no, order_supply_demand_type order_supply_demand_type, part_no part_no, contract contract, configuration_id configuration_id, qty_supply qty_supply, qty_demand qty_demand, qty_short qty_short, qty_pegged qty_pegged, qty_reserved qty_reserved, condition_c

5 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

View/table for screen 'inventory part availability planning'

Hi, this is, like you say, a temporary view and the view name is the one you have found. It is generated when you search for a specific part and holds the data for a limited time. Data is fetched and calculated from several other views. If you check the debugger, the select for the in tab All looks like this: SELECT date_required, order_supply_demand_type, status_desc, qty_supply, qty_demand, qty_reserved, qty_pegged, qty_short, NULL, &ao.order_supply_demand_api.get_qty_plannable_fast_tmp__(:p0, :p1, :p2, :p3, trunc(date_required), :p4, :p5,

5 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

View/table for screen 'inventory part availability planning'

5 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

View/table for screen 'inventory part availability planning'

Hello, I also confirm. I think the only way to recreate the temp data is to do the similar SQL logic that is done when populating the data, because in this situation there is no option to create an event for the temp table - no table to select for the event: but I’m not sure if it will be possible without customization. Thank you Pobocha

5 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

View/table for screen 'inventory part availability planning'

Hello everybody, just did a quick look by myself and also confirm. On my customers ORACLE DB the table is empty (at the moment). Quite astonishing: most of all the tables end with _TAB. This one with _TMP. I’m very interested about the code which fills the table temporarily! We had similar issues in other data structure and we would love to learn how IFS is “ticking”. All the best Michael Thank you Michael

5 months ago

HarikrishnangrSidekick (Customer)

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

Copy inventory part characteristics values

I didn’t find any documentation for it. Below are database objects for characteristic codes: Technical_Object_Reference_tab Technical_Object_Reference_api Technical_Object_Reference To use them, you need to check what method/procedures may be useful to you and what is the structure of the data in the table. If you have any problem, describe it and we will try to solve it. Best regards Bart Thank you very much Bart :)

6 months ago

HarikrishnangrSidekick (Customer)

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

Copy inventory part characteristics values

Hello, I also struggle with this issue from time to time - this is how you can find view/table/package names for it: Hi, thank you for the reply. Could you please elaborate this a bit (or please send any documentation link if available). Thanks in advance.Best Regards,Hari

6 months ago

HarikrishnangrSidekick (Customer)

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

'Register arrivals' screen table custom event event.

The table should be: purchase_order_line_tab Thank you Link

10 months ago

HarikrishnangrSidekick (Customer)

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

'Register arrivals' screen table custom event event.

Hi @Harikrishnangr the LU is: PurchaseOrderLine and the view is: RECEIPT_INFO_ALT Thank you Link

10 months ago

HarikrishnangrSidekick (Customer)

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

'Register arrivals' screen table custom event event.

Hi, I have events on Purchase_Receipt_tab - registering the arrival will make an new entry in that table - so it would fire on new lines I suppose it depends what type of event you are creating the exact set-up. Thank you Matthew, I have created an event in receipt screen. Best Regards,Hari

10 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

How to disable add new records button in shop order

Hi, not sure what is your level of confidence with permission sets, but it’s where you can find your solution. Each screen is attached to a package (API): (i don’t have shop order, but same principle with purchase order) Then you go in permission set and you can search for this API in Database Objects. When you click on it, you ll see that each API is connected to “Methods” and you will find a methods called “New_” or similar. That is the one(s) you must deactivate in the permission sets given to your users. To know which permission is granted this method, just right click and choose “Show Grantees” Thank you

11 months ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

How to disable add new records button in shop order

HI! I have checked this right now and @ludovic.rougean have right:) I have disabled Procedure New__ and symbol ‘+’ was disapired. Best regards Szymon Thank you

11 months ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to create Custom event action on custom field table to save data to the same table for other records

In this case, I’m sorry, you need to know a bit of PL/SQL, i would not know where to start. What I can tell you is that you may face a problem if you try to just update this value straight away as your table is in a locked status due to other modification on going. You should update your 2nd field though a background job. So first your table will be saved and then it will update your 2nd field, few seconds later. This post describes how to create a background job: https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/inserting-a-value-upon-new-data-creation-on-custom-logical-unit-24431?postid=89780#post89780 That’s basically 2 procedures imbricated. By amending the code of the procedure in the middle, you should be able to achieve your objective. Thank you Ludovic

1 year ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to create Custom event action on custom field table to save data to the same table for other records

Hi, what is exactly the difficulty you are facing? you don’t know how to make a custom event? or you know how to make custom events, but when you tried this one, you got an error message saying you cannot update this table ? Hi Ludovic, Thanks for the reply.I’m stuck with writing the event action. this is the first time for me. (Previously tried only email type of actions, never tried ‘execute online SQL’ type)appreciate if you could help. Best Regards,Hari

1 year ago

HarikrishnangrSidekick (Customer)

asked in Supply Chain

you are not authorized to issue RANDEX lines

Please use the Debug Console to find out what functionality isn’t allowed for your specific permission sets. Thank you Bernd.

1 year ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

What proposed Thomas is clearly better and I also realized you can see it from the permission set, in component part. Thank you Ludoviv, got it from permission set as well.Best Regards,Hari

1 year ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

You can do query from view REPORT_DEFINITION view to get the package name + method name used by a report: SELECT methodFROM ifsapp.report_definitionWHERE report_id = 'FIN011B_REP' Hi Thomas, got it “XLR_TEMPLATE_UTIL_API.Execute_Report”

1 year ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

You searched for the package %FIN011B% you got nothing ? If no, it seems your report is custom, actually I do not have it on my DB. In this case it could be included in another package or they may have used an other name for the package, you try several combinaison including %Part%Provision% until you find an RPI package that seems matching… Hi Ludovic, Still I’m getting no data.Is there any way, can I get the code using PL/SQL developer? Best Regards,Hari

1 year ago

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

Hi, you should get the ID of the report from the view REPORTS: Or you can also use the Debug console. Then with the ID, go to PL/SQL Package Code, and the search for the ID, replace REP by RPI. ex: PART_CERTIFICATE_REP → PART_CERTIFICATE_RPI Hi Ludovic, thank you.for report ‘Part provisions by company/site’, the report id is FIN011B_REP,but I cannot find that in PL/SQL package Code screen. showing no databest Regards,Hari

1 year ago

HarikrishnangrSidekick (Customer)

asked in Distribution (CRM, Commerce)

Not able to save data in 'Register Arrivals' screen.

Hi! According to me, on this form 'Register Arrivals' is not allowed to save any data. Notice that when you change the normal field (for example 'Qty to Recive') you still can't click 'save' bottom. From this place in the application, You can create Purchase Order or click on the row Right mouse button and run 'Receive...' Your custom field works in the same way as the normal field on this form. Best regadrs, Thank you Kneszygre, I have noticed that the fields created in register arrival is available in purchase order line screen and I'm able to save data there.

1 year ago

HarikrishnangrSidekick (Customer)

asked in Distribution (CRM, Commerce)

How to align data in field

It is a standard functionality of IFS and it cannot be modified. Numeric fields - Right aligned by default Others / Text fields - Left aligned by default. Thank you Pratik

1 year ago

Page 1 / 2

Replies posted by Harikrishnangr

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded