PACODTBC: PRC: Distribute Total Burden Cost Errors When Distributing Cost That Where Adjusted From Non Capital To Capital (Doc ID 2576917.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

For specific projects, after an expenditure has been adjusted from Non Capital to Capital, when running PRC: Distribute Total Burdened Costs, the transactions fail with the following errors in the Burden Cost Exception Report

Employee                  Expnd Type                  Item Date   Project Num               Task Num            Qty              Rejection Reason
------------------------------------------------------------------------------------------------------------------------------------
Expnd Class : Supplier Invoice
<EMPLOYEE NAME>   <EXPENDITURE TYPE>   31-MAY-19   <PROJECT NUMBER> <TASK NUMBER> 83,203.25   AA_NULL_CCID
<EMPLOYEE NAME>   <EXPENDITURE TYPE>   30-JUN-19    <PROJECT NUMBER> <TASK NUMBER> 21,958.75   KEY_FLEX_FAIL

Rejection Reason Code Rejection Reason
KEY_FLEX_FAIL             Invalid Accounting Flexfield
AA_NULL_CCID            AutoAccounting error: null ccid

The log file contains the following error;

Entering paacaf()
Current system time is 24-JUN-2019 05:00:21
APP-FND-01564: ORACLE error 12899 in FDFICD

Cause: FDFICD failed due to ORA-12899: value too large for column "GL"."GL_CODE_COMBINATIONS"."ACCOUNT_TYPE" (actual: 5, maximum: 1).

The SQL statement being executed at the time of the error was: INSERT INTO GL_CODE_COMBINATIONS(ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, CHART_OF_ACCOUNTS_ID, CODE_COMBINATION_ID) VALUES ('Y', :sumflg, to_date(:sdate, 'J'), to_date(:edate, 'J'), SYSDATE, :user_id, :SEGMENT1, :SEGMENT2, :SEGMENT3, :SEGMENT4, :SEGMENT5, :SEGMENT6, :SEGMENT7, :SEGMENT8, :SEGMENT9, :ACCOUNT_TYPE, :REFERENCE3, :JGZZ_RECON_FLAG, :DETAIL_BUDGETING_ALLOWED_FLAG, :DETAIL_POSTING_ALLOWED_FLAG, :CHART_OF_ACCOUNTS_ID, :CODE_COMBINATION_ID) and was executed from the file &ERRFILE.
paacaf-E: Failed to validate flexfield

paafui-E: Error calling paacaf

Code of KEY_FLEX_FAIL Reason Invalid Accounting Flexfield 
Code of AA_NULL_CCID Reason AutoAccounting error: null ccid

Changes

Cause

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