PLSQL Function in SQL Query Fusion

Preventing Duplicate Form Submission in Oracle APEX

Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally click the Save button multiple times due to slow network…

Read More

Item Where-Used Analysis Report (Excel – PL/SQL)

Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…

Read More

Deterministic Functions in Oracle 

Deterministic Functions in Oracle    Overview A deterministic function in Oracle is a function that always returns the same result for the same input values and has no side effects.…

Read More

Pipelined Function for String Separation

We might face some scenarios for convert string data into rows. Here you can separate a string into rows by giving the string separator as input. Users can give any…

Read More

Project Unbilled Balances Query – FUSION

WITHFUNCTION get_rev_todate_amt (      p_contract_id      IN NUMBER,            p_contract_line_id IN NUMBER,      P_AS_OF_DATE       IN DATE   )RETURN NUMBERIS  ln_amount NUMBER;BEGIN      SELECT SUM(PRD.cont_curr_revenue_amt) cont_curr_revenue_amt     INTO ln_amount     FROM pjb_rev_distributions PRD    WHERE PRD.gl_date <= P_AS_OF_DATE     …

Read More