OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Query to get the Accruals as je

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to get the Accruals as je_category in General Ledger (General Ledger (11.5.10))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query to get the Accruals as je_category in General Ledger [message #329469]

Wed, 25 June 2008 08:59

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

Report message to a moderator

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

Alien
Messages: 292
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 23:47:35 CDT 2024