R12.1.1+: PO: How To Enter SLA Manual Adjustement Encumbrance Journal for a PO/Receipt in Purchasing or Cost Management (Doc ID 1439857.1)

Last updated on JULY 07, 2016

Applies to:

Oracle Purchasing - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

How to create a SLA manual encumbrance adjustment journal  for a Purchasing document in Purchasing or Cost Management ?

Note that the manual adjusted journal should be closed to the initial journal
which is generated from Purchasing or Cost Management  module.
This depends to the transactions :
 
Case A
=====
For encumbrance entries generated for reservation/un-reservation of Purchasing documents (ie. Requisition, Purchase Order, autocreated Purchase order, Blanket Release¦), initial SLA /GL journals contain the following information :

in XLA tables :
- APPLICATION_ID                 201
- JE_CATEGORY_NAME          Accrual
- ENCUMBRANCE_TYPE_ID    1001
 
in GL tables :
- JE_SOURCE                           Purchasing
- JE_CATEGORY                      Purchases (or Requisitions)
- ENCUMBRANCE_TYPE_ID    1001 ( Obligation for Purchase Orders)
                                                or
                                                1000 ( Commitment for Requisitions)

Therefore the manual journal should be created in Purchasing responsibility.

Case B
======
For delivery transactions, the associated SLA and GL journals contain the below values:

in XLA tables :
- APPLICATION_ID                    707
- JE_CATEGORY_NAME             Accrual
- ENCUMBRANCE_TYPE_ID       1001

in GL tables:
- JE_SOURCE                             Cost Management
- JE_CATEGORY                       Accrual
- ENCUMBRANCE_TYPE_ID = 1001 ( for Obligation)

The adjustment journal should be entered into Cost Management responsibility.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms