Home » Applications » Oracle Fusion Apps & E-Business Suite » PRC: Transaction Import run Error (E-Business Suite 11i (11.5.10))
| PRC: Transaction Import run Error [message #586421] |
Thu, 06 June 2013 04:01  |
 |
flash10113
Messages: 2
Registered: June 2013
|
Junior Member |
|
|
I am try to using interface to import Expenditure Item, after insert value and run PRC: Transaction Import then error, below is my script:
create or replace procedure create_expenditure_item is
v_transaction_source varchar2(20);
v_expenditure_type varchar2(50);
v_project_number varchar2(300);
v_task_number varchar2(40);
v_quantity number;
v_burdened_cost number;
V_DR_CODE_COMBINATION_ID number;
V_CR_CODE_COMBINATION_ID number;
p_org_id number := 106;
begin
--get transaction source
begin
select s.transaction_source
into v_transaction_source
from PA_TRANSACTION_SOURCES s
where s.transaction_source = 'Inventory';
exception
when others then
fnd_file.PUT_LINE(fnd_file.OUTPUT,
'can not find transaction source ' ||
v_transaction_source);
end;
v_expenditure_type := null;
begin
select pet.expenditure_type
into v_expenditure_type
from pa_expenditure_types pet
where pet.expenditure_type = 'Overhead-Material Cost';
exception
when others then
fnd_file.PUT_LINE(fnd_file.OUTPUT,
'can not find expenditure type ' ||
'Overhead-Material Cost');
end;
v_project_number := null;
begin
select pa.segment1
into v_project_number
from pa_projects_all pa
where pa.segment1 = '023-2011/PVDL-QBS';
exception
when others then
fnd_file.PUT_LINE(fnd_file.OUTPUT,
'can not find project number ' ||
'023-2011/PVDL-QBS');
end;
v_task_number := null;
begin
select pt.task_number
into v_task_number
from pa_tasks pt
where pt.task_number = '1';
exception
when others then
fnd_file.PUT_LINE(fnd_file.OUTPUT, 'can not find task ' || '1');
end;
v_quantity := 10;
v_burdened_cost := 100000;
insert into PA_TRANSACTION_INTERFACE_ALL
(BATCH_NAME,
ORIG_TRANSACTION_REFERENCE,
transaction_source,
expenditure_item_date,
EXPENDITURE_ENDING_DATE,
project_number,
task_number,
expenditure_type,
quantity,
org_id,
burdened_cost,
TRANSACTION_STATUS_CODE,
EXPENDITURE_COMMENT,
GL_DATE,
DR_CODE_COMBINATION_ID,
CR_CODE_COMBINATION_ID)
values
('chien',
'CHIEN',
v_transaction_source, --transaction_source
sysdate + 10,
sysdate, --expenditure_item_date
v_project_number, --project_number
v_task_number, --task_number
v_expenditure_type,
v_quantity, --quantity
p_org_id, --org_id
v_burdened_cost,
'P',
'EXPENDITURE_COMMENT ', --EXPENDITURE_COMMENT
SYSDATE, --GL_DATE
V_DR_CODE_COMBINATION_ID,
V_CR_CODE_COMBINATION_ID);
commit;
end;
Run PRC: Transaction Import, the status of request is error and view log as below:
MSG-20003: ORA-20003: import1_prog:ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPS.PA_TRX_IMPORT", line 7779
Please give me an advice. thanks
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Dec 04 02:24:17 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
