PL/SQL (MOSC)

MOSC Banner

Schedule a program every 2 weeks

edited Jun 20, 2020 11:35PM in PL/SQL (MOSC) 4 commentsAnswered

Hi All,

Well I have developed a Concurrent program which takes  "FROM DATE" and "TO DATE " as inputs and generate XML file with Payments made between that Period.

However I want to schedule this Job for every 15 days . Not sure how this can be scheduled or if i need to make changes in the program. Please suggest

Below is the  pick criteria i use to

   PROCEDURE XXPQ_MX_PYMT_INV_DETAIL (P_FROM_DATE   IN     DATE,                                      P_TO_DATE     IN     DATE,                                      p_err_flag       OUT VARCHAR2,                                      p_err_msg        OUT VARCHAR2)   AS      CURSOR C_MX_PYMT      IS         SELECT ARPS.TRX_NUMBER,                ARPS.TRX_DATE,                ARPS.CREATION_DATE,                ARPS.LAST_UPDATE_DATE,                EDIP.COUNTRY           FROM APPS.AR_PAYMENT_SCHEDULES_ALL ARPS,                PQINF.XXPQ_EDI_IP_INV_PICK EDIP          --PQINF.XXPQ_EDI_MX_PAYMENT_DETAILS MXPD          WHERE     ARPS.TRX_NUMBER = EDIP.INVOICE_NUMBER                AND EDIP.COUNTRY = 'MX'                AND EDIP.INVOICE_NUMBER NOT IN (SELECT INVOICE_NUMBER FROM PQINF.XXPQ_EDI_MX_PAYMENT_DETAILS)                AND EDIP.PROCESS_FLAG='Y'                AND ARPS.AMOUNT_DUE_ORIGINAL <> ARPS.AMOUNT_DUE_REMAINING                AND TRUNC (ARPS.LAST_UPDATE_DATE) BETWEEN P_FROM_DATE                                                      AND P_TO_DATE;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center