We are trying to integrate APEX with Oracle Ebusiness Suite 11i. We are trying to integrate with the HR/Payroll application which uses FND_GLOBAL.APPS_INITIALIZE to set the security context to a user, responsibility and application id which defines who the session has access to for the session. When we make the call to FND_GLOBAL.APPS_INITIALIZE in either a before header process or in the VPD security attribute, we get no data. Using the same call in SQL*PLUS we get the data expected.Any suggestions on how to get this to work? What are we missing?
I am use the ORACLE EBS 11.5.9 AND DATABASE 9.2.0.8 64Bit, when select the "PO_HEADERS", no rows, I want to use the FND_GLOBAL.APPS_INITIALIZE to initialize ,what value should I determine the parameter USER_ID =>,RESP_ID => ,RESP_APPL_ID =>?
i am initialising using this scriptbeginfnd_global.apps_initialize (user_id => 1112,resp_id => 50707,resp_appl_id =>222);end;, but i am not able to query in view select * from ar_cash_receipts;please suggest if we need to do something more to initialise session.i checked MO:Operating Unit and GL:Ledger is also set to correct Operating Unit.warm
We are developing an integration which sends data from one system to an Oracle E-Business Suite instance. In order to load the data into E-Business we need to call API’s which require the fnd_global.apps_initialize to be run.We have a custom PL/SQL procedure which calls the APIe.g.SOA -> custom PL/SQL -> E-Biz APIThe custom PL/SQL runs apps_initialize.The problem is when we call this from SOA via a XA connection we get the following error:<P_ERR_MESSAGE>Error - Failed to delete the interface records after reading result! Message: Unknown Error ORA-20001: Oracle error -20001: ORA-
On Opening the R12 forms, getting the pop errorAPP-FND-01926 The custom event WHEN-RESPONSIBILITY-CHANGED raised unhandled exceptionORA-04062 signature of package APPS.FND_GLOBAL has been changed.On Clicking OK, it opens switch responsbility form and then it shows the same error.APPS.FND_GLOBAL package is valid too. How to rectify this? Plz help
I'm pretty much new to work on Interfaces.I need to update the interface table with user_id and request_id.I'm fetching Uesr_id as fnd_global.user_id and request_id as fnd_global.conc_request_idcan i use, fnd_profile.value('user_id') to fetch user_id.What is the difference between the packages fnd_profile and fnd_global.Where should I use the specifically??
I'm using 10g DB (System as my access), 11.5.1 EBSI created a trigger (before_update) with line :new.last_update_by := fnd_global.user_id;but get the error PLS-00201: identifier 'FND_GLOBAL.USER_ID' must be declared error.
I have created trigger 'before delete on my line table'. when user delete record last_updated_by record has to store in my temp table.im using fnd_global.user_id itis giving me error:PL/SQL: ORA-00984: column not allowed herecan any one help me in this issue.oracle 91.
using codev_user := fnd_global.user_id this is returning -1 always any idea why. Please help.
1.Below is a piece of my .CTL file which I registered as concurrent program and submitting in SRS windowLAST_UPDATE_DATE SYSDATE,LAST_UPDATED_BY "FND_GLOBAL.USER_ID" ,CREATION_DATE SYSDATE ,CREATED_BY "FND_GLOBAL.USER_ID",LAST_UPDATE_LOGIN "FND_GLOBAL.LOGIN_ID",STATUS CONSTANT 'NEW',EXTRACT_DATETIME SYSDATE,LOAD_ID "FND_GLOBAL.CONC_REQUST_ID" When the data is loaded for the columns where i userd fnd_global...I get -1 rather than my User id , login id or request id.Please let me know if I miss any thing. 2.My Data file is a Excel sheet which I save as it .CSV file . Some of the text data has co
I've seen a few questions on how to integrate Oracle Financials (Apps) with ApEx applications. Below are some methods that I use. The main issue with these approaches is that your Apex user will get a new session each time. I have an unsupported routine that will allow me to maintain the same session with each return to ApEx from Apps. Scott Spadafore has commented several times on how you might do that. I'm going to leave it to Scott's posts to explain it as I don't want to post unsupported workarounds. 1. Utilize Oracle SSO for both Apps and ApEx.A. Set up both to use SSOB. Put the following
I have been facing some issues while i was trying to ship confirm using an api.But the issues i was facing were related to debuggingI have some question and I will be greatly obliged even if i get answer of some and I m posting thesequestion only after spending more than 14 hours doing research.. q-1 we use fnd_log_messages to check log messages ...are these different from debug messages that are genrated and written to server e.g in api wsh_interface_grp.Delivery_Actionwsh_debug_sv.log is used to generate .. will go the server in a file i read the following article to clear my doubts ,http://
Any one use java call oracle ERP stored procdure?Example I want ues java call below stored, it can work , but in Oracle ERP have error : "APP-MRP-22130: Cannot connect to databaseCause: The current routine cannot connect to the database.Action: Contact your system administrator or customer support representative." CREATE OR REPLACE procedure XXBOM_ITEM_IMPORT isx number;beginfnd_global.apps_initialize(1070, /*i_user_id*/20634, /*i_responsibility_id*/401 /*i_application_id*/); /* import item */x := fnd_request.submit_request(application => 'INV',program => 'INCOIN',argument1 => 141,arg
I got the following package body :-Create or replace package body AIC_WSH_DELIVERY ASPROCEURE WSH_DELIVERY_TEST ( x_return_status OUT VARCHAR2,x_msg_count OUT NUMBER,x_msg_data OUT VARCHAR2) ISp_api_version_number NUMBER;init_msg_list VARCHAR2(30);x_msg_details VARCHAR2(3000);x_msg_summary VARCHAR2(3000);p_validation_level NUMBER;p_commit VARCHAR2(30);fail_api EXCEPTION;BEGINFND_GLOBAL.APPS_INITIALIZE(USER_ID => 1010, resp_id => 52892, resp_app_id => 660);source_code := 'OE';WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY(p_api_version_number => 1.0,p_init_msg_list => init_msg_list,p_
Has anyone implemented the HTMLDB over Oracle HR 11i? I am trying to access data from HTMLDB to Oracle HR 11i tables with the HR security profiles attached.For example, HR view per_people_f has the security profile restriction, when I select from HTMLDB via DBLINK it returns all the record while it should only return those records based on the security profile. However, when I select from SQLPLUS under the HTMLDB Scheme, it returns correct results. I ran the following program under HTMLDB scheme in SQLPLUSdeclarev_res_id number;beginfnd_global.apps_initialize@htmldb_link(user_id => 20254,re
I have the following PL/SQL block.apps.create_po(x_org_id,x_document_num,x_agent_name,x_vendor_id,x_vendor_site_id,x_ship_to_location,x_bill_to_location,x_creation_date,new_isbn,new_print_key,new_unit_setup_cost,new_unit_run_cost,x_item,x_category_id,x_item_description,x_unit_of_measure,x_quantity,x_unit_price,x_ship_to_org_id,x_promise_date,x_qty_rcv_tolerance, x_deliver_to_location,x_destination_org_id, x_destination_subinventory,x_segment2,x_segment4);COMMIT;..FND_GLOBAL.APPS_INITIALIZE(v_user_id,v_resp_id,201);v_po_req_id := apps.fnd_request.submit_request('PO','POXPOPDOI',NULL,NULL,NULL,N
My intention is to create an application - report using Oracle ApEx. This report should work using EBusiness suite authentication for login and should use VPD. I have explained the whole steps in detail. a) The login should be validated against ebusiness suite authentication for which I created a function under APPS schema create or replace function custom_ebiz_suite_auth (p_username IN VARCHAR2, p_password IN VARCHAR2) return boolean as userID NUMBER;begin if fnd_web_sec.validate_login(p_username, p_password) = 'Y' then SELECT USER_ID INTO userID FROM FND_USER WHERE USER_NAME= p_username;fnd_
I have made two procedures, xx_nidhi_proc1 and xx_nidhi_proc2. xx_nidhi_proc1 takes four parameters from front end and is registered as concurrent program in oracle apps and running fine alone.xx_nidhi_proc2 calls the concurrent program of xx_nidhi_proc1 which is XX_NIDS_PROC1_PROG1.But the problem in my code is , It runs the second concurrent program for xx_nidhi_proc2 but shows the Inactive- No Manager status for my first concurrent program XX_NIDS_PROC1_PROG1, Please find out the error in my code... CREATE OR REPLACE PACKAGE BODY NIDHI ISprocedure xx_nidhi_proc1 (errbuf OUT VARCHAR2,retcode
I have a workflow triggered by asynchronous subscriptions to business events. I have re-established the user context of the workflow using the callback-selection functionality of workflow and by using FND_GLOBAL.APPS_INITIALIZE.But this still doesnot set the NLS parameters of the user that were existing prior to raising the workflow. How do I re-establish the NLS settings of user in Oracle Applications. I believe this should be possible someway.
i am new to PL/SQL here is a below script where i am running the script for the below API given ...... my issue is if i run the script it shd give output as the return_status,msg_data,msg_count if i get error the return_status shd be as 'E'(Errors) (S)Success and msg_data: error description,msg_count:number of errors i am getting errors if i have errors in the code if the code runs fine it shd show as 'S' Success but in my instance its showing empty Retur_status ,msg_data,msg_count......... can anyone help me plzzzzzz i have formated ur code set serveroutput on size 1000000DECLAREl_return_stat
I was getting an error in one of my custom modules. The problem I found out is the following Query is not fetching any rows.In the Query the join with 'oe_order_lines' is failing. oe_orders_lines is unable to find the line details. Where as if I use 'oe_order_lines_all' its working fine. We are using this Custom module in more one warehouse like 'Chicago', 'Chennai' etc. I have also initialized the session with user and responsibility details.Could you please help me in finding out what exactly went wrong in this.SQL> set serveroutput onSQL> begin2 fnd_global.apps_initialize( 5605,52499,
I wonder if you can help me please. I've a cash_receipt_id (isdd.column18) which is stored in a Varchar2 column, and I'm trying to convert it into a number. I'm not sure what I'm doing wrong, but please see my code below:<execute fnd_global.apps_initialize(1844,50261,222) DECLARE l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(240); l_count NUMBER; l_cash_receipt_id NUMBER; --:= 172513; l_msg_data_out VARCHAR2(240); l_mesg VARCHAR2(240); p_count number; l_reversal_gl_date DATE; --:= SYSDATE; l_reason VARCHAR2(100); CURSOR c_reason IS select distinct description--
I need your help. I have created a shell script that calls a procedure and creates a file. While compiling this shell script, I am getting the following error:/d01/app/oracle/oadev/oadevappl/lfnd/11.5.0/binLOGI_NOTIFMAIL_SH[92]: sqlplus: not foundReturn- Contents of my shell script are as given below: {# Get the 2nd word from the string, This is the loginFCP_REQID=`echo $@ | awk '{split($0,myarray);print myarray[2];}'`eval $FCP_REQIDecho $FCP_REQID# Get the 3rd word from the string, This is the loginFCP_LOGIN=`echo $@ | awk '{split($0,myarray);print myarray[3];}'`eval $FCP_LOGIN# Get the 4th w
what do u mean by debug in pl/sql? Is it similar to dbms_output?sample:BEGIN If nvl(upper(l_read_only_mode),'Y') = 'N' then backup_table_xe; End If; FND_GLOBAL.APPS_INITIALIZE(&user_id, &responsibility_id,222); mo_global.init('AR'); mo_global.set_policy_context('S',l_org_id); debug('RECEIPT_ID CRH_GL_DATE RA_GL_DATE MAX_GL_DATE MAX_EVENT_ID '); debug('-------------- ------------------ --------------- --------------- ----------------'); for crh_rec in c1 loop max_event_id := null; max_gl_date := null; l_failure_cnt := 0; if crh_rec.crh_gl_date
how to execute this function from SQL Devloper any one please help me.i am in Oracle Apps where Before i have to execute Apps Initialize and function functionFND_GLOBAL.APPS_INITIALIZE( user_id => 1111, resp_id => 222, resp_appl_id => 1111); FUNCTION ContractStatus ( p_contract_line_id NUMBER, p_inventory_item_id NUMBER, p_organization_id NUMBER ) RETURN VARCHAR2 IS l_CTRACS_COUNT_EXCEEDED CONSTANT VARCHAR2 (30) :='N2'; l_CTRACS_VALID CONSTANT VARCHAR2 (30) :='N1'; l_INVALID_ITEM_FOR_CONTRACT CONSTANT VARCHAR2 (30) := 'N3'; l_VALID_CONTRACT CONSTANT VARCHAR2 (30) := 'N4'; l_ATTRIBUTE2
I need to apply PTO thru backend with the list of OTL API's.. Please find the code..l_person_id hxc_time_building_blocks.resource_id%TYPE := 12536;l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := 2021;l_tbl_timecard_info hxc_self_service_time_deposit.timecard_info;l_tc_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;l_resource_type VARCHAR(20) DEFAULT hxc_timecard.c_person_resource;l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;l_detail_bb_st_id hxc_time_building_blocks.time_building_block_id%TYPE;l_tbl_attributes_info hxc_self_service_time_deposit
Have an app that basically loads an interface table.I want to call a concurrent job from the page within my apex app that will submit the concurrent job in Oracle when I press the submit button. The only parameter is group id and typically end user enters 101010.I am unsure of the syntax..... the dba gave me this as an example but I believe its incomplete and not sure how to complete it or call it. I tried just creating a process to execute after submit but it errors out as in_user_id, in_resp_id and in_appl_id must be declared. Logic tells me I have to provide those somehow but I dont see how
We connect with the APPS user and set the EBS context in order to see the filtered view apps.per_people_f. To set the context, we use:apps.fnd_global.apps_initialize( user_id => r_user.user_id, resp_id => r_responsibility.responsibility_id, resp_appl_id => r_responsibility.application_id);apps.mo_global.init;apps.hr_signon.initialize_hr_security;When we do this in Toad, and consequently query the view in the same database session, it correctly filters the people that we see. When we run this in APEX (parsing schema set to APPS), where we put this code into the VPD section of "applicat
I am using an API to create charge line and its giving an error : ORA-01438: value larger than specified precision allowed for this column in Package CS_CHARGE_DETAILS_PVT Procedure Create_Charge_Details.Please find the code below.DECLAREL_API_VERSION NUMBER:= 1.0;L_RETURN_STATUS VARCHAR2(100);L_MSG_COUNT NUMBER;L_OBJECT_VERSION_NUMBER NUMBER;L_MSG_DATA VARCHAR2(1000);L_ESTIMATE_DETAIL_ID NUMBER;L_LINE_NUMBER NUMBER;L_MSG_INDEX_OUT NUMBER;L_CS_ESTIMATE_DETAILS CS_ESTIMATE_DETAILS%ROWTYPE;L_CHARGES_REC CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE;out_message varchar2(1000); BEGINL_CHARGES_REC.CHARGE_
Problem Description: How we are doing it now – 1. Created the shell script (vistest2.sh) which is working fine when run from command promptTo run a shell script in Windows environment by registering it as a concurrent program2. Renamed the extension of the script from vistest2.sh to vistest2.cmd3. Copied the executable, fndcpesr.exe from FND_TOP/bin to CUSTOM_TOP/bin4. Renamed it from fndcpesr.exe to vistest2.exe5. Created a host custom program with executable file name as vistest2 and registering it in Custom Application6. Running the concurrent program errors. Issue – The concurrent mana
SET SERVEROUTPUT ON;DECLAREv_api_version_number NUMBER := 1;v_return_status VARCHAR2 (2000);v_msg_count NUMBER;v_msg_data VARCHAR2 (2000);-- IN Variables --v_header_rec oe_order_pub.header_rec_type;v_line_tbl oe_order_pub.line_tbl_type;v_action_request_tbl oe_order_pub.request_tbl_type;v_line_adj_tbl oe_order_pub.line_adj_tbl_type;-- OUT Variables --v_header_rec_out oe_order_pub.header_rec_type;v_header_val_rec_out oe_order_pub.header_val_rec_type;v_header_adj_tbl_out oe_order_pub.header_adj_tbl_type;v_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type;v_header_price_att_tbl_out oe_or
Follwoing are the tables which are consuming space for tablespace APPS_TS_TX_DATA.select segment_name, sum(bytes) from dba_segments where tablespace_name = 'APPS_TS_TX_DATA' group by segment_name order by 2 desc; SEGMENT_NAME SUM(BYTES) 1 WSH_EXCEPTIONS 38420873216 2 MLOG$_OE_ORDER_LINES_ALL 23646830592 3 WF_ITEM_ACTIVITY_STATUSES 20170014720 4 MLOG$_XXCS_SALES_MATRIX_SA 17160470528 5 MLOG$_WSH_DELIVERY_DETAILS 16620978176 6 ZX_LINES_DET_FACTORS 15658385408 7 FND_LOG_MESSAGES 13132890112 8 WF_ITEM_ATTRIBUTE_VALUES 13027115008 9 MTL_MATERIAL_TRANSACTIONS 12053774336 10 ZX_LINES 112230400
HiI am trying to create a branch for an existing bank using apps.iby_ext_bankacct_pub.create_ext_bank_branch. I am initializing apps usingdeclarev_user_id number := 1151;v_resp_id number := 50718;v_resp_appl_id number := 200;v_org_id number := 103;v_le_id number := 23271;v_return_status varchar2(1024);x_extbankbranch_rec_type IBY_EXT_BANKACCT_PUB.ExtBankBranch_Rec_Type;begin-- Context Initializationfnd_global.apps_initialize (v_user_id, v_resp_id, v_resp_appl_id);zx_security.set_security_context(v_le_id,v_org_id,sysdate,v_return_status);-- Variable Initializationx_extbankbranch_rec_type.branch
Does anyone know what interface or api I can use to update Purchase orders? I just want to update the buyer field. I tried the following code and it is failing with this error message: " You must enter a value in all the required fieldsCause: You tried to leave this zone without entering a value in all the required fields. Action: Enter a value in the required fields."DECLARE l_status number := NULL;v_error_message VARCHAR2(2000);l_api_errors apps.po_api_errors_rec_type;l_user_id NUMBER;l_resp_id NUMBER;l_appl_id NUMBER;BEGINSELECT user_idINTO l_user_idFROM fnd_userWHERE user_name = 'P21734';S
I am executing the below function using fnd_request.submit_request using the Oracle DataProvider for .NET connectionending up with the error ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.FND_DATE", line 32 ORA-06512: at "APPS.FND_DATE", line 43 ORA-06512: at line 1 ORA-06512: at "APPS.FND_GLOBAL", line 413 ORA-06512: at "APPS.FND_GLOBAL", line 2272 ORA-06512: at "APPS.FND_GLOBAL", line 2546 ORA-06512: at "APPS.FND_GLOBAL", line 2699 ORA-06512: at "APPS.FND_GLOBAL", line 2636 the code in the function is as belowbeginAPPS.FND_GLOBAL.APPS_INITIAL
I'm new to mod_plsql so please bare with me on this.We have an Oracle Applications system here, meaning that the set up for mod_plsql is all done, and I can't change any of it. It's working fine. However, it also means that there is no authentication before running a pl/sql procedure.I'm busy creating an application that I want the user to log on using the Applications user name and password, and create a session based on these credentials (using fnd_global.apps_intialise I guess).Currently I'm using mod_plsql to call a procedure, and that's working well. All it does is get the session id and
We have recently applied Sourcing Rollup 2 J patch in our instance. After this, when the users change their timezone, the system behaves weirdly. The Server timezone and Client timezone are set to Dubai timezone (GMT+4) at site level. If the user is using this timezone, there is no issues. But when the user changes the timezone to something else (anything > GMT+4 or anything < GMT+4), he cannot publish auctions. He is getting error like:oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "
I want to use APPS.FND_FLEX_EXT under a user I just created.If I execute the query below with the user I get no result:SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', 50560, 22093) FROM dual; Then I did execute SELECT fnd_flex_ext.get_message() from dual; to get the last error. Then I getProgram error: Please inform your support representative that: FLEXFIELDS SERVER-SIDE VALIDATION package reports error: SV2.get_keystruct() exception: ORA-00942: table or view does not exist I execute this under APPS to be shure the user has te correct rights.GRANT SELECT ON FND_APPLICATION TO VIEWERUSER; GRANT E
We are using APEX to try and query some E-Business data which works fine however we are getting problems when trying to query secure HR views (standard apps view - per_people_x). We first call the initialize_apps procedure from fnd_global and then do a select * from the view. This works fine in TOAD when connected as apps, however when run in SQL Command Editor in APEX this doesn't bring back any rows, even though the workspace parses as apps. I am thinking that this could be something to do with the database user that APEX connects as (ie, APEX_PUBLIC_USER and not APPS).Would there be any sec
I am on oracle apps 11.5.10. We are calling FND apis like fnd_global.user_id within control file to get current user etc.. SQLLDR is called from host based concuurent program(shell script). Since context is not set in host program when we call plsql packages so FND apis global value returns -1.Is there a way we can set the context or make FND APIS return value as if we are calling from PLSQL concurrent program.
HIWe are running Oracle Applications 11i and are calling some Apex applications from the Oracle Applications menu.How can I obtain the responsibility id that is running the APEX Application as when I use fnd_global.resp_id within apex I always get -1 returned.Can someone advise how I can obtain this information once Apex is launched?
I have program which has a code segment like following: for r13 in cu_get_f13 (ld_balance_date,nvl(pi_closing, 'N')) loopfnd_file.put_line(fnd_file.output, 'Strings....');l_count := l_count + 1;end loop; -- this loop usually contains 12000 to 12500 rows ln_conc_request_id := fnd_request.submit_request ('XXOGL','XXOGL_F40_TRANSFER_FILE',null,null,false,'$APPLCSF','/out',--'/$APPLOUT','o'|| to_char(fnd_global.conc_request_id) ||'.out',lc_file_name,fnd_profile.value_wnps ('XXOGL_F40_RUSER'),fnd_profile.value_wnps ('XXOGL_F40_RSERVER'),fnd_profile.value_wnps ('XXOGL_F40_RPORT'));-- this concurrent
When I approve the workflow, the PR's status (PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS) is 'IN PROCESS'.But the notification¡¦s status (WF_NOTIFICATIONS.STATUS) becomes 'CLOSE'.I find the error log in wf_item_activity_statuses. (where item_type = 'REQAPPRV' and item_key like '%94210-595540%')What is mean about the error, and how to solve this problem?Can anyone please please please help me? Thanks, all.Gavin error log in wf_item_activity_statusesORA-01403: No data found.ORA-06512: ¦b "APPS.PO_REQAPPROVAL_INIT1", line 4661ORA-06512: ¦b "APPS.PO_APPROVAL_LIST_WF1S", line 2368ORA-20001
here is my query. Need some help. This query shows information about the requisitions created. Now my question is " I want to restrict this query so that a oracle applications user who logs in can only see his/her requisitions created and not others."SELECT prh.creation_date req_creation_date,prh.segment1 req_number,prl.line_num req_line_num,gl.SEGMENT3 FQA_Department,per_gl.segment3 approver_department,per.full_name approve_by,prl.item_description,hp.full_name REQUESTOR,lp.full_name PREPARER_NAME,gl.SEGMENT1 company,cat.segment1 category,(l.QUANTITY*l.UNIT_PRICE) requisition_amount,prh.AUTHOR
I am trying to write a package which will create payment batches with a distinct payment_date and bank_account_name combination that are present in a custom base table.These are the columns in the custom table:AFL_PAY_INTER_STG_TABLE(VENDOR_NUMBER VARCHAR2(30 BYTE),VENDOR_SITE_CODE VARCHAR2(15 BYTE),INVOICE_NUMBER VARCHAR2(50 BYTE),CHECK_NUMBER NUMBER(15),PAYMENT_DATE DATE,PAYMENT_STATUS VARCHAR2(25 BYTE),INVOICE_DATE DATE,INVOICE_GROSS_AMOUNT NUMBER,AMOUNT NUMBER,PAYMENT_METHOD_LOOKUP_CODE VARCHAR2(25 BYTE),PAYMENT_TYPE_FLAG VARCHAR2(25 BYTE),BANK_ACCOUNT_NAME VARCHAR2(80 BYTE),PERIOD_NAME VA
Whenever i am running the my procedure in oracle appliactions i am getting this error.ORA-01861: literal does not match format string .pkg is below:--->CREATE OR REPLACE PACKAGE Arc0471_Pending_Crc_Prc_Pkg IS --Insert into Custom Table PROCEDURE Arc_Insert_Data(P_ORG_ID VARCHAR2, P_BC_CODE VARCHAR2, P_GL_DATE VARCHAR2, P_DB_LINK VARCHAR2); END Arc0471_Pending_Crc_Prc_Pkg; / CREATE OR REPLACE PACKAGE BODY Arc0471_Pending_Crc_Prc_Pkg IS PROCEDURE Arc_Insert_Data(P_ORG_ID VARCHAR2, P_BC_CODE VARCHAR2, P_GL_DATE VARCHAR2, P_DB_LINK VARCHAR2) IS v_val varchar2(32000); v_cursor1 inte
After recover database, I got the following error message:ORA-25153: Temporary Tablespace is Empty has been detected in FND_GLOBAL.INITIALIZEI try to resolve this problem and issue the following command: SQL> create temporary tablespace temp tempfile '/u01/oracle/uatdata/temp02.dbf' size 500M2 extent management local;create temporary tablespace temp tempfile '/u01/oracle/uatdata/temp02.dbf' size 500M*ERROR at line 1:ORA-01543: tablespace 'TEMP' already existsPlease advice,Amy
I meet some exceptions as below when I execute a normal stored procedure in Oracle EBS underlying database. Could anyone help to look at this problem? ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transactionhas been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').has been detected in fnd_global.set_nls.ORA-06512: at "APPS.APP_EXCEPTION", line 72ORA-06512: at "APPS.FND_GLOBAL", line 240ORA-06512: at "APPS.FND_GLOBAL", line 1410ORA-06512: at "APPS.FND_GLOBAL", line 1655ORA-06512: at "APPS.FND_GLOBAL", line 2178O
I am trying to link apex forms with E-Business Suite.I wrote following code in the PL/SQL called by the form function: OWA_UTIL.mime_header('text/html',false);OWA_COOKIE.send(name=>'APEX_APPS_'||application,value=>FND_GLOBAL.user_name||':'||apex_generate_hash(FND_GLOBAL.user_name),path => '/'); OWA_UTIL.redirect_url('http://xxxxxxxx:xxxx/ebus/apex/f?p='||application||':'||page||'::'||request||':::'||item_names||':'||item_values); Then I wrote this piece of code to read the cookie in "Before process" section of the APEX page I called above: DECLAREc OWA_COOKIE.cookie;a wwv_flow_global.
I have one program, i ran this program 3 times, but this 3 programs running last 13 hrs, maximum this program run only 5 min,i checked any locks is qureied this programs,In the dba_waiters no sessions locked,in the dba_locks also no locks acquired based on this 3 sessions,But i checked this programs run same select statement.Finaly i checked in the DBA_LOCK_INTERNAL table it is showing lock type is Cursor Definition Lock and mode_held is null and mode_requested is none and lock_id1 is select statement and lock_id2 adress of this lockthis any impact on my program plz give any impact my program