My Oracle Support Banner

Issues Related To R12 Create Accounting Process - List Of Code Fixes (Doc ID 1179643.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Purchasing - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Details

This document is a master note which consolidates all the code fixes done in the problem category "Issues related to R12 Create Accounting process" initiated from Cost Management.

Actions

Whenever you get an issue related to the problem category 'Issues related to R12 Create Accounting process', please try to match your issue with the symptoms listed in this document and get the relevant bug and apply the patch specified against each symptom to resolve that issue.Please go through the Read me of the patch before applying it and it is always recommended to apply the patch in TEST instance first and do the testing before applying it in Production instance. If the symptoms mentioned in this document do not match with your issue, please log a Service request with Oracle Support.

S.NoReported Release VersionSymptomsBug NumberBug AbstractRoot CausePatch NumberFixed file version / File version upgraded by the patch suggestedBehavior after Patch application
1 12.1 & above Create Accounting-Receiving or Create Accounting-Cost Management program does not create accounting entries for Landed Cost Adjustment event for LCM enabled PO receipts <Bug.9168334> LANDED COST ADJUSTMENT ACCOUNT WAS NOT CREATED AFTER RUN LANDED COST ADJUSTMENT Code limitation in files cstxlaaad.ldt and cstxlaemseed.ldt <Patch.9600743:R12.BOM.C> cstxlaaad.ldt - 120.32.12010000.17
cstxlaemseed.ldt - 120.5.12010000.9
Create Accounting program will create the accounting entries for Landed Cost Adjustment event for LCM enabled PO receipts
2 12.1 When Create Accounting-Receiving program is submitted, Accounting program gets spawned which completes with error.Log file shows the exception - An internal error has occurred in the program XLA_00707_AAD_S_000005_PKG.EventClass_267 ORA-06502: PL/SQL: numeric or value error: charac" "An internal error occurred. Please inform your system administrator or support representative that:

<Bug.9600743>

ACCOUNTING PROGRAM (XLAACCUP) COMPLETES IN ERROR

When the source used in the create accounting program is higher than 240 characters, the accounting program errors out with the ORA-06502: PL/SQL: numeric or value error: characters which is a limitation of XLA accounting program

<Patch.9600743:R12.BOM.C>


cstcxla.odf - 120.67.12010000.20 Create Accounting -Receiving program will get completed successfully without this error

3 12 & 12.1 1. In encumbrance enabled environment, encumbrance reversal hits the funds inquiry once the PO receipt is performed where as the Actual hits the funds inquiry only after doing the Create Accounting process and posting the entries in GL. This time gap creates incorrect funds availability resulting in over expenditure 

2. Multiple create accounting requests get spawned during the online create accounting process resulting in performance issue. This occurs primarily in encumbrance enabled environment and when multiple receipts are performed at the same time. For every receipt line, one create accounting program,Journal import and posting get triggered.

<Bug.9292380>

COSTING SINGLE EVENT APPROACH FOR EXPENSE DESTIONATION PO

Design issue between CST,PSA,XLA for encumbrance accounting flow or Expense Destination POs accrued at receipt and accrued at period end


<Patch.9456733:R12.BOM.A> for R12 & <Patch.9600743:R12.BOM.C> for 12.1.1 and 12.1.2

[cstxlaemseed.ldt - 120.0.12000000.19; cstcxla.odf - 120.56.12000000.27; CSTVRAPB.pls - 120.12.12000000.6; CSTVXLAB.pls -120.36.12000000.18; cstxlaaad.ldt - 120.22.12000000.37; bomprf.ldt - 120.9.12000000.9; RCVVACCB.pls - 120.10.12000000.5] for R12 & [cstxlaemseed.ldt - 120.5.12010000.12; cstcxla.odf - 120.67.12010000.20; CSTVRAPB.pls - 120.12.12010000.6; CSTVXLAB.pls -120.43.12010000.8; cstxlaaad.ldt - 120.32.12010000.20; bomprf.ldt - 120.11.12010000.6; RCVVACCB.pls - 120.11.12010000.6] for 12.1.1 & 12.1.2

The profile option "CST:Receiving Accounting option" is obsoleted and the Create Accounting process will always happen in concurrent mode and not in online mode in both encumbrance and non encumbrance environment. Hence there will not be any performance issue with Create Accounting process when multiple receipts are done. Encumbrance reversal and Actuals hit the funds inquiry only when both these entries are posted in GL and hence there won't be any mismatch shown in the Funds availability when Expense Pos are received

4 12 & 12.1 While attempting to save the PO receipts with destination type as expense in encumbrance enabled environment, the following error occurs: rvtptcontrol failed RVTTH-448 Subroutine User-Defined Exception in Package CST_XLA_PVT Procedure Create_RCVXLAEventStatement -60: Error in Encumbrance Accounting/Budgetory Control: SQL Error: User-Defined Exception returned

<Bug.9291949>

GETTING RVTTH-448:SUBROUTINE USER-DEFINED EXCEPTION ERROR WHILE RECEIVING EXPENS

The view PSA_CST_XLA_UPG_V was not handling Blanket Purchase Order Release properly. The Entity code for Blanket Purchase Order Release is different

<Patch.9291949:R12.PSA.A> for R12 & <Patch.9711342:R12.PSA.B> for 12.1

psampst.odf - 120.50.12000000.12 for R12 & 120.52.12010000.11 for 12.1

Expense PO can be received without this error in encumbrance enabled environment

5 12 & 12.1 Users are able to change or assign the pre-seeded sources to the event class for the application Cost Management where as other applications such as Purchasing,Payables do not allow changing the pre-seeded sources

<Bug.9006973>

CANNOT ADD AN EXISTING SOURCE TO AN EXISTING EVENT CLASS

The application_type_code in xla_subledgers for the application 707 is incorrectly seeded

<Patch.9006973:R12.BOM.A> for R12 & <Patch.9292380:R12.BOM.C> for 12.1

cstxlaaad.ldt - 120.0.12000000.17 cstxlaemseed.ldt - 120.0.12000000.17 for R12 & cstxlaemseed.ldt - 120.5.12010000.12 for 12.1

It is not possible to change or assign the pre-seeded sources to the event class for the application Cost Management

6 12.1 While attempting to save a receipt against a PO which is set to accrue at receipt, the following error occurs / Receiving Transaction Processor completes with the following error for a receipt against a PO which is set to accrue at receipt
ERROR: RVTTH-448: Subroutine User-Defined Exception in Package CST_XLA_PVT Procedure
Create_RCVXLAEventStatement -300: : SQL Error: User-Defined Exception returned error
<Bug.8872296> CST XLA EM SEED DATA INCORRECTLY LOADED CAUSING INVALID AADS Code limitation in file cstxlaemseed.ldt <Patch.8872296:R12.BOM.C> cstxlaemseed.ldt - 120.5.12010000.8
cstaadimp.sql - 120.2.12010000.1
cstpostimportaad.sql - 120.2.12010000.1
Receipt against a PO set to accrue at receipt will happen successfully without this error
7 12 & 12.1 In Oracle Cost Management, Create Accounting program might fail with "XLA_AE_HEADER_PKG.SetLineAcctAttrs ORA-06502" if there is event Retroactive Price Adjustment to Delivery

<Bug.8409628>

FP:12.0-12.1:XLAACCUP XLA_AE_HEADER_PKG.SETLINEACCTATTRS ERRORS

For the Event Retroactive Price Adjustment to Delivery has the accounting attribute currency rate type attached to source currency conversion rate so if the rate is more than the varchar2 limit of rate type the create accounting program fails

<Patch.8409628:R12.BOM.A> for R12 & <Patch.8409628:R12.BOM.C> for 12.1

cstxlaaad.ldt - 120.22.12000000.26
cstxlaemseed.ldt - 120.0.12000000.10 for R12 & cstxlaaad.ldt -120.32.12010000.13 cstxlaemseed.ldt 120.5.12010000.6 for 12.1


In Oracle Cost Management, Create Accounting program completes successfully without this error

8 12 & 12.1 Performance issue with Create Accounting process <Bug.8284764>

RCA: R12:CREATE ACCOUNTING PROCESS DOES NOT DROP QUEUE TABLE

When there no events to be processed then in Create Accounting program "accounting_program_batch" procedure raises an exception "normal_termination" where the queues are not being cleandup

<Patch.8284764:R12.XLA.A> for R12 & <Patch.8284764:R12.XLA.B> for 12.1

xlaapeng.pkb - 120.147.12000000.36 for R12 & xlaapeng.pkb - 120.164.12010000.6 for 12.1


Create Accounting program runs with better performance

9 12 Create Accounting Process does not create accounting entries correctly when the PO deliver transaction to Inventory destination is done with a currency different from functional currency in case of average costing. It creates the accounting in functional currency and transaction currency with a different sign. This results in create accounting program erroring out with the exception "The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry line.2- Error number = 0 ; The accounted amount and entered amount for the subledger journal entry line have different sigh for extract line number"

<Bug.7562176>

AVERAGE COSTING:SUBLEDGER JOURNAL ENTRY DOES NOT BALANCE IN THE ENTERED CURRENCY

Code limitation in files CSTACDPB.pls

<Patch.8243112:R12.BOM.A>

CSTACDPB.pls - 120.55.12000000.14

The accounting in both transactional and base currency should follow the same side. The accounting in transactional currency will be balanced

10 12 When attempting to receive "11i POs" in R12 for expense destination items, the following error occurs: rvtptcontrol failed.RVTTH-448: Subroutine User-Defined Exception in Package CST_XLA_PVT Procedure Create_RCVXLAEventStatement -60: Error in Encumbrance Accounting/Budgetory Control

<Bug.7460759>

CREATING RECEIPTS FOR UPGRADED PO'S GET RVTTH-448 ERROR

This issue started due to the recent SLA enhancement 7193986.Because of this enhancement it is required to clean XLA GTs between multiple calls to XLA api. As PSA is cleaning only few XLA GTs, this issue was raised

<Patch.7460759:R12.PSA.A>

psavbcxb.pls - 120.31.12000000.7

Expense PO receipts happen in encumbrance enabled environment without this error

11 12 & 12.1 Create accounting output was not coming up for high volume of data

<Bug.7341297>

UNABLE TO VIEW CREATE ACCOUNTING XML OUTPUT.

The reference of P_LEDGER_NAME in the template XLAACCPB00.rtf is not efficient

<Patch.7341297:R12.XLA.A> for R12 & <Patch.8295104:R12.XLA.B> for 12.1

XLAACCPB00.rtf - 120.3.12000000.8 for R12 & XLAACCPB00.rtf - 120.10.12010000.10


Create Accounting will show the correct output even if the volume of data is high

12 12 Create Accounting Process does not create accounting entries correctly for logical IC shipment transaction for Expense PO receipts in Global Procurement scenario. It creates only the PO charge a/c CR line without creating the IC COGS a/c DR line. This results in create accounting program erroring out with the exception "The subledger journal entry does not balance in the entered currency".

<Bug.7293052>

CREATE ACCOUNTING CREATES ONE-SIDED ENTRIES FOR LOGICAL INTERCOMPANY TXNS

The logical sales issue to expense destination accounting entry is missing in Cost setup

<Patch.7293052:R12.BOM.A>

cstxlaaad.ldt - 120.22.12000000.19

Create Accounting process creates the accounting entries correctly for Expense PO receipts in Global Procurement scenario

13 R12 Create Accounting - Receiving program completes with
the following error:
ERROR: *** glibc detected *** double free or corruption (out): 0x00b998a0 ***
This issue happens when RDBMS is on version 10.2.0.3 or has been upgraded to version 10.2.0.3.
(Run the following to check RDBMS version:
SELECT instance_name, version FROM v$instance;)
<Bug.7172985> R12:ACCOUNTING PROGRAM ENDED WITH GLIBC DETECTED DOUBLE FREE OR CORRUPTION The cause of this issue is database coredump. It is determined by the following error seen in the raw trace of the Accounting Program concurrent program:
[...]
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1871af5, expCheckExprEquiv()+5015]
*** 2008-06-20 23:31:09.278
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [expCheckExprEquiv()+5015] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
INSERT INTO XLA_DIAG_SOURCES ( EVENT_ID , LEDGER_ID , SLA_LEDGER_ID , DESCRIPTION_LANGUAGE , OBJECT_NAME , OBJECT_TYPE_CODE , LINE_NUMBER ,
[...]
<Patch.5889331> - This is a DB patch applicable for RDBMS version 10.2.0.3 N/A Create Accounting-Receiving program will not error out with this problem
14 12 & 12.1 Accounting Program for Create Accounting could not successfully save the entry for technical reasons. ORA-00001: unique constraint (XLA.XLA_AE_LINES_GT_U1) violated

<Bug.6997731>

XLAACCUP: ORA-00001: UNIQUE CONSTRAINT (XLA.XLA_AE_LINES_GT_U1) VIOLATED

This issue can be resolved by adding event_id to index xla_Ae_lines_gt_u1

<Patch.6997731:R12.XLA.A> for R12 & <Patch.6997731:R12.XLA.B> for R12.1 (controlled release)

xla_ae_lines_gt.xdf - 120.19.12000000.9 for R12 & xla_ae_lines_gt.xdf 120.22.12010000.3 for 12.1

Accounting program can be completed successfully

15 12 This patch consolidates critical fixes released by SLA product team over R12, RUP2,3,4 and one-offs after RUP4. Fixes include
- Create Accounting & GL transfer issues identified after R12.RUP2
- Create Accounting Engine and SLA report's performance issues
- Open Account Balances program changes (used by Trial Balance)
- Period Close performance issues



<Bug.6826219>

R12 : SLA CONSOLIDATED CRITICAL FIXES AS OF FEB 19, 2008

Consolidated fix

<Patch.6826219:R12.XLA.A>

Consolidated fix fixing many file versions

R12 SLA critical patch fixing many issues related to create accounting and GL transfer

16 12 When attempting to receive "11i POs" in R12 for expense destination items, the following error occurs: rvtptcontrol failed.RVTTH-448: Subroutine User-Defined Exception in Package CST_XLA_PVT Procedure Create_RCVXLAEventStatement -60: Error in Encumbrance Accounting/Budgetory Control

<Bug.6754295>

GETTING ERROR WHILE SAVING RECEIPT OF EXPENSE PO'S

The view PSA_CST_XLA_UPG_V was checking receiving inventory org instead of PO operating unit

<Patch.6754295:R12.PSA.A>

psampst.odf - 120.50.12000000.3

Expense PO receipts happen in encumbrance enabled environment without this error

Contacts

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
Details
Actions
Contacts
References

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