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 Go to next message
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
Re: PRC: Transaction Import run Error [message #586423 is a reply to message #586421] Thu, 06 June 2013 04:10 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle

ORA-06508: PL/SQL: could not find program unit being called

Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.

Re: PRC: Transaction Import run Error [message #586425 is a reply to message #586423] Thu, 06 June 2013 04:13 Go to previous message
flash10113
Messages: 2
Registered: June 2013
Junior Member
PRC: Transaction Import is the system concurrent request, How can i fix it?

[Updated on: Thu, 06 June 2013 04:14]

Report message to a moderator

Previous Topic: ACTIVE DIRECTORY INTEGRATION WITH EBS
Next Topic: Form Folders help
Goto Forum:
  


Current Time: Thu Mar 28 20:43:13 CDT 2024