Monthly Archives: December 2015

Oracle EBS: Concurrent Program Date Parameter

opzioni trainding you could check here http://web-impressions.net/fister/3520 http://www.comitesdepistagecancers.fr/ployka/4768 single mann kochen http://bullcitycraft.com/milnica/10931 mon ex va sur des sites de rencontre radiometric dating and half life opcje binarne negatywy concurrent program date parameterBusiness Need

Business needs to have a list of values displayed for date parameter for a custom concurrent program parameter (similar to as the custom form date field).

Standard Functionality

Oracle doesn’t provide a standard date List of Values to appear for concurrent program parameters.

Custom Solution

  1. Create a custom view to display the dates based on the current date.
  2. Create a table validated value-set referencing the custom view.
CREATE OR REPLACE FORCE VIEW "APPS"."XXORA_DATE_SELECTION" ("P_DATE") AS
SELECT to_date(p_date,'DD-MON-RRRR') p_date
FROM (
(
SELECT to_date(sysdate-1+level,'DD-MON-RRRR') p_date
FROM dual
CONNECT BY level<=8
UNION
SELECT to_date(sysdate+1-level,'DD-MON-RRRR') p_date
FROM dual
CONNECT BY level<=365
)
)
ORDER BY p_date DESC;