oracle ebs 成本表,Oracle EBS 成本请求报错

-- step1 根据参数查找 是否有死循环的数据

SELECT *

FROM cst_pac_quantity_layers cpql

WHERE pac_period_id = 13013 --pac_period_id

AND cost_group_id = 1201 --cost_group_id

AND NOT EXISTS

(SELECT 1

FROM cst_pac_item_costs cpic

WHERE cpic.cost_layer_id = cpql.cost_layer_id

AND pac_period_id = cpql.pac_period_id

AND cost_group_id = cpql.cost_group_id

AND inventory_item_id = cpql.inventory_item_id);

-- step2 备份如下表的数据

-- 注意 表后面加日期 不重名

CREATE TABLE CPQL_BKP_180607 AS

SELECT * FROM CST_PAC_QUANTITY_LAYERS

WHERE PAC_PERIOD_ID = 13013 --pac_period_id

AND COST_GROUP_ID = 1201 --cost_group_id

;

CREATE TABLE CPICD_BKP_180607 AS

SELECT * FROM CST_PAC_ITEM_COST_DETAILS

WHERE COST_LAYER_ID IN (SELECT COST_LAYER_ID

FROM CST_PAC_ITEM_COSTS

WHERE PAC_P