Siebel Application Services Interface Reference > Predefined Application Service Interfaces >

Siebel Forecast


The Siebel Forecast ASI consists of internal and external integration objects and a business service. This ASI facilitates the outbound data synchronization between the Siebel application and an external back-office system. This ASI is used by the Export Forecast business process, which queries the Siebel application for data on a given forecast and returns the data to a back-office system.

Figure 20 describes the Siebel Forecast ASI structure.

Figure 20. Siebel Forecast ASI

Table 30 lists the integration components and user keys of the Siebel Forecast ASI.

Table 30. Siebel Forecast Integration Components
Integration Component
XML Tag
User Keys

Forecast

Forecast

  1. Forecast Number

Forecast Item Detail Flat

ForecastItemDetailFlat

1 Detail Date
  1. Forecast Item Id
  2. Owner Forecast Id

Table 31 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.

Table 31. Siebel Forecast ASI Fields
Name
XML Tag
Data Type
Length
Req.

Forecast

Archive Timestamp

ArchiveTimestamp

DTYPE_TEXT

Not applicable

No

Created By Login

CreatedByLogin

DTYPE_TEXT

50

No

Forecast Base Period Type

ForecastBasePeriodType

DTYPE_TEXT

30

No

Forecast Date

ForecastDate

DTYPE_TEXT

Not applicable

No

Forecast End Date

ForecastEndDate

DTYPE_TEXT

Not applicable

No

Forecast Id

ForecastId

DTYPE_ID

15

No

Forecast Name

ForecastSeriesName

DTYPE_TEXT

20

No

Forecast Number

ForecastNumber

DTYPE_TEXT

30

No

Forecast Start Date

ForecastStartDate

DTYPE_TEXT

Not applicable

No

operation

operation

DTYPE_TEXT

30

No

Owner Organization Id

OwnerOrganizationId

DTYPE_ID

15

No

Owner Position Id

OwnerPositionId

DTYPE_ID

15

No

Forecast Item Detail Flat

Account Id

AccountId

DTYPE_ID

15

No

Amount Revenue

Revenue

DTYPE_TEXT

Not applicable

No

Best Case

BestCase

DTYPE_TEXT

Not applicable

No

Commit Flag

CommitFlag

DTYPE_TEXT

1

No

Cost

Cost

DTYPE_TEXT

Not applicable

No

Currency

CurrencyCode

DTYPE_TEXT

Not applicable

No

Detail Date

DetailDate

DTYPE_TEXT

Not applicable

No

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

Forecast Id

ForecastId

DTYPE_ID

15

No

Forecast Item Id

ForecastItemId

DTYPE_ID

15

No

Id

Id

DTYPE_ID

15

No

Link Type

LinkType

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

Opportunity Id

OpportunityId

DTYPE_ID

15

No

Organization Id

OrganizationId

DTYPE_ID

15

No

Owner Forecast Id

OwnerForecastId

DTYPE_ID

15

No

Primary Product Line Id

ProductLineId

DTYPE_ID

15

No

Product Id

ProductId

DTYPE_ID

15

No

Product Price

ProductPrice

DTYPE_TEXT

Not applicable

No

Product Quantity

ProductQuantity

DTYPE_TEXT

Not applicable

No

Sales Rep Id

SalesRepPositionId

DTYPE_ID

15

No

Service Request Id

ServiceRequestId

DTYPE_ID

15

No

Unit of Measure

UnitOfMeasure

DTYPE_TEXT

30

No

Worst Case

WorstCase

DTYPE_TEXT

 

No

Siebel Application Services Interface Reference Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.