This app template uses Oracle E-Business Suite (EBS), versions 12.2.1 or higher as source system.
Extraction for the system is done using CData Sync. To set-up the extraction, make sure you have a valid license for CData Sync and have installed CData Sync.
To be able to extract data from Oracle EBS, a user should be created with permissions to read the data. Next to the username and corresponding password, the port used to connect to the server hosting the Oracle database and the service name of the Oracle database needs to be available. You can obtain this value by querying global_name (select * from global_name)
using the Oracle SQL*PLUS command line.
To set up the destination connection, follow the steps as defined in Create a destination connection (Automation Cloud). Note: If you are using Automation Suite, make sure to select AUTOMATION SUITE
as the DELIVERY
option and select the correct version of Automation Suite you are using.
To create the Job in CData make sure to follow the steps below.
In the Advanced tab in the Job Settings panel, define the following settings:
Important: Make sure you edit the Pre-job Event.
CData Sync allows the use of environment variables in order to drive specific extraction logic in each query.
Variable | Description | Comment |
---|---|---|
start_extraction_date | Defines first date for which data will be extracted. | Mandatory |
end_extraction_date | Last date for which data will be extracted. |
In order to setup the environment variables:
Step | Action |
---|---|
1 | Go to the Events tab in the Job Settings panel of the job you are creating |
2 | Edit the Pre-Job Event section to add the code displayed below after <!-- Code goes here -- > . Do not modify the api:info details that are shown by default. |
3 | Click on Save Changes. |
<!-- Modify environment variables here. -->
<!-- Variable start_extraction_date must be populated.-->
<api:set attr="out.env:start_extraction_date" value= "01/jan/2000" />
<!-- In case a specific end date is needed, replace the value string with the required date in the Date format listed in Oracle EBS. -->
<!-- i.e api:set attr="out.env:end_extraction_date" value="01/jan/2000" -->
<api:set attr="out.env:end_extraction_date" value= "01/jan/3000" />
<api:push item="out" />
By default, end_extraction_date
will default to today's date. start_extraction_date
must always be populated.
After the data has been successfully loaded, the Process Mining platform needs to start the data ingestion process. This is done by calling the End of Upload API. In order to set this up, follow the steps below:
Step | Action |
---|---|
1 | Go to the Events tab in the Job Settings panel of the job you are creating |
2 | Edit the Post-Job Event section to add the code displayed below after <!-- Code goes here -- > . Do not modify the api:info details that are shown by default. |
3 | Fill out the End of Upload API with the value provided. |
4 | In case you need a debugging log for this call, uncomment the two lines provided in the code below and provide a location for the log file. |
5 | Click on Save Changes. |
<api:set attr="http.url" value="END_OF_UPLOAD_API"/>
<!-- <api:set attr="http.verbosity" value="5"/> -->
<!-- <api:set attr="http.logfile" value="D:/mydir/cdata_log.txt"/> -->
<api:call op="httpPost" in="http"/>
Once the job is correctly setup, click on Add Custom Query under the Tables tab and paste the following queries (each query needs to maintain the semicolon at the end). Make sure you save all changes.
Use the following custom query when creating the job:
REPLICATE [PO_REQUISITION_HEADERS_ALL] SELECT [REQUISITION_HEADER_ID], [AUTHORIZATION_STATUS], [ORG_ID], [SEGMENT1], [TYPE_LOOKUP_CODE] FROM [PO].[PO_REQUISITION_HEADERS_ALL];
REPLICATE [PO_REQUISITION_LINES_ALL] SELECT [REQUISITION_HEADER_ID], [REQUISITION_LINE_ID], [LINE_LOCATION_ID], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY], [ITEM_DESCRIPTION], [QUANTITY], [UNIT_MEAS_LOOKUP_CODE], [UNIT_PRICE], [LINE_NUM], [RATE], [CATEGORY_ID] FROM [PO].[PO_REQUISITION_LINES_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [PO_HEADERS_ALL] SELECT [PO_HEADER_ID], [AUTHORIZATION_STATUS], [TYPE_LOOKUP_CODE], [COMMENTS], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY], [ORG_ID], [BILL_TO_LOCATION_ID], [SHIP_TO_LOCATION_ID], [VENDOR_ID], [SEGMENT1], [RATE] FROM [PO].[PO_HEADERS_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [PO_LINES_ALL] SELECT [PO_LINE_ID], [PO_HEADER_ID], [CATEGORY_ID], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [ITEM_DESCRIPTION], [UNIT_MEAS_LOOKUP_CODE], [QUANTITY], [LINE_NUM], [UNIT_PRICE] FROM [PO].[PO_LINES_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [PO_LINE_LOCATIONS_ALL] SELECT [LINE_LOCATION_ID], [PO_LINE_ID], TO_CHAR([PROMISED_DATE], 'yyyy-MM-dd hh:mm:ss') AS [PROMISED_DATE], TO_CHAR([NEED_BY_DATE], 'yyyy-MM-dd hh:mm:ss') AS [NEED_BY_DATE] FROM [PO].[PO_LINE_LOCATIONS_ALL];
REPLICATE [RCV_SHIPMENT_LINES] SELECT [SHIPMENT_LINE_ID], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY], [PO_LINE_ID], [COMMENTS] FROM [PO].[RCV_SHIPMENT_LINES] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [RCV_TRANSACTIONS] SELECT [COMMENTS#1] AS [COMMENTS], [CREATED_BY], [CUSTOMER_ID], [TRANSACTION_TYPE], TO_CHAR([TRANSACTION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [TRANSACTION_DATE], [SHIPMENT_LINE_ID], [PO_LINE_ID] FROM [PO].[RCV_TRANSACTIONS];
REPLICATE [AP_CHECKS_ALL] SELECT [CHECK_ID], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY] FROM [AP].[AP_CHECKS_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [AP_INVOICES_ALL] SELECT [INVOICE_ID], [ORG_ID], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY], [DESCRIPTION], [EXCHANGE_RATE], TO_CHAR([INVOICE_DATE], 'yyyy-MM-dd hh:mm:ss') AS [INVOICE_DATE], TO_CHAR([TERMS_DATE], 'yyyy-MM-dd hh:mm:ss') AS [TERMS_DATE], TO_CHAR([GL_DATE], 'yyyy-MM-dd hh:mm:ss') AS [GL_DATE], [TERMS_ID], [PAYMENT_METHOD_CODE], [INVOICE_TYPE_LOOKUP_CODE], [INVOICE_NUM] FROM [AP].[AP_INVOICES_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [AP_INVOICE_LINES_ALL] SELECT [INVOICE_ID], [LINE_NUMBER], [AMOUNT], [ITEM_DESCRIPTION], [PERIOD_NAME], [PO_LINE_ID], [QUANTITY_INVOICED], [UNIT_MEAS_LOOKUP_CODE], [MANUFACTURER] FROM [AP].[AP_INVOICE_LINES_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [AP_INVOICE_PAYMENTS_ALL] SELECT [INVOICE_ID], [INVOICE_PAYMENT_ID], [CHECK_ID], [POSTED_FLAG], TO_CHAR([CREATION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [CREATION_DATE], [CREATED_BY] FROM [AP].[AP_INVOICE_PAYMENTS_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [AP_SUPPLIERS] SELECT [VENDOR_ID], [VENDOR_NAME], [ONE_TIME_FLAG], [PARTY_ID] FROM [AP].[AP_SUPPLIERS];
REPLICATE [AP_TERMS_LINES] SELECT [TERM_ID], [DISCOUNT_PERCENT], [DISCOUNT_DAYS], [DISCOUNT_PERCENT_2], [DISCOUNT_DAYS_2], [DISCOUNT_MONTHS_FORWARD], [DISCOUNT_MONTHS_FORWARD_2], [DUE_DAYS], [ATTRIBUTE_CATEGORY], [SEQUENCE_NUM] FROM [AP].[AP_TERMS_LINES] WHERE [SEQUENCE_NUM] = 1;
REPLICATE [HZ_CUST_ACCOUNTS] SELECT [CUST_ACCOUNT_ID], [ACCOUNT_NAME], [PARTY_ID] FROM [AR].[HZ_CUST_ACCOUNTS];
REPLICATE [HR_LOCATIONS_ALL] SELECT [LOCATION_ID], [DESCRIPTION] FROM [HR].[HR_LOCATIONS_ALL];
REPLICATE [HR_ALL_ORGANIZATION_UNITS] SELECT [ORGANIZATION_ID], [NAME] FROM [HR].[HR_ALL_ORGANIZATION_UNITS];
REPLICATE [HZ_PARTIES] SELECT [PARTY_ID], [COUNTRY], [COUNTY] FROM [AR].[HZ_PARTIES];
REPLICATE [PO_ACTION_HISTORY] SELECT [OBJECT_ID], [OBJECT_TYPE_CODE], [ACTION_CODE], TO_CHAR([ACTION_DATE], 'yyyy-MM-dd hh:mm:ss') AS [ACTION_DATE], [SEQUENCE_NUM], [NOTE], [EMPLOYEE_ID] FROM [PO].[PO_ACTION_HISTORY] WHERE [ACTION_CODE] IN ('ACCEPT', 'APPROVE', 'HOLD', 'CLOSE', 'OPEN', 'REJECT', 'CANCEL') AND ([ACTION_DATE] >= '{env:start_extraction_date}') AND ([ACTION_DATE] <= '{env:end_extraction_date}');
REPLICATE [PO_DOCUMENT_TYPES_ALL_TL] SELECT [DOCUMENT_TYPE_CODE], [DOCUMENT_SUBTYPE], [ORG_ID], [TYPE_NAME], [LANGUAGE] FROM [PO].[PO_DOCUMENT_TYPES_ALL_TL] WHERE [LANGUAGE] = 'US';
REPLICATE [PO_LINES_ARCHIVE_ALL] SELECT [PO_LINE_ID], TO_CHAR([LAST_UPDATE_DATE], 'yyyy-MM-dd hh:mm:ss') AS [LAST_UPDATE_DATE], [LAST_UPDATED_BY], [PO_HEADER_ID], [UNIT_PRICE], [QUANTITY], [REVISION_NUM] FROM [PO].[PO_LINES_ARCHIVE_ALL] WHERE ([CREATION_DATE] >= '{env:start_extraction_date}') AND ([CREATION_DATE] <= '{env:end_extraction_date}');
REPLICATE [FND_USER] SELECT [USER_ID], [USER_NAME], [DESCRIPTION] FROM [APPLSYS].[FND_USER];
REPLICATE [MTL_CATEGORIES_B] SELECT [CATEGORY_ID], [ATTRIBUTE_CATEGORY] FROM [INV].[MTL_CATEGORIES_B];
The following table provides an overview of the different field types and their default format settings.
Field type | Description |
---|---|
boolean | true , false , 1 , 0 |
date | yyyy-mm-dd |
datetime | yyyy-mm-dd hh:mm:ss |
double | Decimal separator: . (dot); thousand separator: none |
integer | Thousand separator: none |
text | N/A |
The following tables are extracted from the source system:
List of all files in the sample data directory, without the csv extension:
More information on this table can be found here.
Field | Type | Description |
---|---|---|
CHECK_ID | Text | Payment identifier |
CREATION_DATE | Datetime | Date when this row was created |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
INVOICE_ID | Text | Invoice identifier |
LINE_NUMBER | Text | Invoice line number |
AMOUNT | Double | Line amount in invoice currency |
ITEM_DESCRIPTION | Text | Item description |
PERIOD_NAME | Text | Accounting date for invoice line |
PO_LINE_ID | Text | Purchase order line unique identifier |
QUANTITY_INVOICED | Text | Quantity invoiced |
UNIT_MEAS_LOOKUP_CODE | Text | Unit of measure for QUANTITY_INVOICED |
MANUFACTURER | Text | Name of manufacturer |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
INVOICE_ID | Text | Invoice identifier |
INVOICE_PAYMENT_ID | Text | Invoice payment unique identifier |
CHECK_ID | Text | The payment identifier is a unique sequential number to identify a payment. Foreign key to the AP_CHECKS_ALL |
POSTED_FLAG | Text | Flag that indicates if the payment has been accounted (Y or N) |
CREATION_DATE | Datetime | Date when this row was created |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
INVOICE_ID | Text | Invoice identifier |
ORG_ID | Text | Organization identifier |
CREATION_DATE | Datetime | Date when this row was created |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
DESCRIPTION | Text | Description |
EXCHANGE_RATE | Double | Exchange rate for foreign currency invoice |
INVOICE_DATE | Datetime | Invoice date |
TERMS_DATE | Datetime | Date used with payment terms to calculate scheduled payment of an invoice |
GL_DATE | Datetime | Accounting date to default to invoice distributions |
TERMS_ID | Integer | Payment terms identifier |
PAYMENT_METHOD_CODE | Text | Payment method identifier |
INVOICE_TYPE_LOOKUP_CODE | Text | Type of invoice |
INVOICE_NUM | Text | Invoice number |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
VENDOR_ID | Text | Supplier unique identifier |
VENDOR_NAME | Text | Supplier name |
ONE_TIME_FLAG | Text | Indicates whether the supplier is a one-time supplier (Y or N) |
PARTY_ID | Text | Party Identifier |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
TERM_ID | Text | Term identifier |
DISCOUNT_PERCENT | Double | Percentage used to calculate discount available for invoice payment line |
DISCOUNT_DAYS | Integer | Number of days after terms date, used to calculate discount date for invoice payment line |
DISCOUNT_PERCENT_2 | Double | Percentage used to calculate second discount available for invoice payment line |
DISCOUNT_DAYS_2 | Integer | Number of days after terms date, used to calculate second discount available for invoice payment line |
DUE_DAYS | Integer | Number of days after terms date, used to calculate due date of invoice payment line |
ATTRIBUTE_CATEGORY | Text | Attribute description |
SEQUENCE_NUM | Integer | Sequence number |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
USER_ID | Text | Application user identifier |
USER_NAME | Text | Application username |
DESCRIPTION | Text | User Description |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
ORGANIZATION_ID | Text | Organization identifier |
NAME | Text | Name of the organization |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
LOCATION_ID | Text | System-generated primary key column |
DESCRIPTION | Text | Brief description of the location |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
CUST_ACCOUNT_ID | Text | Customer account identifier |
ACCOUNT_NAME | Text | Account name |
PARTY_ID | Text | Party identifier |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
PARTY_ID | Text | Party identifier |
COUNTRY | Text | Country of the Identifying address |
COUNTY | Text | County of the Identifying address |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
CATEGORY_ID | Text | Category identifier |
ATTRIBUTE_CATEGORY | Text | Attribute description |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
OBJECT_ID | Text | Document header unique identifier |
OBJECT_TYPE_CODE | Text | Document type |
ACTION_CODE | Text | Approval or control action type |
ACTION_DATE | Datetime | Approval or control action date |
SEQUENCE_NUM | Integer | Sequence of the approval or control action for a document |
NOTE | Text | Note for next approver or reason for control action |
EMPLOYEE_ID | Text | Unique identifier of the employee taking the action |
Filtering: ACTION_DATE
is used for time-based filtering. Furthermore, only records for which the ACTION_CODE
is any of the following values are selected: ACCEPT
, APPROVE
, HOLD
, CLOSE
, OPEN
, REJECT
, CANCEL
.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
DOCUMENT_TYPE_CODE | Text | Document type |
DOCUMENT_SUBTYPE | Text | Document subtype |
ORG_ID | Integer | Organization identifier |
TYPE_NAME | Text | Document type name |
LANGUAGE | Text | Language |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
PO_HEADER_ID | Text | Purchase order header unique identifier |
AUTHORIZATION_STATUS | Text | Authorization status of the purchase order |
TYPE_LOOKUP_CODE | Text | Type of the document |
COMMENTS | Text | Descriptive comments for the document |
CREATION_DATE | Datetime | Date when this row was created |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
ORG_ID | Text | Organization identifier |
BILL_TO_LOCATION_ID | Text | Bill-to location unique identifier |
SHIP_TO_LOCATION_ID | Text | Ship-to location unique identifier |
VENDOR_ID | Text | Supplier unique identifier |
SEGMENT1 | Text | Key flexfield segment (contains front-end documentation identifier) |
RATE | Double | Currency conversion rate |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
LINE_LOCATION_ID | Text | Document shipment schedule unique identifier |
PO_LINE_ID | Text | Purchase order line unique identifier |
PROMISED_DATE | Datetime | Supplier promised delivery date |
NEED_BY_DATE | Datetime | Need-by date for the shipment schedule |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
PO_LINE_ID | Text | Purchase order line unique identifier |
PO_HEADER_ID | Text | Purchase order header unique identifier |
CATEGORY_ID | Text | Item category unique identifier |
CREATION_DATE | Datetime | Date when this row was created |
ITEM_DESCRIPTION | Text | Item description |
UNIT_MEAS_LOOKUP_CODE | Text | Unit of measure |
QUANTITY | Double | Quantity ordered on the line |
LINE_NUM | Double | Line number |
UNIT_PRICE | Double | Unit price in functional currency |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
PO_LINE_ID | Text | Purchase order line unique identifier |
CREATION_DATE | Datetime | Date when this row was created |
LAST_UPDATE_DATE | Date | date when a user last updated this row |
LAST_UPDATED_BY | Text | User who last updated this row (foreign key to FND_USER.USER_ID) |
PO_HEADER_ID | Text | Purchase order header unique identifier |
UNIT_PRICE | Double | Unit price for the line |
QUANTITY | Double | Quantity ordered on the line |
REVISION_NUM | Integer | Document revision number |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
REQUISITION_HEADER_ID | Text | Requisition header unique identifier |
AUTHORIZATION_STATUS | Text | Authorization status type |
ORG_ID | Text | Organization identifier |
SEGMENT1 | Text | Key flexfield segment (contains front-end documentation identifier) |
TYPE_LOOKUP_CODE | Text | Requisition type |
More information on this table can be found here.
Field | Type | Description |
---|---|---|
REQUISITION_HEADER_ID | Text | Requisition header unique identifier |
REQUISITION_LINE_ID | Text | Requisition line unique identifier |
LINE_LOCATION_ID | Text | Document shipment schedule unique identifier |
CREATION_DATE | Datetime | Row creation date |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
ITEM_DESCRIPTION | Text | Item description |
QUANTITY | Double | Quantity ordered |
UNIT_MEAS_LOOKUP_CODE | Text | Unit of measure |
UNIT_PRICE | Double | Unit price in functional currency |
LINE_NUM | Double | Line number |
RATE | Double | Currency conversion rate |
CATEGORY_ID | Text | Item category unique identifier |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
SHIPMENT_LINE_ID | Text | Receipt shipment line unique identifier |
CREATION_DATE | Datetime | Date when this row was created |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
PO_LINE_ID | Text | Purchase order line unique identifier |
COMMENTS | Text | Receiver comments |
Filtering: CREATION_DATE
is used for time-based filtering.
More information on this table can be found here.
Field | Type | Description |
---|---|---|
COMMENTS | Text | Receiver comments |
CREATED_BY | Text | User who created this row (foreign key to FND_USER.USER_ID) |
CUSTOMER_ID | Text | Customer unique identifier |
TRANSACTION_TYPE | Text | Receiving transaction type |
TRANSACTION_DATE | Datetime | Transaction date |
SHIPMENT_LINE_ID | Text | Receipt shipment line unique identifier |
PO_LINE_ID | Text | Purchase order line unique identifier |
Filtering: CREATION_DATE
is used for time-based filtering.
This seed file is used to add automation-related properties to each activity, used for the automation potential dashboard. For more information, see Simulating Automation Potential.
Field | Type | Description |
---|---|---|
Activity | Text | Display name for the activity |
Event_cost | Double | Cost associated with the activity |
Event_processing_time | Integer | Processing time associated with the activity (in milliseconds) |
This seed file is used to define properties for the due dates. For more information, see Due Dates.
Field | Type | Description |
---|---|---|
Due_date | Text | The name of the due date |
Due_date_type | Text | The Due date type |
Fixed_costs | Boolean | An indication whether costs are fixed or time based |
Cost | Double | Fixed costs: The amount of costs. Variable costs: The amount of costs per Time and Time_type |
Time | Integer | A number indicating the amount of time in case of time-based costs |
Time_type | Text | Type of time period for cost calculations. This can be any of the following values: day , hour , minute , second or millisecond |
Variable | Type | Description |
---|---|---|
date_format | Text | Format for parsing date fields. |
datetime_format | Text | Format for parsing datetime fields. |
Automated_users | List of integer | List of automated users. The values referenced are USER_ID values from the FND_USER table. |
Language | Text | Language used for PO Document types (PO_DOCUMENT_TYPES_ALL_TL ). Default value is US |
Entity | Input Data |
---|---|
Purchase_requisitions_base | PO_REQUISITION_LINES_ALL ,PO_REQUISITION_HEADERS_ALL ,PO_REQUISITION_HEADERS_ALL ,PO_DOCUMENT_TYPES_ALL_TL ,MTL_CATEGORIES_B ,FND_USERS |
Purchase_orders_base | PO_HEADERS_ALL ,PO_DOCUMENT_TYPES_ALL_TL ,HR_ALL_ORGANIZATION_UNITS ,FND_USERS ,AP_SUPPLIERS ,HZ_PARTIES ,HR_ALL_ORGANIZATION_UNITS |
Purchase_order_items_base | PO_LINES_ALL ,PO_LINE_LOCATIONS_ALL ,PO_REQUISITION_LINES_ALL ,PO_HEADERS_ALL ,HR_LOCATIONS_ALL ,HZ_CUST_ACCOUNTS ,MTL_CATEGORIES_B ,RCV_TRANSACTIONS ,HZ_PARTIES |
Goods_receipt_base | RCV_SHIPMENT_LINES |
Invoices_base | AP_INVOICES_ALL ,AP_TERMS_ALL ,FND_USERS ,HR_ALL_ORGANIZATION_UNITS |
Invoice_items_base | AP_INVOICES_LINES_ALL ,AP_INVOICES_ALL |
Accounting_documents_base | AP_INVOICE_PAYMENTS_ALL |
Payments_base | AP_INVOICE_PAYMENTS_ALL |
Activity | Entity | Description |
---|---|---|
Create purchase requisition item | Purchase Requisition | This identifies the creation of a purchase requisition item. |
<ACTION> purchase requisition | Purchase Requisition | This identifies a change to the status of a purchase requisition. The name is based on the value of ACTION_CODE (e.g. Approve, Reject) |
Create purchase order | Purchase Order | This identifies the creation of a purchase order. |
<ACTION> purchase order | Purchase Order | This identifies a series of changes to the status of a purchase order. The name is based on the value of ACTION_CODE (e.g. Approve, Reject) |
Create purchase order item | Purchase order item | This identifies the creation action of a purchase order item. |
Change purchase order item unit price | Purchase order item | This identifies the change action to a purchase order item's unit price. |
Change purchaase order item unit quantity | Purchase order item | This identifies the change action to a purchase order item's quantity. |
Create goods receipt | Goods receipt | This identifies the creation action of a shipment item. |
Receive goods receipt | Goods receipt | This identifies the receipt of a shipment. |
Create return to vendor | Goods receipt | This identifies the creation of a return to vendor. |
Create goods receipt Correction | Goods receipt | This identifies the creation of a goods receipt correction. |
Create goods receipt Transfer | Goods receipt | This identifies the creation of a goods receipt transfer. |
Accept goods receipt | Goods receipt | This identifies the acception of a goods receipt. |
Reject goods receipt | Goods receipt | This identifies the rejection of a goods receipt. |
Create invoice | Invoice | This identifies the creation action of an invoice. |
Create invoice item | Invoice item | This identifies the creation action of an invoice item. |
Create payment | Payment | This identifies the creation action of a payment. |
Pay invoice | Payment | This identifies the payment of an invoice. |
TO_CHAR
query statements for CData extraction may occasionally cut the timestamp off (i.e. provide 2020-01-
) rather than return the full timestamp. When this occurs, re-run the query and the issue should be rectified.COMMENTS
column in RCV_TRANSACTIONS
may be titled COMMENTS#1
in your version of Oracle EBS. Keep this in mind if there is a failure on the extraction of this table.