Oracle® Application Integration Architecture Oracle Financial Operations Control Integration Pack Implementation Guide for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials Release 3.1 Part Number E20500-01 |
|
|
PDF · Mobi · ePub |
This chapter discusses how to configure the Oracle Financial Operations Control Integration Pack for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials.
This chapter includes the following sections:
Section 7.6, "Setting Up Cross-References for Oracle Retail IDs and PeopleSoft Entities"
Section 7.9, "Manually Synchronizing Currency Exchange Rate Types"
Section 7.11, "Manually Synchronizing Chart of Accounts Values"
You must set up Oracle Retail applications, PeopleSoft General Ledger (GL), and PeopleSoft Payables for the Oracle Retail to PeopleSoft process integration pack (PIP) to work properly. This chapter describes these setups in detail.
This section discusses the prerequisites for the following integrations:
Currency exchange rate
Payment term
Supplier information
Inventory valuation and revenue recognition accounting entries
Retail Merchandise procure to pay
Drill back and drill forward
The prerequisites include:
Maintain the list of valid currencies separately in each application and synchronize the currencies manually.
Map currency exchange rate types between PeopleSoft applications and Oracle Retail.
Oracle Retail and PeopleSoft applications maintain the exchange rate types manually. Oracle Retail maps the PeopleSoft exchange rate types to the Oracle Retail exchange rates types with a local process.
The prerequisites include:
Initially load the ORGANIZATION_ID cross-reference table using the manual process. This step takes place post installation. The values for the xml file come from both the PeopleSoft system and the Oracle Retail system. The common values are decided on between them.
For more information about initial load of the ORGANIZATION_ID cross-reference table, see Section 7.6, "Setting Up Cross-References for Oracle Retail IDs and PeopleSoft Entities."
Synchronize payment terms using the Oracle AIA process.
Synchronize freight terms using the manual process.
The prerequisites include:
Enter these domain value maps (DVMs) using Oracle JDeveloper, and export and set up the following in the PeopleSoft system:
BUSINESS_UNIT
CURRENCY_CODE
Create these views in the Oracle Retail database:
FIF_STG_GL_DATA_VW
IM_FINANCIALS_STG_VW
Set up the AIAConfigurationProperties.XML file.
The prerequisites include:
Synchronize suppliers and their locations, payment terms, and currency exchange rates between the Oracle Retail and PeopleSoft applications.
Map chart of accounts segments between the Oracle Retail and PeopleSoft applications.
Validate chart of accounts code combinations.
Set up a calendar for transactions.
Import PIP ODI Artifacts (code) and configure connections.
The prerequisites include:
Set up, configure and put into production PeopleSoft GL and Payables and Oracle Retail implementations.
Integrate accounting entries and invoice data from Oracle Retail to the PeopleSoft applications.
Install and configure Oracle BI Publisher for Oracle Retail.
Run the Invoice Oracle Data Integrator (ODI) flow.
Data requirements indicate the mandatory data that must be provided to make the integration flows successful.
This section discusses the data requirements of the following process integrations:
Currency exchange rate
Payment term
Supplier information
Chart of Accounts validation
Inventory valuation and revenue recognition accounting entries
Retail Merchandise procure to pay
Drill back and drill forward
No data requirements exist for this process integration.
The process integration for payment term requires:
In PeopleSoft Payables, payment terms must be assigned to at least one set of books (GL business unit or AP business unit or both) upon creation and generation of ABM.
Assignment of payment terms to additional set of books (GL business unit or AP business unit or both) generates an ABM for this event.
Figure 7-1, Figure 7-2, and Figure 7-3 are class diagrams for payment term integration.
The process integration for supplier information requires:
Suppliers must be assigned to at least one GL business unit (set of books).
PeopleSoft suppliers must be created with these status attributes:
Approved.
Classification of supplier.
Other type of vendors, such as attorneys, employees, and HCM, are not synchronized with Oracle Retail.
The Open for ordering option is selected.
If the supplier is approved but is not open for ordering, the Oracle AIA layer on the Oracle RMS side changes its status to inactive.
Suppliers must have been assigned at least one Order from address.
Suppliers must have been assigned at least one Remit to Location address.
Figure 7-4, Figure 7-5, and Figure 7-6 are the class diagrams for supplier integration.
You must manually enter the segment combinations in the GL ACCOUNT MAINTENANCE (Oracle ReSA), GL CROSS REFERENCE (Oracle RMS), and GL CROSS REFERENCE (Oracle ReIM) forms.
No data requirements exist for this process integration.
No data requirements exist for this process integration.
The accounting entry and invoice ODI integration flows were run.
For more information, see Section 4.1, "Process Integration for Inventory Valuation and Revenue Recognition Accounting Entries Overview" and Section 5.1, "Process Integration for Retail Merchandise Procure to Pay Overview.".
Before integration, you must set up Oracle Retail Merchandising System (Oracle RMS), Oracle Retail Invoice Matching (Oracle ReIM), and Oracle Retail Sales Audit (Oracle ReSA).
For more information about setting up Oracle Retail applications, see the ReIM Operations Guide, "PeopleSoft Enterprise Financials Integration" and the RMS Operations Guide, "AIA Financials Integration."
To set up PeopleSoft GL, perform these actions:
Activate service operations, queue, and handlers.
Activate or create routings.
Set up end points (connector properties) for provided services.
Set up recurring run controls for delayed publishing of effective-dated objects.
Activate validation service operations.
Set up cross-reference tables.
Synchronize currency exchange rates.
For more information, see PeopleSoft Enterprise Installation Documentation Update: Oracle Retail Management Integration.
To set up PeopleSoft Payables, perform these actions:
Activate service operations, queue, and handlers.
Activate or create routings.
Set up end points (connector properties) for provided services.
Set up recurring run controls for delayed publishing of effective-dated objects.
Activate validation service operations.
Set up cross-reference tables.
Synchronize payment terms and vendors.
For more information, see PeopleSoft Enterprise Installation Documentation Update: Oracle Retail Management Integration.
Before running the supplier flow, you must load the initial ORGANIZATION_ID cross-reference table. Because no automated process for this synchronization is available, you must load this table manually.
This section discusses the following topics:
You must manually populate the ORGANIZATION_ID cross-reference table after the install because no process flow exists for this synchronization. Manually add the data into this table using the sql insert statements. The ORGANIZATION_ID table holds the information for business units among the edge applications and the common value.
Sample sql statement:
RETL_01:
INSERT INTO "AIA30_XREF"."XREF_DATA" (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'RETL_01', 'sdfsdklfjere657654', '333333333333333', 'N', TO_TIMESTAMP('15-FEB-10 10.48.33.', 'DD-MON-RR HH.MI.SS.FF AM'))
PSFT_01:
INSERT INTO "AIA30_XREF"."XREF_DATA" (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'PSFT_01', 'sdfsdklfjere657654', 'US01', 'N', TO_TIMESTAMP('15-FEB-10 10.48.33.', 'DD-MON-RR HH.MI.SS.FF AM'))
COMMON:
INSERT INTO "AIA30_XREF"."XREF_DATA" (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'COMMON', 'sdfsdklfjere657654', '4522145', 'N', TO_TIMESTAMP('15-FEB-10 10.48.33.', 'DD-MON-RR HH.MI.SS.FF AM'))
For each set, which includes RETL_01, PSFT_01, and COMMON, the row numbers must be identical to link these records to each other.
Run the script for each business unit that you insert into the cross-reference table. Example 7-1 is an example organization.xml file.
Example 7-1 Sample Organization.xml
<xref xmlns="http://xmlns.oracle.com/xref"> <table name="ORGANIZATION_ID"> <columns> <column name="RETL_01"/> <column name="PSFT_01"/> </columns> <rows> <row> <cell colName="RETL_01">333333333333333</cell> <cell colName="PSFT_01">US001</cell> </row> <row> <cell colName="RETL_01">444444444444444</cell> <cell colName="PSFT_01">US002</cell> </row> <row> <cell colName="RETL_01">555555555555555</cell> <cell colName="PSFT_01">CAN01</cell> </row> </rows> </table> </xref>
Log in to your database.
Query the Table ORGANIZATION_ID to confirm that every organization/business unit used in the XML files has three records.
Use one query from the following:
select * from xref_data where xref_table_name='oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref'
select *from xref_data where xref_table_name='ORGANIZATION_ID' and xref_column_name='PSFT_01'
This query retrieves all records in the ORGANIZATION_ID TABLE.
You can modify this query to change the column names to RETL_01 and COMMON.
select * from xref_Data
where row_number in (select row_number from xref_Data where value = 'US01')
This query retrieves the three associated records for the org_id you selected.
Replace the value for the business unit you selected. (The number of business units depends on your setup.)
Validate each row for which the following three records are written:
RETL_01, PSFT_01 and COMMON
The three records should be linked to each other with a common row number value.
You can export or copy the data from SQL to an Excel spreadsheet. You can sort this data by row number, and so on.
You must sync the data in the cross-reference table with the Business Unit DVM in PeopleSoft. Because COMMON is an auto-generated guide and some of this data may not be known to the PeopleSoft customer, data visibility is essential. You must enter this data in the PeopleSoft DVM.
Copy and paste from the SQL Worksheet:
If you have access to the database, you also can copy the data into an Excel spreadsheet. From a sql worksheet:
Query on the table.
Select * from xref_data where xref_table_name='oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref'
Right-click in the displayed data, select all/copy, and paste it into an Excel spreadsheet.
Set up the PeopleSoft DVMs listed in Figure 7-6.
Name | Description |
---|---|
APBUtoOrgUnitDVM |
AP business unit to organization unit |
AccountTypes |
Account types mapping |
BULedgerDVM |
Business unit and ledger mapping |
CONVERSIONTYPECODE |
Rate type mapping |
CURRENCY95CODE |
Currency code mapping |
ChartFieldDVM |
ChartField mapping |
ChartfieldtoValueSet |
ChartField to ValueSet EBM |
CountryCodeDVM |
Country codes DVM |
LanguageCodeDVM |
Language code DVM |
RetailDefaultCurrency |
Default supplier currency |
RetailDefaultFreightTerms |
Default Retail freight terms |
RetailDefaultPayTerms |
Default Retail payment terms |
StateCodeDVM |
State and country table DVM |
VendorAddressTypeDVM |
Vendor address type DVM |
VendorStatusDVM |
Vendor status DVM |
For more information, see PeopleSoft Enterprise Installation Documentation Update: Oracle Retail Management Integration.
Freight is the transportation charge paid by retailers when they receive goods from a supplier. Freight term is an agreement between a retailer and a supplier regarding the type and payment of freight.
PeopleSoft Payables is the system of record. Oracle RMS requires the freight terms to generate purchase orders.
You set up PeopleSoft Payables freight term codes and their descriptions manually in Oracle RMS. Incremental changes in freight terms are manually synchronized from PeopleSoft Payables to Oracle RMS; these are not synchronized automatically.
For more information, see the PeopleSoft Enterprise Application Fundamentals PeopleBook, "Defining Financials and Supply Chain Management Common Definitions."
Oracle Retail allows for multiple currency exchange rate types (such as operational, consolidated, letter of credit or bank, purchase order, customs entry, and transportation) but uses only one type for the default processing-either Operational or Consolidation.
The PeopleSoft system supports any number of currency exchange rate types and allows for multiple currency exchange rate types. Because Oracle Retail uses only one currency exchange rate for the default processing, the system selects one exchange rate. All of the Oracle Retail products that integrate with PeopleSoft use the selected currency exchange rate.
The PeopleSoft system can have separate currency exchange rate types that are not integrated with Oracle Retail. The relationship between Oracle Retail and PeopleSoft rate types is mapped in a DVM table.
When you manually set up the selected currency exchange rate type in Oracle RMS, Oracle RMS uses the Currency Exchange Type Mapping window to map the external exchange type sent by the PeopleSoft system. Oracle Retail applications use this currency exchange rate type for all transactions.
Because the volume of currency exchange rate types is low, they are maintained and synchronized manually in PeopleSoft GL and Oracle RMS. They are not synchronized automatically. Synchronization is required for the currency exchange rates used by PeopleSoft GL and Oracle RMS.
For more information, see the PeopleSoft Enterprise Global Options and Reports PeopleBook, "Processing Multiple Currencies."
Oracle Retail and PeopleSoft GL synchronize the currency codes manually. The currency codes mapping between PeopleSoft GL and Oracle Retail is required for the sales audit and stock ledger transactions.
For more information, see the PeopleSoft Enterprise Components For FSCM PeopleBook, "Working With Currencies and Market Rates."
A chart of accounts is a listing of all the accounts in a general ledger. You can use a chart of accounts to view specific information about a transaction.
Oracle Retail uses the chart of accounts as reference information to create accounting entries for both sales and inventory transactions. PeopleSoft GL is the system of record for this information. Oracle Retail also stores and uses the GL accounts.
In PeopleSoft, the chart of accounts implies all the accounting ChartFields and values, such as chart of accounts, business unit, and setID. A chart of accounts includes account, department, operating unit, and other ChartFields. The attributes under each ChartField can differ from those of other ChartFields. For example, Account can have Account Number, Description, Account Type, Effective Date, and VAT Flag, and Department can have Department number, Description, Effective Date, and Manager.
You synchronize charts of accounts manually from PeopleSoft Payables to Oracle Retail. The system does not synchronize them automatically.
The manual setup and synchronization of the chart of accounts reference data includes:
Initial load of chart of accounts. For a new instance (logical or physical) of Oracle Retail, manually set up the valid chart of accounts segment or ChartFields values for each business unit.
Incremental chart of accounts synchronization. Manually synchronize new, changed, or deleted Segment or ChartField values from PeopleSoft to Oracle Retail.
The chart of accounts is validated based on the currently effective account code combinations. You must manually synchronize the most current active Chart of Account value row from PeopleSoft GL to Oracle Retail.
The PeopleSoft system can also create future-dated charts of accounts. You must manually update these future-dated charts of accounts when they become effective.
After the chart of accounts values are set up in both systems, each Oracle Retail transaction ready to be transmitted to the PeopleSoft system is validated.
For more information, see the PeopleSoft Enterprise Application Fundamentals PeopleBook, "Defining and Using ChartFields."
You manually maintain the calendars in Oracle Retail and PeopleSoft applications; the system does not synchronize them automatically.
For more information, see the PeopleSoft Enterprise Application Fundamentals PeopleBook, "Defining Accounting Calendars."
A business unit (BU) is an identification code that represents a high-level organization of business information. Use it to define regional or departmental units within a larger organization. A BU maintains its own set of transactions and may have ledgers containing any type of data, such as actual, budget, or forecast information. Transaction tables are keyed by BU. Each BU has a single base currency.
The set of books in Oracle Retail is equivalent to the PeopleSoft GL BU, ledger group, and setID. Many locations, such as warehouses and stores, in Oracle Retail belong to a set of books. The relationship is mapped in an Oracle AIA DVM table.
The Organization Unit in Oracle Retail is equivalent to the PeopleSoft AP BU and setID. You are not required to map setIDs on the Oracle Retail side. The Oracle Retail Organization Units (a group of locations) are mapped with the PeopleSoft Payables BUs.
The Oracle AIA layer maintains the mapping of the BU or setID to the set of books and to the organization unit.
For more information, see the PeopleSoft Enterprise Payables PeopleBook, "Setting Up PeopleSoft Payables Business Units" and the PeopleSoft Enterprise General Ledger PeopleBook, "Defining Your Operational Structure."
Cross-references map and connect the records within the application network, and they enable these applications to communicate in the same language. The integration server stores the relationship in a persistent way so that others can refer to it.
For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack and the Oracle Cross Reference User Guide.
Table 7-2 lists and describes the Oracle Retail to PeopleSoft Financials PIP cross-references:
Table 7-2 Oracle Retail to PeopleSoft Financials PIP Cross-References
Cross-Reference Table Name | Column Name | Description | Usage |
---|---|---|---|
CURRENCYEXCHANGE_ID |
COMMON |
PeopleSoft GUID |
Populate during the currency exchange integration. |
RETL_01 |
Concatenation of Retail FromCurrencyCode:To CurrencyCode:ConversionType:ConversionDate |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
PAYABLEINVOICE_PAYABLEINVOICEID |
COMMON |
Same GUID as PSFT_01 |
Populated by the Oracle Data Integrator (ODI) invoice integration and then used by the DrillBackForward web service. |
RETL_01 |
Reference ID from Oracle Retail |
-- |
-- |
PSFT_01 |
A GUID generated by the native database |
-- |
-- |
PAYMENTTERM_ID |
COMMON |
Generated GUID |
Populate during the payment term integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
PAYMENTTERMLINE_ID |
COMMON |
Generated GUID |
Populate during the payment term integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
SUPPLIERPARTY_ID |
COMMON |
Generated GUID |
Populate during the supplier integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
SUPPLIERPARTY_ADDRESS_ID |
COMMON |
Generated GUID |
Populate during the supplier integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
SUPPLIERPARTY_LOCATION_ID |
COMMON |
Generated GUID |
Populate during the supplier integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
ORGANIZATION_ID |
COMMON |
Generated GUID |
Populate for the SupplierParty Integration. |
RETL_01 |
Oracle Retail ID |
-- |
-- |
PSFT_01 |
PeopleSoft GUID |
-- |
-- |
DVMs are a standard feature of the Oracle service-oriented architecture (SOA) suite. They are tables containing mapping between related information in the participating applications. They enable you to equate lookup codes and other static values across applications, for example, FOOT and FT or US and USA. These DVM tables are maintained in the Oracle AIA layer. The Oracle AIA layer uses these DVM tables in transforming the messages from one system in the expected format of the other system.
DVM types are seeded for the Oracle Retail to PeopleSoft Financials flows, and administrators can extend the list of mapped values by adding more maps. The DVM data should be synchronized with what the participating applications use. This synchronization should occur before any initial loads are run or any incremental transactional flows are initiated.
Note:
For any DVM that is not pre-seeded, the first row has description information, such as Enter Org Unit here. Remove this first row because it causes issues in the Oracle Data Integrator flow.Table 7-3 lists and describes the DVMs for the Oracle Retail to PeopleSoft Financials PIP:
Table 7-3 DVMs for the Oracle Retail to PeopleSoft Financials PIP
DVM Type | DVM Column Name | Comments |
---|---|---|
BUSINESS_UNIT |
COMMON, RETL_01, PSFT_01 |
Maps the Oracle Retail Set Of Books IDs to PeopleSoft GL business units. |
CHARTOFACCOUNTS_ACCOUNTSTATUS |
COMMON, RETL_01, PSFT_01 |
A hard-coded DVM that should not be changed. Maps the PeopleSoft and EBO value of true or false to the Oracle Retail value of valid or invalid. |
CHARTOFACCOUNTS_GLELEMENT |
COMMON, RETL_01, PSFT_01 |
Maps Oracle Retail segment values to PeopleSoft GL elements. |
ADDRESS_COUNTRYID |
COMMON, RETL_01, PSFT_01 |
Maps the country codes between Oracle Retail and the PeopleSoft system. |
CURRENCY_CODE |
COMMON, RETL_01, PSFT_01 |
Maps the currency codes between Oracle Retail and the PeopleSoft system. |
CURRENCYEXCHANGE_CONVERSIONTYPECODE |
COMMON, RETL_01, PSFT_01 |
Maps the currency exchange codes between Oracle Retail and the PeopleSoft system. |
LANGUAGE_CODE |
COMMON, RETL_01, PSFT_01 |
Maps the language code between Oracle Retail and the PeopleSoft system. The system uses this DVM to determine which language to use to send the translatable fields to Oracle Retail. |
ORACLERETAILSEGMENTCOLNAMES |
CHARTOFACCOUNTS_GLELEMENT, STG_FIF_GL_DATA, IM_FINANCIALS_STG, IM_AP_STAGE_DETAIL |
A hard-coded DVM that should not be changed. Lists the column names for all 20 segments for the tables in the Oracle RMS, Oracle ReIM, and Oracle ReIM Journal Entry systems. The system uses this for the accounting entry ODI flow. |
STATE |
COMMON, RETL_01, PSFT_01 |
Maps the state codes between Oracle Retail and PeopleSoft Payables. |
SUPPLIERPARTY_ADDRESSTYPE |
COMMON, RETL_01, PSFT_01 |
Maps the supplier's address type between Oracle Retail and PeopleSoft Payables. |
SUPPLIERPARTY_STATUSCODE |
COMMON, RETL_01, PSFT_01 |
Maps the supplier's status between Oracle Retail and PeopleSoft Payables. |
Based on the roles defined for the services, the system sends email notifications if a service errors out. Table 7-4 lists the errors generated by the Oracle Retail to PeopleSoft Financials PIP services:
Table 7-4 Errors Generated by the Oracle Retail to PeopleSoft Financials PIP
Error Code | Message Text |
---|---|
AIA_ERR_AIARTL2PSFT_1001 |
Invalid Requesting System; Requesting Systems must be Oracle ReSA, Oracle ReIM, or Oracle RMS |
AIA_ERR_AIARTL2PSFT_1002 |
Invalid Set Of Books ID; Set Of Books ID must in BUSINESS_UNIT DVM |
AIA_ERR_AIARTL2PSFT_1003 |
Invalid Currency Conversion Type Code |
You can set the Integration Broker process to handle multiple processes so that if an error is generated, the process can continue to complete the remaining transactions.
For more information about the errors generated by Oracle Retail or PeopleSoft applications, see that product's documentation.
For more information about Oracle AIA error handling, see Oracle Fusion Middleware Infrastructure Components and Utilities User's Guide for Oracle Application Integration Architecture Foundation Pack, "Setting Up and Using Error Handling and Logging."
For more information about how services are mapped, see the My Oracle Support document: EBO Implementation Maps (EIMs) 881022.1.
Set these properties in the AIAConfigurationProperties.XML file. This file is available in <aia_instances>/config/.
For more information about requirements for working with AIAConfigurationProperties.xml, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Building AIA Integration Flows," How to Set Up AIA Workstation."
For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Configuring and Using Oracle Enterprise Repository as the Oracle AIA SOA Repository."
Table 7-5 describes the settings for the ProcessGLAccountValidationPeopleSoftProvABCSImpl service property:
Table 7-5 ProcessGLAccountValidationPeopleSoftProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
PeopleSoft system instance code, defined in Oracle Enterprise Repository (OER) from the account validation provider. |
Routing.GL_CHARTFIELD.PSFT_01.EndpointURI |
http://${psftfscm.http.host}:${psftfscm.http.port}/PSIGW/PeopleSoftServiceListeningConnector/${psftfscm.http.default.local.node} |
PeopleSoft GL_Chartfield web service endpoint location. A SOAP endpoint URL. |
Routing.GL_CHARTFIELD.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
Composite Application Validation System (CAVS) endpoint location to simulate a sync response for the PeopleSoft GL_Chartfield web service. |
Routing.GL_CHARTFIELD.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-6 describes settings for the SyncCurrencyExchangeListPeopleSoftReqABCSImpl service property:
Table 7-6 SyncCurrencyExchangeListPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in OER) from which messages originate. |
Routing.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.SyncCurrencyExchangeListPeopleSoftReqABCSImpl.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.SyncCurrencyExchangeListPeopleSoftReqABCSImpl.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
Table 7-7 describes settings for the SyncPaymentTermListPeopleSoftReqABCSImpl service property:
Table 7-7 SyncPaymentTermListPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in OER) from which messages originate. |
Routing.PaymentTermEBS.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.PaymentTermEBS.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.PaymentTermEBS.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which can be PRODUCTION or CAVS. |
Table 7-8 describes settings for the CreatePaymentTermPeopleSoftReqABCSImpl service property:
Table 7-8 CreatePaymentTermPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in OER) from which messages originate. |
Routing.PaymentTermEBS.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.PaymentTermEBS.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.PaymentTermEBS.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which can be PRODUCTION or CAVS. |
Table 7-9 describes settings for the UpdatePaymentTermPeopleSoftReqABCSImpl service property:
Table 7-9 UpdatePaymentTermPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in BSR) from which messages originate. |
Routing.PaymentTermEBS.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.PaymentTermEBS.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.PaymentTermEBS.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
Table 7-10 describes settings for the CreateSupplierPartyPeopleSoftReqABCSImpl service property:
Table 7-10 CreateSupplierPartyPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Sender.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in OER) from which messages originate. |
Routing.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.CreateSupplierPartyPeopleSoftReqABCSImpl.CAVS.EndpointURI |
http://${http:host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.CreateSupplierPartyPeopleSoftReqABCSImpl.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
Table 7-11describes settings for the UpdateSupplierPartyPeopleSoftReqABCSImpl service property:
Table 7-11 UpdateSupplierPartyPeopleSoftReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Sender.SystemID |
PSFT_01 |
PeopleSoft system instance code (defined in OER) from which messages originate. |
Routing.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.UpdateSupplierPartyPeopleSoftReqABCSImpl.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.UpdateSupplierPartyPeopleSoftReqABCSImpl.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
Table 7-12 describes settings for the SyncCurrencyExchangeListRetailProvABCSImpl service property:
Table 7-12 SyncCurrencyExchangeListRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the currency exchange provider. |
Routing.SyncCurrencyExchangeListRetailProvJMSProducer.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.SyncCurrencyExchangeListRetailProvJMSProducer.RETL_01.EndpointURI |
http://${http.host name}:${http.port}/orabpel/default/SyncCurrencyExchangeListRetailProvJMSProducer/1.0 |
Oracle Retail currency exchange endpoint wsdl location. This URL normally resides on the SOA server. |
Routing.SyncCurrencyExchangeListRetailProvJMSProducer.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail currency exchange endpoint wsdl location. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-13 describes settings for the SyncPaymentTermListRetailProvABCSImpl service property:
Table 7-13 SyncPaymentTermListRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the payment term provider. |
Routing.PayTermService.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.PayTermService.RETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/PayTermBean/PayTermService |
Oracle Retail PayTermService web service endpoint location. A SOAP endpoint URL. |
Routing.PayTermService.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail PayTermService endpoint wsdl location. |
Retail.Language |
1 |
Language of the Oracle Retail system. This value corresponds with the LANGUAGE_CODE DVM table. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-14 describes settings for the UpdatePaymentTermRetailProvABCSImpl service property:
Table 7-14 UpdatePaymentTermRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the payment term provider. |
Routing.PayTermService.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.PayTermService.RETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/PayTermBean/PayTermService |
Oracle Retail PayTermService web service endpoint location. A SOAP endpoint URL. |
Routing.PayTermService.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail PayTermService endpoint wsdl location. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-15 describes settings for the CreatePaymentTermRetailProvABCSImpl service property:
Table 7-15 CreatePaymentTermRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the payment term provider. |
Routing.PayTermService.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.PayTermService.RETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/PayTermBean/PayTermService |
Oracle Retail PayTermService web service endpoint location. A SOAP endpoint URL. |
Routing.PayTermService.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail PayTermService endpoint wsdl location. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-16 describes settings for the SyncSupplierPartyListRetailProvABCSImpl service property:
Table 7-16 SyncSupplierPartyListRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the supplier party provider. |
Routing.SupplierServicePort.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.SupplierServicePortRETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/SupplierBean/SupplierService |
Oracle Retail SupplierParty web service endpoint location. A SOAP endpoint URL. |
Routing.SupplierServicePort.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator. |
CAVS endpoint location to simulate a sync response for the Oracle Retail SupplierParty service endpoint wsdl location. |
Retail.Language |
1 |
Language of the Oracle Retail system. This value corresponds with the LANGUAGE_CODE DVM table. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Retail.ActiveCode |
A |
Used to determine if the inbound supplier is active or inactive, after which the corresponding value is passed to Oracle Retail. |
Retail.InactiveCode |
I |
Used to determine if the inbound supplier is active or inactive, after which the corresponding value is passed to Oracle Retail. |
Table 7-17 describes settings for the CreateSupplierPartyRetailProvABCSImpl service property:
Table 7-17 CreateSupplierPartyRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the supplier party provider. |
Routing.SupplierServicePort.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.SupplierServicePort.RETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/SupplierBean/SupplierService |
Oracle Retail SupplierParty web service endpoint location. A SOAP endpoint URL. |
Routing.SupplierServicePort.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail SupplierParty service endpoint wsdl location. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-18 describes settings for the SyncSupplierPartyListRetailProvABCSImpl service property:
Table 7-18 SyncSupplierPartyListRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
PSFT_01 |
Oracle Retail system instance code (defined in OER) from the supplier party provider. |
Routing.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.SyncSupplierPartyListPeopleSoftReqABCSImpl.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.SyncSupplierPartyListPeopleSoftReqABCSImpl.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the verification system. |
Table 7-19 describes settings for the UpdateSupplierPartyRetailProvABCSImpl service property:
Table 7-19 UpdateSupplierPartyRetailProvABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from the supplier party provider. |
Routing.SupplierServicePort.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
Routing.SupplierServicePort.RETL_01.EndpointURI |
http://${retail.rsl.host}:${retail.rsl.port}/SupplierBean/SupplierService |
Oracle Retail SupplierParty web service endpoint location. A SOAP endpoint URL. |
Routing.SupplierServicePort.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/syncresponsesimulator |
CAVS endpoint location to simulate a sync response for the Oracle Retail SupplierParty service endpoint wsdl location. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Table 7-20 describes settings for the ProcessGLAccountValidationRetailReqABCSImpl service property:
Table 7-20 ProcessGLAccountValidationRetailReqABCSImpl Service Property
Property Name | Value/Default Values | Description |
---|---|---|
Default.SystemID |
RETL_01 |
Oracle Retail system instance code (defined in OER) from which messages originate. |
Routing.RouteToCAVS |
true/false Default = false |
Controls whether to route messages to the verification system. |
ABCSExtension.PreProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PreProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessEBM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
ABCSExtension.PostProcessABM |
true/false Default = false |
Controls whether to route messages to the extensibility system. |
Routing.ProcessGLAccountValidationRetailReqABCSImpl.CAVS.EndpointURI |
http://${http.host name}:${http.port}/AIAValidationSystemServlet/asyncrequestrecipient |
CAVS Endpoint URI when CAVS is enabled. |
Routing.ProcessGLAccountValidationRetailReqABCSImpl.MessageProcessingInstruction.EnvironmentCode |
PRODUCTION |
Code that identifies the environment the ABCS is running in, which could be PRODUCTION or CAVS. |
Table 7-21 describes settings for the DrillBackForward service property:
Table 7-21 DrillBackForward Service Property
Property Name | Value/Default Values | Description |
---|---|---|
PSFTUrl.ProtocolHostPort |
http://${psftfscm.http.host}:${psftfscm.http.port} |
The protocol, host, and port of the PeopleSoft service location. |
PSFTUrl.Servlet |
${psftfscm.application.url.servlet} |
The name of the PeopleSoft FSCM Application servlet. |
PSFTUrl.Site |
${psftfscm.application.url.site} |
The name of the PeopleSoft FSCM Application site. |
PSFTUrl.PortalNodeContent |
EMPLOYEE/ERP/c |
The Port, Node, and Content for the PeopleSoft FSCM application. The format of this information is: <portal>/<node>/<content> |
PSFT.Invoice.WS.Location |
http://${psftfscm.http.host}:${psftfscm.http.port}/PSIGW/PeopleSoftServiceListeningConnector/${psftfscm.http.default.local.node} |
PeopleSoft Invoice web service endpoint location. A SOAP endpoint URL. |
RETAIL.URL.WS.Location |
http://${retail.rsl.host}:${retail.rsl.port}/ReportLocatorBean/ReportLocatorService |
Oracle Retail Report Locator service endpoint location. A SOAP endpoint URL. |