Distribute Usage And Miscellaneous Costs Error ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT") (Doc ID 2410140.1)

Last updated on JUNE 06, 2023

Applies to:

Symptoms

PASDUC: PRC: Distribute Usage and Miscellaneous Costs
Distribute Usage and Miscellaneous Costs request failing / Program was terminated by signal 6
Error seen in log file

ERROR
  pagsvl: Segment Value: F400103
  val [5100001], segval [F400103]
  pacgud:EB Profile Option is NOT SET.
  pacgud: Error inserting cost distribution lines for New Eis

  pacgud: ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT")

Run the following query to identify data corruption

select ei.expenditure_item_id,ei.denom_raw_cost
, ei.acct_raw_cost
, ei.raw_cost_rate
, ei.denom_burdened_cost
, ei.raw_cost
, ei.acct_burdened_cost
, ei.burden_cost_rate
, ei.burden_cost
, ei.project_raw_cost
, ei.project_burdened_cost
from pa_expenditure_items_all ei, pa_transaction_sources txs
where
ei.Cost_Distributed_Flag = 'N'
AND ei.transaction_source = txs.transaction_source(+)
AND ei.system_linkage_function <> 'BTC'
AND
( ei.denom_raw_cost <> decode( nvl( txs.costed_flag, 'N' ), 'N', NULL, ei.denom_raw_cost )
OR ei.acct_raw_cost <> decode( nvl(txs.gl_accounted_flag,'N'), 'N', NULL, ei.acct_raw_cost )
OR ei.raw_cost_rate <> decode( nvl( txs.costed_flag, 'N' ), 'N',NULL, ei.raw_cost_rate )
OR ei.denom_burdened_cost <> decode( nvl(txs.allow_burden_flag, 'N'), 'N',NULL,ei.denom_burdened_cost )
OR ei.raw_cost is not NULL
OR ei.acct_burdened_cost is not NULL
OR ei.burden_cost_rate is not NULL
OR ei.burden_cost is not NULL
OR ei.project_raw_cost is not NULL
OR ei.project_burdened_cost is not NULL )
order by ei.expenditure_id, ei.expenditure_item_id;

Cause

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