My Oracle Support Banner

Logical Expense Requisition Generate Negative INV_SUB_LEDGER_ID Encumbrance Accounting (Doc ID 2484871.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Cost Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Cost Manager is generating negative INV SUB LEDGER_ID in MTL_TRANSACTION_ACCOUNTS table for ACCOUNTING_LINE_TYPE = 15 Encumbrance Reversal

when transaction type is Logical Expense Requisition Receipt and not Populate Xla_distribution_links table.

Expected correct positive INV SUB LEDGER_ID

in cstpacdp.insert_account there is a insert into insert into mtl_transaction_accounts as insert into mtl_transaction_accounts (
  inv_sub_ledger_id, /* R12 - SLA Distribution Link */
transaction_id...
 select
  /* Bug 9356654- Costing Single Event Approach for Inventory
For encumbrance line making inv_subledger_id value as -ive
to indicate single event encumbrance data
*/
decode(i_acct_line_type,
  15,
-1*CST_INV_SUB_LEDGER_ID_S.NEXTVAL,
CST_INV_SUB_LEDGER_ID_S.NEXTVAL),


Need to understand why this procedure generate negative INV_SUB_LEDGER_ID when account line type = 15
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.