Oracle R12 OM or EBiz Tax: API to recalculate Tax at Order Level

You can re-calculate tax for any given sales order by using following PL/SQL Block.

This API works same as ‘Actions->Calculate Tax’ from Sales Order Form(OEXOEORD).

DECLARE
l_header_id NUMBER;
l_return_status VARCHAR2(10);
BEGIN
            l_header_id := 12345;--pass order headers header id
           
---fnd_global.org_context (Initialize the org)

            OM_TAX_UTIL.calculate_tax(p_header_id       => l_header_id
                                     ,x_return_status   => l_return_status);

          IF (l_return_status = 'S') THEN
             commit;
          ELSE
              Dbms_output.put_line(‘Failed in Re-Calculating Tax’);
              Rollback;
          END IF;
END;