Oracle iExpense report

11-30  Source: Network gathering  Views:3 

Please help with a query to find iExpense reports that are Auto Approved.
Mean I need to display only the expense reports that are Auto approved.
dear All ,
I resolved the issue using the following :
wf_notification.setattrtext ( nid => :notification_id
                                , aname => 'RESULT'
                                , avalue => 'REJECTED' ); 
                                wf_notification.setattrtext ( nid => :notification_id
                                , aname => 'WF_NOTE'
                                , avalue => 'Auto Rejected as the BM is older than 30 days' ); 
    wf_notification.respond ( nid => :notification_id);
Related articles
  • Oracle iExpense report 11-30

    Folks, Please help with a query to find iExpense reports that are Auto Approved. Mean I need to display only the expense reports that are Auto approved. Thanks, gvk.dear All , I resolved the issue using the following : wf_notification.setattrtext ( n

  • Iexpense Report Creation 11-30

    HHi all, I need to know where the reason code field  can be found  while creating an iexpense report in Oracle. Allso if there is any lookup involved  and where that lookup can be found . Many thanks in advanceHi The below navigation should help you

  • How do I use the Oracle Developer Reporting Control in Visual Basic 6.0? 10-11

    I was wondering how to use the Oracle Developer Reporting Control componant in Visual Basic 6.0 to generate reports in Oracle Reports? Any help would be appreciated.Hi Rohit, Would like to ask you some questions about the oracle report with Visual Ba

  • Calling Oracle Discoverer Report from Apex 10-11

    How to call Oracle Discoverer Report from apex application? Thanks!The report is on a different data base ... need to create a process to get the data into the view behind the report and then materialized view in Apex etc .Then recreate the same repo

  • Reports Requirements using R12 and Oracle 10g Reports 10-11

    Hi All, Looking forward to some valuable inputs to propose a technical solution in R12 using 10g Reports Developer. Requirements are : 1. Report output should be in Excel Format. ( Is this possible without XML Publisher using 10g Reports only ) 2. Re

  • How to add a new font into Report Builder and Oracle Forms/Reports Server? 10-11

    Hi, I've searched the forum and can't find this being discussed. My developers run Report Builder on their XP laptops. Their reports run (in production) on Oracle Forms/Reports Server This server runs on MS Windows 2003, SP2. T

  • Oracle 6i report in character mode 10-11

    we have been using oracle 6i report in Windows XP, our printer is attached to the said PC when we print character mode the print out is not in character mode but if we send the print-out in a printer attached to a PC using win98 the printout is perfe

  • Upgrade Oracle Forms/Reports from 6i to 11g 10-11

    Hi you Oracle experts, I'm considering to upgrade my Oracle Forms/Reports application from 6i to 11g. However, I see dozens of separated server components on the download page in OTN. Can anyone guide me what server/developer software components shou

  • Oracle Matrix Report output to XML Publisher 10-11

    We have an Oracle matrix report (rdf) registered in our applications and we are trying to format the report output using XML publisher. I have taken XML output of the report by changing the Report output to XML in concurrent program definition. Using

  • How to configure oracle 6i report server run time component with application server 10-11

    we got oracle 6i report server for developing the web based reports for our undergoing product. we r succesed in developing the web based reports using oracle 6i report server.But we r facing problems while deploying the product with oracle reports a

  • How to deploy Oracle Forms & Reports in Weblogic Server 11g (10.3)? 10-11

    Hi How to deploy Oracle Forms & Reports in Weblogic Server 11g (10.3)? ThanksHi when i am going through your bleow link. I am not able understand the 3.3.1 step :2 edit

  • Installation Guidance (WebLogic 10.3.5 / Oracle Forms,Reports 10-11

    Goal : I am a designer/developer, have worked on already-installed systems for years, now between contracts and want/need to set up my own installation of Oracle Database 11g R2 database and development tools including Oracle Forms/Reports 11g (also

  • Use css file in oracle 10g report builder 10-11

    hi every one i am using oracle 10g report buidler. i want control paramform by usign css file. any body have idea how can i use css file in oracle report builder 10g and how can i modify it's path and i how can i manage any css class on a perticular

  • How to print message in oracle rdf report output? 10-11

    Hi, There is a requirement to print message in output of oracle rdf report. srw.message prints the message in log file but how to print message in output. Please suggest. Thanks & Regards, Sunita897745 wrote: Hi, We are trying to print BARCODE for Or

  • I need help on how to install, then run Oracle 9i Reports Server ? 10-11

    where do i get Oracle 9i Reports ? how do i used it ?you had to install forms server and report server. once the server install completes to check it is working fine type http://ipmachine/serveraddress/portno at the time of install/testreport.htm mea

  • How to embed/show an image file (.jpeg or .jpg or .png) into a Oracle 10g report file (.rdf) 10-11

    Hi All, Morning , have an urgent requirement and need some guidance regards this. we are currently having an existing Oracle 10g reports file (.rdf)  lets say with name : Testing1.rdf . The report output is getting generated in a pdf format . it open

  • SSMA for Oracle 6.0 Cannot connect to Oracle DB reporting "table or view does not exist" 10-11

    SSMA For Oracle v6.0.0 MS SQL Server Enterprise 64bits v11.0.3000.0 Oracle Database 11g Enterprise Edition Release - 64bit Production Symptom: when connecting Oracle, it reports error "Common Requirement: User does not have required permis

  • Showing Oracle 10g reports in Dashboard? 10-11

    Configuration: Oracle Business Intelligence Release on Windows 2003 EE R2 Oracle 10gR1 on Windows 2003 EE R2 Problem: We have to show Oracle Reports 10i in Oracle Busines Publisher. Resolving failure: Conversion of current reports to "xdo&qu

  • How to send a oracle application report automatically  to a specific e-mail 10-11

    hi!!!!! how to automatically send a mail once the oracle application report is generated ?? It should happen automatically... Do we have to use any function for that??? or is there any other way of doing it???You can use utl_smtp package in the after

  • Oracle 6i report generation in excel 10-11

    hi all, I am using oralce 6i. I want to generate oracle 6i report in "excel" instead of pdf. Can I use Oraccle forms and reports services for 6i version ? Any help would be appreciate. Regards,Yes you can, Use desformat=delimited (instead of des