PALDLC - PRC: Distribute Labor Costs fails with ORA-1403 & ORA-6508 in Calc_Raw_Cost Extension (Doc ID 460849.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE: PALDLC - PRC: Distribute Labor Costs


Symptoms

PALDLC - PRC: Distribute Labor Costs  fails with following message:

palccc: Preparing to Call Raw Cost Extension
Calling Extn for eiid [4181813] sys link[ST]
Oracle error occurred in Calc_Raw_Cost extension
Expenditure item id: [4181813], status: [-6508]
ORA-01403: No Data Found.

Expenditure item id: [4181813], status: [-6508]
palcei: palccc() returned error
palcei() returned error while processing expenditure items

01:20:38: get_orgn_level_costing_info: Start
01:20:38: get_orgn_level_costing_info: org_id [1374] organization_id [1903]
01:20:38: get_orgn_level_costing_info: opening assignment
01:20:38: get_orgn_level_costing_info: fetching assignment
01:20:38: get_orgn_level_costing_info: assignment not found for organization
01:20:38: get_orgn_level_costing_info: Getting OU level assignment for [1374]
01:20:38: get_orgn_level_costing_info: assignment not found at the OU level !!!!!!
01:20:38: get_orgn_level_costing_info: l_org_labor_sch_rule_id [] l_rate_sch_id [] l_costing_rule
[] l_ot_project_id [] l_ot_task_id [] l_acct_rate_date_code [] l_acct_rate_type []
l_acct_exch_rate [] x_err_code [NO_RATE]
01:20:38: get_orgn_level_costing_info: Closing Cursor
01:20:38: get_orgn_level_costing_info: END

Cause

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