Oracle concurrent request set shared parameter - Explained

Purpose:


Today we will talk about how to share parameter values defined in a request set.


Example:


In below example request set has 3 stages and all stage has same parameter defined.
So when user runs the request set, they have to select parameter values for 3 stages individually (even though the parameter values are same for all 3 stages).

How to avoid from user selecting parameter 3 times Vs doing it once.
(User select value ONLY in stage 01 and stage 02 and stage 03 will automatically get values from stage 01).


Request set: Import Open Payables request set.
Request stage 01: Stage A has parameter: Type
Request stage 02: Stage B has parameter: Type
Request stage 03: Stage C has parameter: Type

Define Shared Parameter called Product in Stage 01

In Stage 02, select Shared Parameter Product from LOV.

Thanks for visiting my blog.

How to store Oracle application output file in different location on the server

Date: 21-Aug-2017

Use case:

Oracle concurrent program will store output files in $APPLCSF/out location by default. This is done by standard vanilla implementation.


But there can be a scenario where you may want to store output file on different location.


For example in case of xml publisher reports you may want to store output (could be excel / PDF/ etc) on different custom folder.

How do you achieve this?

You could write some post processor after completion of the report/program.
Update FND_CONCURRENT_REQUESTS table outfile_name column with wherever location you want to store the file.


update fnd_concurrent_requests set outFile_name='/xx/out/INV/34505706.pdf' where request_id=34505706;


Important: Make sure that application server can access the location, because if you want to view output and if application server does not have access to the folder then you will not be able to view the output.


Thanks for visiting my blog.

Enable paperclip (attachment) icon on core forms in Oracle application

In this article we will see how to enable paperclip icon  or in other words attachment icon on core form.


Go to Application developer >> Attachments >> Attachment Function.
Query the form/Function and enable "Include in Indicator"