Monthly Archives: September 2013

Concurrent request Queries

Posted on September 12, 2013 by digappsdba

List concurrent request related data from the following tables: FND_CONCURRENT_REQUESTS FND_CONC_REQUEST_ARGUMENTS FND_CONC_PP_ACTIONS FND_APPLICATION FND_CONCURRENT_PROGRAMS FND_CONCURRENT_PROGRAMS_TL FND_EXECUTABLES FND_EXECUTABLES_TL FND_DESCR_FLEX_COLUMN_USAGES FND_PRINTER FND_PRINTER_TL FND_PRINTER_STYLES FND_PRINTER_STYLES_TL FND_PRINTER_INFORMATION FND_PRINTER_DRIVERS FND_CONCURRENT_PROGRAM_SERIAL FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUES FND_CONCURRENT_QUEUES_TL FND_CONCURRENT_QUEUE_CONTENT FND_USER FND_LOGINS FND_RESPONSIBILITY FND_RESPONSIBILITY_TL SID from Request id (Ref Note ID 735119.1) … Continue reading →

Posted in APPS DBA | Leave a comment

Unable to determine SMTP server to use: set FND_SMTP_HOST

Posted on September 3, 2013 by digappsdba

Issue: oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST         at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)         at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)         at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)  Solution :  Change the profile option :  FND: SMTP Host – Give your smtp server name FND: SMTP Port – … Continue reading →

Posted in Uncategorized | Leave a comment