Oracle Applications: Account Generator *** LONG MESSAGE ***
From: Dons <m.v.vandonselaar_at_donotspam.kpn.com>
Date: Wed, 25 Oct 2000 18:36:55 +0200
Message-ID: <o22evscae1dg5gc4nnfqero3t2jpiqgg5j_at_4ax.com>
x_accrual_account_id IN OUT NUMBER,
x_variance_account_id IN OUT NUMBER,
line_att14 VARCHAR2(150) := NULL;
line_att15 VARCHAR2(150) := NULL;
line_att14 := null;
line_att15 := null;
RETURN(x_success);
'Wf_Item_Activity_Status.Set_Error(error_p rocess)' is not permitted in synchronous processes. ca failed
ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' is not
permitted in synchronous processes.
Date: Wed, 25 Oct 2000 18:36:55 +0200
Message-ID: <o22evscae1dg5gc4nnfqero3t2jpiqgg5j_at_4ax.com>
Hi all,
I'm trying to start a account generating process from an SQL-script but I'm encountering problems doing this. Maybe I need to make some preperations before starting the proccess? Is it even possible to invoke a account generating procces from sqlscripts?
Here's some info on what I'm trying to do:
- My script to invoke the AG is like this:
create or replace function test_build_accounts (
x_coa_id NUMBER, x_bom_resource_id NUMBER, x_bom_cost_element_id NUMBER, x_category_id NUMBER, x_destination_type_code VARCHAR2, x_deliver_to_location_id NUMBER, x_destination_organization_id NUMBER, x_destination_subinventory VARCHAR2, x_expenditure_type VARCHAR2, x_req_encumbrance_flag VARCHAR2, x_expenditure_organization_id NUMBER, x_expenditure_item_date DATE, x_item_id NUMBER, x_line_type_id NUMBER, x_result_billable_flag VARCHAR2, x_preparer_id NUMBER, x_project_id NUMBER, x_document_type_code VARCHAR2, x_blanket_po_header_id NUMBER, x_source_type_code VARCHAR2, x_source_organization_id NUMBER, x_source_subinventory VARCHAR2, x_task_id NUMBER, x_deliver_to_person_id NUMBER, x_type_lookup_code VARCHAR2, x_suggested_vendor_id NUMBER, x_wip_entity_id NUMBER, x_wip_entity_type VARCHAR2, x_wip_line_id NUMBER, x_wip_repetitive_schedule_id NUMBER, x_wip_operation_seq_num NUMBER, x_wip_resource_seq_num NUMBER, x_po_encumberance_flag VARCHAR2, x_gl_encumbered_date DATE, x_code_combination_id IN OUT NUMBER, x_budget_account_id IN OUT NUMBER,
x_accrual_account_id IN OUT NUMBER,
x_variance_account_id IN OUT NUMBER,
block_name VARCHAR2, caller VARCHAR2, l_melding out varchar2)
RETURN BOOLEAN IS x_account_string VARCHAR2(13000);
x_charge_success BOOLEAN := TRUE; x_budget_success BOOLEAN := TRUE; x_accrual_success BOOLEAN := TRUE; x_variance_success BOOLEAN := TRUE;
- Bug 752384: increase the flexfield size to 2000.
x_charge_account_desc VARCHAR2(2000); x_budget_account_desc VARCHAR2(2000); x_accrual_account_desc VARCHAR2(2000); x_variance_account_desc VARCHAR2(2000); x_charge_account_flex VARCHAR2(2000); x_budget_account_flex VARCHAR2(2000);x_accrual_account_flex VARCHAR2(2000); x_variance_account_flex VARCHAR2(2000);
x_charge_field_name VARCHAR2(60);
x_budget_field_name VARCHAR2(60);
x_accrual_field_name VARCHAR2(60);
x_variance_field_name VARCHAR2(60);
x_progress VARCHAR2(3) := NULL;
x_new_ccid NUMBER;
x_ccid_returned BOOLEAN := TRUE;
x_encumbrance_flag VARCHAR2(4);
- new variables from build function
header_att1 VARCHAR2(150) := NULL; header_att2 VARCHAR2(150) := NULL; header_att3 VARCHAR2(150) := NULL; header_att4 VARCHAR2(150) := NULL; header_att5 VARCHAR2(150) := NULL; header_att6 VARCHAR2(150) := NULL; header_att7 VARCHAR2(150) := NULL; header_att8 VARCHAR2(150) := NULL; header_att9 VARCHAR2(150) := NULL; header_att10 VARCHAR2(150) := NULL; header_att11 VARCHAR2(150) := NULL; header_att12 VARCHAR2(150) := NULL; header_att13 VARCHAR2(150) := NULL; header_att14 VARCHAR2(150) := NULL; header_att15 VARCHAR2(150) := NULL; line_att1 VARCHAR2(150) := NULL; line_att2 VARCHAR2(150) := NULL; line_att3 VARCHAR2(150) := NULL; line_att4 VARCHAR2(150) := NULL; line_att5 VARCHAR2(150) := NULL; line_att6 VARCHAR2(150) := NULL; line_att7 VARCHAR2(150) := NULL; line_att8 VARCHAR2(150) := NULL; line_att9 VARCHAR2(150) := NULL; line_att10 VARCHAR2(150) := NULL; line_att11 VARCHAR2(150) := NULL; line_att12 VARCHAR2(150) := NULL; line_att13 VARCHAR2(150) := NULL;
line_att14 VARCHAR2(150) := NULL;
line_att15 VARCHAR2(150) := NULL;
distribution_att1 VARCHAR2(150) := null; distribution_att2 VARCHAR2(150) := null; distribution_att3 VARCHAR2(150) := null; distribution_att4 VARCHAR2(150) := null; distribution_att5 VARCHAR2(150) := null; distribution_att6 VARCHAR2(150) := null; distribution_att7 VARCHAR2(150) := null; distribution_att8 VARCHAR2(150) := null; distribution_att9 VARCHAR2(150) := null; distribution_att10 VARCHAR2(150) := null; distribution_att11 VARCHAR2(150) := null; distribution_att12 VARCHAR2(150) := null; distribution_att13 VARCHAR2(150) := null; distribution_att14 VARCHAR2(150) := null; distribution_att15 VARCHAR2(150) := null;
FB_ERROR_MSG VARCHAR2(2000);
x_header_name VARCHAR2(20); x_success BOOLEAN; x_acc_field_name VARCHAR2(60); x_concat_segs VARCHAR2(240); x_concat_desc VARCHAR2(2000); wf_itemkey VARCHAR2(80) := NULL; x_ccid_passed_in BOOLEAN := FALSE; x_new_ccid_generated BOOLEAN := FALSE; debug BOOLEAN := FALSE;
BEGIN x_progress := '001';
x_header_name := 'PO_REQ_HDR';
header_att1 := null; header_att2 := null; header_att3 := null; header_att4 := null; header_att5 := null; header_att6 := null; header_att7 := null; header_att8 := null; header_att9 := null; header_att10 := null; header_att11 := null; header_att12 := null; header_att13 := null; header_att14 := null; header_att15 := null; line_att1 := null; line_att2 := null; line_att3 := null; line_att4 := null; line_att5 := null; line_att6 := null; line_att7 := null; line_att8 := null; line_att9 := null; line_att10 := null; line_att11 := null; line_att12 := null; line_att13 := null;
line_att14 := null;
line_att15 := null;
APPS.PO_REQ_WF_BUILD_ACCOUNT_INIT.debug_on;
APPS.PO_WF_PO_CHARGE_ACC.debug_on;
x_success := APPS.PO_REQ_WF_BUILD_ACCOUNT_INIT.Start_Workflow (
x_charge_success,
x_budget_success,
x_accrual_success,
x_variance_success,
x_code_combination_id,
x_budget_account_id,
x_accrual_account_id,
x_variance_account_id,
x_charge_account_flex,
x_budget_account_flex,
x_accrual_account_flex,
x_variance_account_flex,
x_charge_account_desc,
x_budget_account_desc,
x_accrual_account_desc,
x_variance_account_desc,
x_coa_id,
x_bom_resource_id,
x_bom_cost_element_id,
x_category_id,
'EXPENSE',--x_destination_type_code,
x_deliver_to_location_id,
x_destination_organization_id,
x_destination_subinventory,
'PUVT_Computers',--x_expenditure_type,
x_expenditure_organization_id,
x_expenditure_item_date,
x_item_id ,
x_line_type_id,
x_result_billable_flag,
x_preparer_id,
28, --x_project_id,
x_document_type_code,
x_blanket_po_header_id,
x_source_type_code,
208, --x_source_organization_id,
x_source_subinventory,
55,--x_task_id,
x_deliver_to_person_id,
x_type_lookup_code,
x_suggested_vendor_id,
x_wip_entity_id,
x_wip_entity_type,
x_wip_line_id,
x_wip_repetitive_schedule_id,
x_wip_operation_seq_num,
x_wip_resource_seq_num,
'Y',--x_encumbrance_flag,
x_gl_encumbered_date,
wf_itemkey,
x_new_ccid_generated,
header_att1,
header_att2,
header_att3,
header_att4,
header_att5,
header_att6,
header_att7,
header_att8,
header_att9,
header_att10,
header_att11,
header_att12,
header_att13,
header_att14,
header_att15,
line_att1,
line_att2,
line_att3,
line_att4,
line_att5,
line_att6,
line_att7,
line_att8,
line_att9,
line_att10,
line_att11,
line_att12,
line_att13,
line_att14,
line_att15,
distribution_att1,
distribution_att2,
distribution_att3,
distribution_att4,
distribution_att5,
distribution_att6,
distribution_att7,
distribution_att8,
distribution_att9,
distribution_att10,
distribution_att11,
distribution_att12,
distribution_att13,
distribution_att14,
distribution_att15,
FB_ERROR_MSG );
l_melding := FB_ERROR_MSG;
RETURN(x_success);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('test:'||sqlerrm);
END test_build_accounts;
/
****The Error Stack I get is like this:
Account Generator failed in FND_FLEX_WORKFLOW.GENERATE_PARTIAL with
followi
ng error.
ERROR_NAME : WFENG_SYNCH_DISABLED
ERROR_MESSAGE : 3135:
'Wf_Item_Activity_Status.Set_Error(error_process)' is
not permitted in synchronous processes.
ERROR_STACK :
Wf_Item_Activity_Status.Set_Error(POWFRQAG, #SYNCH, 15658) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 15658, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 15658, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 15663, LT) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 15663, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 15663, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 15662, #NULL) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 15662, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 15662, 999999) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13543, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 13546, EXPENSE) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 13546, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13546, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 13551, #NULL) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 13551, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13551, 999999) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13507, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 13504, NULL) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 13504, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13504, 999999) Wf_Engine_Util.Complete_Activity(POWFRQAG, #SYNCH, 13515, #NULL) Wf_Engine_Util.Execute_Activity(POWFRQAG, #SYNCH, 13515, RUN) Wf_Engine_Util.Process_Activity(POWFRQAG, #SYNCH, 13515, 999999) Wf_Engine.StartProcess(POWFRQAG, #SYNCH) FND_FLEX_WORKFLOW.GENERATE_PARTIAL(POWFRQAG, #SYNCH) SQLERRM : ORA-20002: 3135:
'Wf_Item_Activity_Status.Set_Error(error_p rocess)' is not permitted in synchronous processes. ca failed
ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' is not
permitted in synchronous processes.
Hopefully there are any oa-experts out there wo can help me out.
See ya'll
Martin Received on Wed Oct 25 2000 - 18:36:55 CEST