Home > Default > Unable to Create Quotations in Oracle Apps with named PL/SQL Block

Unable to Create Quotations in Oracle Apps with named PL/SQL Block

October 11Hits:0
Advertisement
Dear All,
I got struced while creating Qotations from the backend using oracle API in a Procedure.But the same API working fine in Anonymous block and creating Qutations in apps.But the in parameters are same in anonymous and named bolck.i have done Debugging also and its returning in parameter values.but quotations not created in apps.
I am sending the both scripts(named plsql and anonymous blocks) please anybody knows about this correct me where iam doing mistake.
*******anonymous bolck*********
DECLARE
X_ROWID VARCHAR2(200) :=NULL;
X_PO_HEADER_ID NUMBER :=NULL;
X_AGENT_ID NUMBER :=25;
X_TYPE_LOOKUP_CODE VARCHAR2(200) :='QUOTATION';
X_LAST_UPDATE_DATE DATE :=SYSDATE;
X_LAST_UPDATED_BY NUMBER :=1318;
X_SEGMENT1 VARCHAR2(200) :=2477;
X_SUMMARY_FLAG VARCHAR2(200) :='N';
X_ENABLED_FLAG VARCHAR2(200) :='Y';
X_SEGMENT2 VARCHAR2(200);
X_SEGMENT3 VARCHAR2(200);
X_SEGMENT4 VARCHAR2(200);
X_SEGMENT5 VARCHAR2(200);
X_START_DATE_ACTIVE DATE;
X_END_DATE_ACTIVE DATE;
X_LAST_UPDATE_LOGIN NUMBER :=45786;
X_CREATION_DATE DATE :=SYSDATE;
X_CREATED_BY NUMBER :=1318;
X_VENDOR_ID NUMBER :=5;
X_VENDOR_SITE_ID NUMBER :=6;
X_VENDOR_CONTACT_ID NUMBER :=181;
X_SHIP_TO_LOCATION_ID NUMBER :=204;
X_BILL_TO_LOCATION_ID NUMBER :=207;
X_TERMS_ID NUMBER :=10013;
X_SHIP_VIA_LOOKUP_CODE VARCHAR2(200) :='UPS';
X_FOB_LOOKUP_CODE VARCHAR2(200) :='Origin';
X_PAY_ON_CODE VARCHAR2(200);
X_FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(200) :='Due';
X_STATUS_LOOKUP_CODE VARCHAR2(200) :='A';
X_CURRENCY_CODE VARCHAR2(200) :='USD';
X_RATE_TYPE VARCHAR2(200);
X_RATE_DATE DATE;
X_RATE NUMBER;
X_FROM_HEADER_ID NUMBER;
X_FROM_TYPE_LOOKUP_CODE VARCHAR2(200);
X_START_DATE DATE;
X_END_DATE DATE;
X_BLANKET_TOTAL_AMOUNT NUMBER;
X_AUTHORIZATION_STATUS VARCHAR2(200);
X_REVISION_NUM NUMBER;
X_REVISED_DATE DATE;
X_APPROVED_FLAG VARCHAR2(200);
X_APPROVED_DATE DATE;
X_AMOUNT_LIMIT NUMBER;
X_MIN_RELEASE_AMOUNT NUMBER;
X_NOTE_TO_AUTHORIZER VARCHAR2(200);
X_NOTE_TO_VENDOR VARCHAR2(200);
X_NOTE_TO_RECEIVER VARCHAR2(200);
X_PRINT_COUNT NUMBER;
X_PRINTED_DATE DATE;
X_VENDOR_ORDER_NUM VARCHAR2(200);
X_CONFIRMING_ORDER_FLAG VARCHAR2(200);
X_COMMENTS VARCHAR2(200);
X_REPLY_DATE DATE;
X_REPLY_METHOD_LOOKUP_CODE VARCHAR2(200);
X_RFQ_CLOSE_DATE DATE;
X_QUOTE_TYPE_LOOKUP_CODE VARCHAR2(200) :='CATALOG';
X_QUOTATION_CLASS_CODE VARCHAR2(200) :='CATALOG';
X_QUOTE_WARNING_DELAY_UNIT VARCHAR2(200);
X_QUOTE_WARNING_DELAY NUMBER :=7;
X_QUOTE_VENDOR_QUOTE_NUMBER VARCHAR2(200);
X_ACCEPTANCE_REQUIRED_FLAG VARCHAR2(200);
X_ACCEPTANCE_DUE_DATE DATE;
X_CLOSED_DATE DATE;
X_USER_HOLD_FLAG VARCHAR2(200);
X_APPROVAL_REQUIRED_FLAG VARCHAR2(200);
X_CANCEL_FLAG VARCHAR2(200);
X_FIRM_STATUS_LOOKUP_CODE VARCHAR2(200);
X_FIRM_DATE DATE;
X_FROZEN_FLAG VARCHAR2(200);
X_SUPPLY_AGREEMENT_FLAG VARCHAR2(200) :='L';
X_GLOBAL_AGREEMENT_FLAG VARCHAR2(200);
X_ATTRIBUTE_CATEGORY VARCHAR2(200);
X_ATTRIBUTE1 VARCHAR2(200);
X_ATTRIBUTE2 VARCHAR2(200);
X_ATTRIBUTE3 VARCHAR2(200);
X_ATTRIBUTE4 VARCHAR2(200);
X_ATTRIBUTE5 VARCHAR2(200);
X_ATTRIBUTE6 VARCHAR2(200);
X_ATTRIBUTE7 VARCHAR2(200);
X_ATTRIBUTE8 VARCHAR2(200);
X_ATTRIBUTE9 VARCHAR2(200);
X_ATTRIBUTE10 VARCHAR2(200);
X_ATTRIBUTE11 VARCHAR2(200);
X_ATTRIBUTE12 VARCHAR2(200);
X_ATTRIBUTE13 VARCHAR2(200);
X_ATTRIBUTE14 VARCHAR2(200);
X_ATTRIBUTE15 VARCHAR2(200);
X_CLOSED_CODE VARCHAR2(200);
X_USSGL_TRANSACTION_CODE VARCHAR2(200);
X_GOVERNMENT_CONTEXT VARCHAR2(200);
X_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(200);
X_GLOBAL_ATTRIBUTE1 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE2 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE3 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE4 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE5 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE6 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE7 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE8 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE9 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE10 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE11 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE12 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE13 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE14 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE15 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE16 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE17 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE18 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE19 VARCHAR2(200);
X_GLOBAL_ATTRIBUTE20 VARCHAR2(200);
X_MANUAL BOOLEAN;
X_PRICE_UPDATE_TOLERANCE NUMBER;
P_SHIPPING_CONTROL VARCHAR2(200);
P_ENCUMBRANCE_REQUIRED_FLAG VARCHAR2(200);
BEGIN
APPS.PO_HEADERS_SV11.INSERT_PO(X_ROWID ,
X_PO_HEADER_ID ,
X_AGENT_ID ,
X_TYPE_LOOKUP_CODE ,
X_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY ,
X_SEGMENT1 ,
X_SUMMARY_FLAG ,
X_ENABLED_FLAG ,
X_SEGMENT2 ,
X_SEGMENT3 ,
X_SEGMENT4 ,
X_SEGMENT5 ,
X_START_DATE_ACTIVE ,
X_END_DATE_ACTIVE ,
X_LAST_UPDATE_LOGIN ,
X_CREATION_DATE ,
X_CREATED_BY ,
X_VENDOR_ID ,
X_VENDOR_SITE_ID ,
X_VENDOR_CONTACT_ID ,
X_SHIP_TO_LOCATION_ID ,
X_BILL_TO_LOCATION_ID ,
X_TERMS_ID ,
X_SHIP_VIA_LOOKUP_CODE ,
X_FOB_LOOKUP_CODE ,
X_PAY_ON_CODE ,
X_FREIGHT_TERMS_LOOKUP_CODE ,
X_STATUS_LOOKUP_CODE ,
X_CURRENCY_CODE ,
X_RATE_TYPE ,
X_RATE_DATE ,
X_RATE ,
X_FROM_HEADER_ID ,
X_FROM_TYPE_LOOKUP_CODE ,
X_START_DATE ,
X_END_DATE ,
X_BLANKET_TOTAL_AMOUNT ,
X_AUTHORIZATION_STATUS ,
X_REVISION_NUM ,
X_REVISED_DATE ,
X_APPROVED_FLAG ,
X_APPROVED_DATE ,
X_AMOUNT_LIMIT ,
X_MIN_RELEASE_AMOUNT ,
X_NOTE_TO_AUTHORIZER ,
X_NOTE_TO_VENDOR ,
X_NOTE_TO_RECEIVER ,
X_PRINT_COUNT ,
X_PRINTED_DATE ,
X_VENDOR_ORDER_NUM ,
X_CONFIRMING_ORDER_FLAG ,
X_COMMENTS ,
X_REPLY_DATE ,
X_REPLY_METHOD_LOOKUP_CODE ,
X_RFQ_CLOSE_DATE ,
X_QUOTE_TYPE_LOOKUP_CODE ,
X_QUOTATION_CLASS_CODE ,
X_QUOTE_WARNING_DELAY_UNIT ,
X_QUOTE_WARNING_DELAY ,
X_QUOTE_VENDOR_QUOTE_NUMBER ,
X_ACCEPTANCE_REQUIRED_FLAG ,
X_ACCEPTANCE_DUE_DATE ,
X_CLOSED_DATE ,
X_USER_HOLD_FLAG ,
X_APPROVAL_REQUIRED_FLAG ,
X_CANCEL_FLAG ,
X_FIRM_STATUS_LOOKUP_CODE ,
X_FIRM_DATE ,
X_FROZEN_FLAG ,
X_SUPPLY_AGREEMENT_FLAG ,
X_GLOBAL_AGREEMENT_FLAG ,
X_ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 ,
X_ATTRIBUTE2 ,
X_ATTRIBUTE3 ,
X_ATTRIBUTE4 ,
X_ATTRIBUTE5 ,
X_ATTRIBUTE6 ,
X_ATTRIBUTE7 ,
X_ATTRIBUTE8 ,
X_ATTRIBUTE9 ,
X_ATTRIBUTE10 ,
X_ATTRIBUTE11 ,
X_ATTRIBUTE12 ,
X_ATTRIBUTE13 ,
X_ATTRIBUTE14 ,
X_ATTRIBUTE15 ,
X_CLOSED_CODE ,
X_USSGL_TRANSACTION_CODE ,
X_GOVERNMENT_CONTEXT ,
X_GLOBAL_ATTRIBUTE_CATEGORY ,
X_GLOBAL_ATTRIBUTE1 ,
X_GLOBAL_ATTRIBUTE2 ,
X_GLOBAL_ATTRIBUTE3 ,
X_GLOBAL_ATTRIBUTE4 ,
X_GLOBAL_ATTRIBUTE5 ,
X_GLOBAL_ATTRIBUTE6 ,
X_GLOBAL_ATTRIBUTE7 ,
X_GLOBAL_ATTRIBUTE8 ,
X_GLOBAL_ATTRIBUTE9 ,
X_GLOBAL_ATTRIBUTE10 ,
X_GLOBAL_ATTRIBUTE11 ,
X_GLOBAL_ATTRIBUTE12 ,
X_GLOBAL_ATTRIBUTE13 ,
X_GLOBAL_ATTRIBUTE14 ,
X_GLOBAL_ATTRIBUTE15 ,
X_GLOBAL_ATTRIBUTE16 ,
X_GLOBAL_ATTRIBUTE17 ,
X_GLOBAL_ATTRIBUTE18 ,
X_GLOBAL_ATTRIBUTE19 ,
X_GLOBAL_ATTRIBUTE20 ,
X_MANUAL ,
X_PRICE_UPDATE_TOLERANCE ,
P_SHIPPING_CONTROL ,
P_ENCUMBRANCE_REQUIRED_FLAG );
END;
***************************plsql named block****************
CREATE OR REPLACE Procedure p6(p_row_id IN OUT VARCHAR2
,p_po_header_id IN OUT NUMBER
,p_segment1 IN OUT VARCHAR2
,p_Type_Lookup_Code IN VARCHAR2
                         ,p_agent_id IN NUMBER
,p_vendor_id IN NUMBER
,p_vendor_site_id IN NUMBER
,p_Ship_To_Location_Id IN NUMBER
,p_Bill_To_Location_Id IN NUMBER
,p_terms_id IN NUMBER
,p_fob_lookup_code IN VARCHAR2
,p_Freight_Terms_Lookup_Code IN VARCHAR2
,p_Currency_Code IN VARCHAR2
--,p_Start_Date IN DATE
                         ,p_Quote_Type_Lookup_Code IN VARCHAR2
--,p_quote_warning_delay IN VARCHAR2
--,p_Vendor_Quote_Number IN VARCHAR2
,p_last_update_date IN DATE
,p_last_updated_by IN NUMBER
,p_last_update_login IN NUMBER
,p_creation_date IN DATE
,p_created_by IN NUMBER
,p_Ship_Via_Lookup_Code IN varchar2
                         ,p_Vendor_Contact_Id IN NUMBER
--,p_res_ship_via IN VARCHAR2
,p_Comments IN VARCHAR2
,P_Supply_Agreement_Flag IN VARCHAR2
,p_organization_id IN VARCHAR2
--,p_procurement_channel IN VARCHAR2
--,p_Manual IN BOOLEAN
--,p_return_status OUT VARCHAR2
,P_Authorization_Status IN VARCHAR2
                         -- ,p_error_msg OUT VARCHAR2
                    ,p_Summary_Flag in varchar2
                    ,p_Enabled_Flag in varchar2
                    ,p_Status_Lookup_Code in varchar2
                    ,p_Quotation_Class_Code in varchar2
                    ,p_Approval_Required_Flag in varchar2
                    --,X_shipping_control VARCHAR2 -- <INBOUND LOGISTICS FPJ>
--,X_encumbrance_required_flag VARCHAR2
                    ) AS
v_segment1 varchar2(50):=null;
v_po_header_id number:=null;
v_row_id varchar2(50):=null;
BEGIN
po_headers_sv11.insert_po(X_Rowid => v_row_id --VARCHAR2
,X_Po_Header_Id => v_po_header_id --NUMBER
,X_Agent_Id => p_agent_id --NUMBER
,X_Type_Lookup_Code => p_Type_Lookup_Code
,X_Segment1 => v_segment1 --VARCAHR2
,X_Summary_Flag => p_Summary_Flag
,X_Enabled_Flag => p_Enabled_Flag
,X_Vendor_Id => p_vendor_id --NUMBER
,X_Vendor_Site_Id => p_vendor_site_id --NUMBER
,X_Ship_To_Location_Id => p_Ship_To_Location_Id --NUMBER
,X_Bill_To_Location_Id => p_Bill_To_Location_Id --NUMBER
,X_Terms_Id => p_terms_id --NUMBER
,X_Fob_Lookup_Code => p_fob_lookup_code --VARCHAR
,X_Freight_Terms_Lookup_Code => p_Freight_Terms_Lookup_Code --VARCHAR
,X_Status_Lookup_Code => p_Status_Lookup_Code -- Active
,X_Currency_Code => p_Currency_Code --VARCHAR
,X_Start_Date =>NULL--p_start_date --DATE
,X_Reply_Date => NULL--p_Start_Date --DATE
,X_Quote_Type_Lookup_Code => p_Quote_Type_Lookup_Code --VARCHAR
,X_Quotation_Class_Code => p_Quotation_Class_Code
,X_Quote_Warning_Delay => NULL--p_quote_warning_delay --VARCHAR
,X_Quote_Vendor_Quote_Number => NULL--p_Vendor_Quote_Number --VARCHAR
,X_Approval_Required_Flag => p_Approval_Required_Flag
,X_Last_Update_Date => p_last_update_date --DATE
,X_Last_Updated_By => p_last_updated_by --NUMBER
,X_Segment2 => NULL
,X_Segment3 => NULL
,X_Segment4 => NULL
,X_Segment5 => NULL
,X_Start_Date_Active => NULL
,X_End_Date_Active => NULL
,X_Last_Update_Login => p_last_update_login --NUMBER
,X_Creation_Date => p_creation_date --DATE
,X_Created_By => p_created_by --NUMBER
,X_Vendor_Contact_Id => p_vendor_contact_id --NUMBER
,X_Ship_Via_Lookup_Code => p_Ship_Via_Lookup_Code
,X_Pay_On_Code => NULL
,X_Rate_Type => NULL
,X_Rate_Date => NULL
,X_Rate => NULL
,X_From_Header_Id => NULL
,X_From_Type_Lookup_Code => NULL
,X_End_Date => NULL
,X_Blanket_Total_Amount => NULL
,X_Authorization_Status => P_Authorization_Status
,X_Revision_Num => NULL
,X_Revised_Date => NULL
,X_Approved_Flag => NULL
,X_Approved_Date => NULL
,X_Amount_Limit => NULL
,X_Min_Release_Amount => NULL
,X_Note_To_Authorizer => NULL
,X_Note_To_Vendor => NULL
,X_Note_To_Receiver => NULL
,X_Print_Count => NULL
,X_Printed_Date => NULL
,X_Vendor_Order_Num => NULL
,X_Confirming_Order_Flag => NULL
,X_Comments => NULL
,X_Reply_Method_Lookup_Code => NULL
,X_Rfq_Close_Date => NULL
,X_Quote_Warning_Delay_Unit => NULL
,X_Acceptance_Required_Flag => NULL
,X_Acceptance_Due_Date => NULL
,X_Closed_Date => NULL
,X_User_Hold_Flag => NULL
,X_Cancel_Flag => 'N'
,X_Firm_Status_Lookup_Code => NULL
,X_Firm_Date => NULL
,X_Frozen_Flag => NULL
,X_Supply_Agreement_Flag => P_Supply_Agreement_Flag
,X_Global_Agreement_Flag => NULL
,X_Attribute_Category => NULL
,X_Attribute1 => NULL
,X_Attribute2 => NULL
,X_Attribute3 => p_organization_id
,X_Attribute4 => NULL
,X_Attribute5 => NULL
,X_Attribute6 => NULL
,X_Attribute7 => NULL
,X_Attribute8 => NULL
,X_Attribute9 => NULL
,X_Attribute10 => NULL
,X_Attribute11 => NULL
,X_Attribute12 => NULL
,X_Attribute13 => NULL
,X_Attribute14 => NULL
,X_Attribute15 => NULL
,X_Closed_Code => NULL
,X_Ussgl_Transaction_Code => NULL
,X_Government_Context => NULL
,X_Global_Attribute_Category => NULL
,X_Global_Attribute1 => NULL
,X_Global_Attribute2 => NULL
,X_Global_Attribute3 => NULL
,X_Global_Attribute4 => NULL
,X_Global_Attribute5 => NULL
,X_Global_Attribute6 => NULL
,X_Global_Attribute7 => NULL
,X_Global_Attribute8 => NULL
,X_Global_Attribute9 => NULL
,X_Global_Attribute10 => NULL
,X_Global_Attribute11 => NULL
,X_Global_Attribute12 => NULL
,X_Global_Attribute13 => NULL
,X_Global_Attribute14 => NULL
,X_Global_Attribute15 => NULL
,X_Global_Attribute16 => NULL
,X_Global_Attribute17 => NULL
,X_Global_Attribute18 => NULL
,X_Global_Attribute19 => NULL
,X_Global_Attribute20 => NULL
,X_Manual => NULL
,X_Price_Update_Tolerance => NULL
                         ,p_shipping_control=> NULL--X_shipping_control -- <INBOUND LOGISTICS FPJ>
,p_encumbrance_required_flag=> NULL--X_encumbrance_required_flag
                         commit;
dbms_output.put_line('agent_id:'||p_agent_id);
dbms_output.put_line('segment1:'||P_segment1);
dbms_output.put_line('SHIP_TO_LOCATION_ID:'||P_SHIP_TO_LOCATION_ID);
dbms_output.put_line('BILL_TO_LOCATION_ID:'||P_BILL_TO_LOCATION_ID);
dbms_output.put_line('VENDOR_SITE_ID:'||P_VENDOR_ID);
dbms_output.put_line('VENDOR_SITE_ID:'||P_VENDOR_SITE_ID);
dbms_output.put_line('SUPPLY_AGREEMENT_FLAG:'||P_SUPPLY_AGREEMENT_FLAG);
dbms_output.put_line('QUOTE_TYPE_LOOKUP_CODE:'||p_QUOTE_TYPE_LOOKUP_CODE);
dbms_output.put_line('FREIGHT_TERMS_LOOKUP_CODE:'||P_FREIGHT_TERMS_LOOKUP_CODE);
dbms_output.put_line('AUTHORIZATION_STATUS:'||P_AUTHORIZATION_STATUS);
dbms_output.put_line('ORGANIZATION_ID:'||p_ORGANIZATION_ID);
dbms_output.put_line('VENDOR_CONTACT_ID:'||P_VENDOR_CONTACT_ID);
dbms_output.put_line('Type_Lookup_Code:'||p_Type_Lookup_Code);
dbms_output.put_line('Summary_Flag:'||p_Summary_Flag);
dbms_output.put_line('Enabled_Flag:'||p_Enabled_Flag);
dbms_output.put_line('Comments:'||p_Comments);
dbms_output.put_line('Currency_Code:'||p_Currency_Code);
dbms_output.put_line('Authorization_Status:'||P_Authorization_Status);
dbms_output.put_line('Status_Lookup_Code:'||p_Status_Lookup_Code);
dbms_output.put_line('Quotation_Class_Code:'||p_Quotation_Class_Code);
dbms_output.put_line('Approval_Required_Flag:'||p_Approval_Required_Flag);
dbms_output.put_line('last_update_login:'||p_last_update_login);
dbms_output.put_line('created_by:'||p_created_by);
dbms_output.put_line('last_update_date:'||p_last_update_date);
dbms_output.put_line('Vendor_Contact_Id:'||p_Vendor_Contact_Id);
dbms_output.put_line('fob_lookup_code:'||p_fob_lookup_code);
EXCEPTION
WHEN OTHERS THEN
--p_return_status :='E';
--p_error_msg     :='ERROR during Insert in PO_HEADERS.'||CHR(10)||SQLERRM;
raise;
END p6;
Regards,
YellaGoud

Answers

What is your current Oracle user ?
show userTry to identify the table owner:
select owner from dba_tables where table_name='CE1LAOC';And add <table owner> as prefix to table name:
CREATE INDEX Z05 ON <table_owner>.CE1LAOC (MANDT, PALEDGER, BUKRS, PERIO, VRGAR, VKORG, HZDAT);

Read other 4 answers

Tags:

Related Articles

  • Unable to Create Quotations in Oracle Apps with named PL/SQL BlockOctober 11

    Dear All, I got struced while creating Qotations from the backend using oracle API in a Procedure.But the same API working fine in Anonymous block and creating Qutations in apps.But the in parameters are same in anonymous and named bolck.i have done

  • Create dblink in Oracle/Linux (RHEL4) to MS SQL Server/Windows?November 30

    Hi, Can anyone share me the procedure to Create dblink in Oracle/Linux (RHEL4) to MS SQL Server/Windows? ThanksHi, to access non-Oracle systems you must use Oracle Heterogeneous Services. You have to follow the instructions from Heterogeneous Connect

  • Oracle Package is a pl/sql blockNovember 30

    Hello , I am having a simple doubt on oracle package . A pl/sql block (executable section) must have a begin and end . But oracle package is having only the end part , so is it a pl/sql block or what ........................ Thanks> A pl/sql block (e

  • Unable to Create FTP Adapter + Oracle ESBOctober 11

    Hi, Following is the scenario in Oracle ESB:------- I created one FILE Adapter for reading file from directory and FTP Adapter to put that file to FTP site in Oracle ESB. When i checked in the ESB console File was getting picked up by the FILE ADAPTE

  • Creating interfaces in oracle apps 11iNovember 30

    Hello everyone, I'm new to oracle apps and getting trained in supply chain management(PO,INV,OM). Could you pls post some doc's or sample code for creating interfaces between apps modules. For example PO to AP, OM to AR. thanks in advance, vrHi You d

  • Creating a NEW Oracle APPS EUL , How to get Oracle BI Objects in new brandNovember 30

    Hi there We upgraded Oracle Discoverer 4i to Discoverer 10g and during the upgrade process DBA upgrade the EUL5 in the same schema. Now That schema is corrupt. I have to create a new Brand EUL for Oracle APPS Business Intelligence Views 11.5.10.2. Wh

  • How to create JNDI for Oracle Apps AdapterNovember 30

    I have created a data-source(jdbc/testds) and connection pool which connects to apps schema in Weblogic console. Then i go to Deployments-> Oracle Apps Adapter -> Configuration -> Outbound Connection Pools. In the Outbound Connection Pools table

  • Create Template in Oracle AppNovember 30

    Hello All, I have created several XML Publisher templates for job offer letter. Now what I need to do is upload these letters to Oracle app. I don't know what I need to do in the next step because I know how to upload the template to the existing see

  • Unable to use flexfield lexical oracle.apps.fnd.flex.kff.segments_metadataOctober 11

    EBS 11.5.10.2 XMLP 5.6.3 ARXAGMW.rdf Hello, I am trying to convert an Oracle Report to XML Publisher, and I am having problems getting lexicals in the Data Template to work. I raised an SR for this since both related threads in this forum from two ye

  • Unable to create table in Oracle EX 11gOctober 11

    I am new user without any background to Db or SQL. Recently I have installed Orale EX 11g and was trying to create new tables using script menu. Please guide me further as I am unable to do it. Error is Invalid Identifier.I have installed Orale EX 11

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.530 s.