Monday, 1 September 2025

Understanding Direct and Indirect Quotes in Exchange rates

 https://generalledger-gl.blogspot.com/2025/09/understanding-direct-and-indirect.html

Understanding Direct and Indirect Quotes

1. Domestic / Functional / Ledger Currency: This is the currency of the country or company’s books.

Example: If you are in the UAE, your domestic currency is AED.

  • Foreign → Domestic = Direct Quote
    (How much local/domestic money for 1 unit of foreign currency)

  • Domestic → Foreign = Indirect Quote
    (How much foreign money for 1 unit of domestic currency)

Example with AED (domestic) and USD (foreign):

  • Direct: 1 USD = 3.67 AED

  • Indirect: 1 AED = 0.272 USD

________________________________________

2. Direct Quote

👉 How many units of domestic currency are needed for 1 unit of foreign currency?

Formula: 1 Foreign = ? Domestic

Example (in UAE):

1 USD = 3.67 AED

Here, USD is the base (foreign) and AED is the quote/reference (domestic).

✅ Domestic price of one unit of foreign currency.

________________________________________

3. Indirect Quote

👉 How many units of foreign currency can 1 unit of domestic currency buy?

Formula: 1 Domestic = ? Foreign

Example (in UAE):

1 AED = 0.272 USD

Here, AED is the base (domestic) and USD is the quote/reference (foreign).

✅ Foreign price of one unit of domestic currency.

________________________________________

🔑 Key Notes

Base currency: always the “1” in the expression.

Quote/Reference currency: the other one, expressed in relation to the base.

Which quote (direct/indirect) is “standard” depends on the country and market.




Wednesday, 3 July 2019

Error: Function not available to this responsibility when DRILLDOWN from GL - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/07/error-function-not-available-to-this.html

Please add below Submenu in your Menu

XLA_SL_DRILLDOWN

DRILLDOWN Function for Subledger entries in GL is not Drilling- Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/07/drilldown-function-for-subledger.html

Please add Submenu XLA_SL_DRILLDOWN in your Menu which contains DRILLDOWN for all Subledgers from GL.

If you want DRILLDOWN for a particular Subledger then add from below Function.

Seq
Submenu
Function
Description
5

XLA: Subledger Accounting Details
Subledger Accounting Lines
10

XLA: View Accounting Lines
View Accounting Lines and T Accounts
15

XLA: INV View Material Transactions
Inventory Material Transactions
20

XLA: WIP View Resource Transactions
WIP Resource Transactions
25

XLA: PO View Receiving Transactions
PO Receiving Transactions
30

XLA: FA View Transaction History
Assets Transaction History
35

XLA: PA Expenditure Inquiry
PA Expenditure Inquiry
40

XLA: PA Revenue Review
PA Revenue Review
45

XLA: Brazilian Bank Transfer
Brazilian Bank Transfer
50
Transactions View Only: Subfunctions
XLA: AR Transaction View
AR Transaction Inquiry
55
Receipts View Only: Subfunctions
XLA: AR Receipt View
AR Receipt Inquiry
60

XLA: AR Adjustment View
AR Adjustment Inquiry
65
AP_APXINWKB_VIEW_MENU
XLA: AP Invoice Workbench
AP Invoice Inquiry
70
AP_APXPAWKB_VIEW_MENU
XLA: AP Payment Workbench
AP Payment Inquiry
75

View Translator Transactions
AX Transaction Drilldown
80

XLA: CST View Periodic Material and Receiving Transactions
CST View Periodic Material and Receiving Transactions
85

XLA: CST View Periodic WIP Transactions
CST View Periodic WIP Transactions
90

XLA: PO Requisitions Summary
PO Requisitions Summary
95

XLA: PO Purchase Order Summary
PO Purchase Order Summary
100

XLA: Budget Transactions Summary
Budget Transactions Summary
105

XLA: Transaction History
Transaction History
110

XLA: Treasury Confirmation Inquiry
Treasury Confirmation Inquiry
115

XLA: Enter Budget Authority
Enter Appropriations
120

XLA: Enter Fund Distributions
Enter Fund Distributions
125

XLA: Confirm Payments
Confirm Payments
130

SLA: View Subledger Journal Entry Linesfrom a GL Journal Line
View Subledger Journal Entry Linesfrom a GL Journal Line
135

SLA: Multiperiod Journal Entry Lines Pages
View Multiperiod Journal Entry Lines
140

SLA: View Journal Entries from Supporting Reference Balances
View Subledger Journal Entry Lines from a Supporting Reference Balance line
145

Loan Drilldown
Loan Drilldown
150

JAI: Enter Receipts-India
JAI: Enter Receipts-India
155

JAI: Service Tax Payment Details
JAI: Service Tax Payment Details
160

JAI: Service Tax Manual Entry
JAI: Service Tax Manual Entry
165

JAI: Service Tax Repository Review India
JAI: Service Tax Repository Review India
170

JAI: Service Tax Distribution
JAI: Service Tax Distribution
175

JAI: India Interorg Transfer Excise Details Form
JAI: India Interorg Transfer Excise Details Form
180

JAI: Fulfilled Order India Localization
JAI: Fulfilled Order India Localization
185

JAI: Enter Transactions (AR) India
JAI: Enter Transactions (AR) India
190

JAI: Enter BOE Payment India
JAI: Enter BOE Payment India
195

JAI: Review Draft Invoices for India
JAI: Review Draft Invoices for India
200

JAI: RG-I Manual Entry India
JAI: RG-I Manual Entry India
205

JAI: RG23 Part-I India
JAI: RG23 Part-I India
210

JAI: RG Consolidation India
JAI: RG Consolidation India
215

JAI: PLA Manual Function
JAI: PLA Manual Function
220

JAI: Approve 57 F(4) India
JAI: Approve 57 F(4) India
225

JAI: Enter Manual 57 F(4) India
JAI: Enter Manual 57 F(4) India
230

JAI: View Transaction Lines
JAI: View Transaction Lines
235

JAI: View Accounting Lines
JAI: View Accounting Lines
240

India Localization Taxes
India Localization Taxes
245

XLA: FA View Financial Information
View Financial Information
250

OZF_FUND_PAIDCHK
OZF:Budget Paid checkbook
255

OZF_FUND_EARNCHK
OZF:Budget Earned checkbook
260

OZF_CLAM_DETAIL
OZF: Claim Details
265

PO Order Main Page
PBWC Create/Update Order Main Page
270

XLA: AR Bills Receivable View
Bills Receivable View
275

JAI: Enter Bill of Entry
JAI: Enter Bill of Entry
280

iProcurement: Requisition Details
Requisition Details Page
285

PLA View Transactions - India
PLA View Transactions - India
290

RG23A/C Part II View Trans-India
RG23A/C Part II View Trans-India
295

JAI: View Transaction Lines(New)

300

JAI: View Accounting Lines(New)