Payables and Cash Management - EBS (MOSC)

MOSC Banner

Please share any logic to round withholding tax in ap_custom_withholding_pkg

edited Apr 26, 2018 3:20PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered ✓

Please share any logic to round withholding tax for Amount and Base Amount in ap_custom_withholding_pkg

Currently I was using below logic in ap_custom_withholding_pkg. But it was showing Error in some Invoices of Prepayment Application and some times wrong Tax Calculation on Prepayment Application Invoices

--bug13334982

AP_CUSTOM_WITHHOLDING_HOOK_PKG.Ap_Special_Withheld_Amt

                                     (P_Withheld_Amount

                ,P_Base_WT_amount

                ,P_CurrCode

                ,P_BaseCurrCode

                ,P_Invoice_exchange_rate

                ,P_Tax_Name

                ,P_Calling_sequence

                ,P_Unrounded_WT_Amount

                ,P_Calling_parameter

                                      );

--------custom Code begins from here----------------

--Logic:(Round down to precision zero)

     if nvl(P_Calling_parameter,'') ='HEADER' then

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center