I am using the following code in an event but the deferred job is erroring:DeclareAttr_ Varchar2(32000);Sql_Msg_ Varchar2(32000);Block_ Varchar2(32000);TRANSLATION_TEXT_ varchar2(2000);BeginBlock_ :='Declareinfo_ varchar2(200) := null;title_ varchar2(50);Beginselect title into title_ from doc_issue_reference where doc_no=''&NEW:DOC_NO'';If title_ = ''Delivery Note No'' ThenBegin ifsapp.doc_issue_api.New_Revision2__(''&NEW:DOC_CLASS'',''&NEW:DOC_NO'',''&NEW:DOC_SHEET'',''2'',''&NEW:DOC_SHEET'',''TEST'',1,1,1,''DELI''); End;Endif ;End ;';--Transaction_Sys.Is_Session_Deferred; Sql_Msg_ := Message_Sys.Construct('UPDATECOLINE');Message_Sys.Add_Attribute(Sql_Msg_, 'SQL', Block_); Client_Sys.Clear_Attr(Attr_);Client_Sys.Add_To_Attr('SQL_DATA_', Sql_Msg_, Attr_);Client_Sys.Add_To_Attr('MSG_', '', Attr_); Transaction_Sys.Deferred_Call('Fnd_Event_Action_API.Action_Executeonlinesql','PARAMETER',Attr_,Language_Sys.Translate_Constant('Event', 'Delivery Note Revision', Null,
I have a migration job to update the order quotation lines and some custom fields. I have checked all the necssary but I cannot get these fields to update on the migration job. I am sure its probably something silly but I am just not seeing it. Any help greatfully received
Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ?
I have written a procedure to finish work orders, however if there is an error when calling the api to close I want it to log the problem but continue with the rest of orders. How do I complete this in the code please ?Sample code:objversion_ varchar2(200); wo_objid_ varchar2(200); wo_objversion_ varchar2(200); null_ varchar2(32000) := NULL; error_message_ varchar2(2000); t_ date; CURSOR Cur Is Select wt.state, wt.objid, wt.objversion, wt.task_seq, wo.objid as wo_objid_, wo.objversion as wo_objversion_, wo.wo_no from ifsapp.ACTIVE_SEPARATE_UIV wo inner join ifsapp.JT_TASK_UIV wt On wo.wo_no = wt.wo_no where wo.mch_code='MATERIALS' and trunc(wo.reg_date) <= Trunc(sysdate)-30; BEGIN FOR cur_chief in cur loop If cur_chief.state In ('Released','New') Then Transaction_SYS.Log_Status_Info('Work Order: '||cur_chief.wo_no|| ' has been finished.' , 'INFO'); IFSAPP.JT_TASK_API.START_WORK__( null_ , cur_chief.objid , cur_chief.objversion , null_ , 'DO'
The background job Generate Authority for User has just started failing - can anyone help me identify what the issue is please ? ORA-04098: trigger 'IFSAPP.LOG_DATAFILE_CREATION' is invalid and failed re-validationORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5588ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5580ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 5405ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 2652ORA-06512: at "IFSAPP.DATABASE_SYS", line 2252ORA-06512: at "IFSAPP.DATABASE_SYS", line 5012ORA-06512: at "IFSAPP.DATABASE_SYS", line 4511ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3917ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3922ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3705ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 3785ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2523ORA-06512: at "IFSAPP.COMPANY_POSITION_API", line 2537ORA-06512: at line 1ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1831ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 278 ORA-06
Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.