Asanka's - IFS Blog

Problem: @DynamicComponentDependency is deprecated from IFS Cloud 22R1 onwards. Solution: Please see the below exam…

Following query can be used to get all the active sessions. SELECT SID, SERIAL#, STATUS    FROM V$SESSION    WHERE US…

Usage of BOOLEAN("TRUE", "FALSE") is more useful when considering the performance than FndBoolean…

Inside an event action we can use below code to create a record in report archive and print it or can     write inside…

Add 'Fetch first row only' after the where condition. Eg: SELECT * FROM customer_order_tab WHERE contract = &#…

SELECT company,        pay_term_id,        description,        day_to,        MAX(CASE WHEN rn = 1 THEN disc_days_cnt E…

We can add global variables to the client side (Aurena) as well as server side, values of global variables are availabl…

Execute below query and it will list down all the list of deliveries installed on that environment. SELECT *  FROM mo…

To create the table CREATE TABLE backup_co_reservation_tab AS   SELECT *  FROM customer_order_reservation_tab WHERE ord…

Problem:  If we don't have configurations such as Custom Fields, Custom Views etc. versioned control in git reposit…