Monthly Archives: December 2015

Oracle EBS: Concurrent Program Date Parameter

bekanntschaften bayern 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).

pop over here Standard Functionality

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

list of free american dating site 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;