Oracle EBS: Currency Conversion in Oracle Internet Expenses (OIE.K)

This blog post aims to explain where the conversion rate in Oracle Internet Expenses is derrived from and how setting a policy can have quite a significant effect on the total value returned.The exchange rate used to convert a non-GBP expense claim back into GBP to be paid is handled in two parts within Oracle.In the General Ledger (GL) there is a table of "Daily Rates";This shows the currency conversion rate entered into the system for a specific...

Read More

Oracle EBS: Viewing General Ledger (GL) Daily Currency Conversion Rates

NOTE: This SQL works in version 11.5.10.2, your version might be different!Many companies like to have "one version of the truth" (I say "like to" as we all know how hard this is to actually achieve!). One of the ways this can be achieved is a standardised set of currency conversion rates across an organisation.The SQL in this blog post gives you a quick and easy report showing the currency conversion rates currently being used in the GL.If your company is using Oracle Finance software (i.e. General Ledger) and the currency conversion rates are...

Read More

Oracle EBS: Updating Vendor and Vendor Site (Supplier) Information in Oracle e-Business Suite (11i)

This blog post covers how you update Vendor and Vendor Site records in Apps 11i. The included example shows how you clear the Tax Code associated with both types of record (this is particularly useful in the UK where our Sales Tax has changed).The ProblemChanges quite often need to be made to the records in the PO_VENDORS and PO_VENDOR_SITES tables that involve changes to a large number of records . For example when the Sales Tax (VAT) rate changed...

Read More