API to reset the last extract date in BICC PVOs

Jerry Sebastian

Very much required to automate the BICC jobs.

Antariksh Kar-Oracle

You could update Job using Manage "Meta Data REST API"

PUT /meta/jobs/

Sample Request Body

{

"dataStores": [

  {

"dataStoreMeta": {

"columns": [

  {

    "name": "CreatedBy",

    "isPrimaryKey": false,

    "isPopulate": false,

    "isLastUpdateDate": false,

    "isNaturalKey": false,

    "isEffectiveStartDate": false,

    "isCreationDate": false,

    "colConversion": null

},

  {

    "name": "CreationDate",

    "isPrimaryKey": false,

    "isPopulate": false,

    "isLastUpdateDate": false,

    "isNaturalKey": false,

    "isEffectiveStartDate": false,

    "isCreationDate": true,

    "colConversion": null

},

  {

    "name": "EnabledFlag",

    "isPrimaryKey": false,

    "isPopulate": false,

    "isLastUpdateDate": false,

    "isNaturalKey": false,

    "isEffectiveStartDate": false,

    "isCreationDate": false,

    "colConversion": null

},

  {

    "name": "LastUpdateDate",

    "isPrimaryKey": false,

    "isPopulate": false,

    "isLastUpdateDate": false,

    "isNaturalKey": false,

    "isEffectiveStartDate": false,

    "isCreationDate": false,

    "colConversion": null

},

  {

    "name": "LastUpdatedBy",

    "isPrimaryKey": false,

    "isPopulate": false,

    "isLastUpdateDate": false,

    "isNaturalKey": false,

    "isEffectiveStartDate": false,

    "isCreationDate": false,

    "colConversion": null

],

    "dataStoreKey": "FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderPVO",

    "filters": "__DATASTORE__.JrnlHdrPeriodName = 'Nov-21' and DATASTORE.JournalBatchPostingStatusCode = 'P'",

"isEffectiveDateDisabled": false,

"isFlexDataStore": false,

"isSilentError": true,

"initialExtractDate": null,

"chunkType": null,

"chunkDateSeqIncr": 0,

"chunkDateSeqMin": 0,

"chunkPkSeqIncr": 0,

"useUnionForIncremental": false

},
"lastExtractDate": "2021-04-01T21:19:30.000",

"groupNumber": 0,

"groupItemPriority": 0

}

],

"schedules": null,

"name": "CFA_RFR_GL_FULL_CUSTOM_JOB",

"description": "FULL Period Extract Job to sync FCR GL Transaction sync

tables from ERP"

}

Send desired value to "lastExtractDate" field.