Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to get the Accruals as je_category in General Ledger (General Ledger (11.5.10))
Query to get the Accruals as je_category in General Ledger [message #329469] Wed, 25 June 2008 08:59 Go to next message
lakshminarayana.j
Messages: 9
Registered: May 2008
Location: Pune
Junior Member
Hi,

I am facing an issue to get the data like JE_SOURCE='Purchasing' and je_category='Accruals' .

Columns in my report like
accounted_dr
,accounted_cr
,PO#
,VENDOR NAME


Suggest me how to implement the query with above details.


Thanks
Lakshmi Narayana


Re: Query to get the Accruals as je_category in General Ledger [message #329511 is a reply to message #329469] Wed, 25 June 2008 11:08 Go to previous message
Alien
Messages: 245
Registered: June 1999
Senior Member
Hi,

I copied a bit from Metalink note: 121858.1
If you have Metalink access, I would encourage you to read the note.

Also, think careful if you want to get the Accruals just from PO (Receiving) or also from AP (Invoices).

Quote:
The following columns in GL_JE_LINES table can be used to 
track purchasing source information:

REFERENCE1         :  Document type (PO/REQ)
REFERENCE2         :  Document header id
REFERENCE3         :  Document distribution id
REFERENCE4         :  Document number that you see on the document itself
ACCOUNTED_DR       :  Debits
ACCOUNTED_CR       :  Credits

The accounting transactions that take place for receiving (either online or
period end) against a $10 encumbered purchase order are indicated in the table
below:

    -------------------------------------------------
   |Doc    |Exp  | Exp | RFE | RFE | Rec | Rec | Rec | 
   |       |Dr   | Cr  | Dr  | Cr  | Dr  |AccDr|AccCr|
   |-------|-----|-----|-----|-----|-----|-----|-----|
   |PO     |     |     |     |     |     |     |     | 
   |Reserve| 10  |     |     | 10  |     |     |     |
   |       |     |     |     |     |     |     |     |
   |-------|-----|-----|-----|-----|-----|-----|-----|
   |Receipt|     |     |     |     |     |     |     |
   |Accrual|     | 10  | 10  |     |     |     |     | 
   |Enc Rel|     |     |     |     |     |     |     |
   |-------|-----|-----|-----|-----|-----|-----|-----|
   |Exp    |     |     |     |     |     |     |     |
   |Account| 10  |     |     |     |     |     | 10  |
   |Charge |     |     |     |     |     |     |     | 
    -------------------------------------------------

   Note:  RFE - Reserve For Encumbrance, Dr - Debit, 
          Cr - Credit, Exp - Expense, Acc - Accrual, 
          Rec - Receipt, Rel - Relief, Enc - Encumbrance  



Regards,

Arian

[Updated on: Wed, 25 June 2008 11:09]

Report message to a moderator

Previous Topic: Migrating E-Business Suite 11.5.2 from Solaris 9 to Solaris 10
Next Topic: How to Install Oracle E-Busines Suite R12 as a Multi-Tier
Goto Forum:
  


Current Time: Sun Dec 11 06:25:26 CST 2016

Total time taken to generate the page: 0.04054 seconds