Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
API to reset the last extract date in BICC PVOs
Comments
-
Very much required to automate the BICC jobs.
0 -
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.
0