Performing Data Conversion Using the DC_PENDITEM_CI Component Interface

This topic provides an overview of the DC_PENDITEM_CI component interface and discusses how to:

  • Run the component interface conversion process.

  • Verify that the data conversion is successful.

  • Post the items in PeopleSoft Receivables.

When you implement the PeopleSoft Receivables system, you will want to convert existing information to the PeopleSoft Receivables system. Use the DC_PENDITEM_CI component interface and the Excel to Component Interface utility to populate existing PeopleSoft tables with data from third-party applications. The interface uses a combination of technologies such as iScript, Microsoft Excel spreadsheets, and Visual Basic for Application programs to convert data.

The DC_PENDITEM_CI component interface is a PeopleTools object that is created in PeopleSoft Application Designer that enables you to access a PeopleSoft component from another application. The component interface uses business logic to update the data in the Pending Item tables. You do this by using the ExceltoCI.xls Excel spreadsheet to map the data and move the data into the PeopleSoft Receivables tables.

The component interface populates these tables:

  • PS_GROUP_CONTROL

  • PS_PENDING_ITEM

  • PS_PENDING_VAT

  • PS_PENDING_TAX

  • PS_PENDING_TAX_DTL

  • PS_PENDING_DST

Note: Excel has a physical limitation of 256 columns and 65k rows. To work around these limitations, you may need to limit the import data so that the number of rows on the Data Input page does not exceed 65k.

The user must have privileges to the DC_PENDITEM_CI component interface with full access to create methods to run the component interface.

Use the Excel to Component Interface utility to run the component interface. When you build the worksheet template, select the DC_PENDITEM_CI component interface.

The PeopleTools documentation describes how to use the Excel to Component Interface utility in detail.

See the product documentation for PeopleTools: Component Interfaces.

Use Application Designer to access PeopleSoft Query (Go, Query) where you can search for records in the PS_PENDING_ITEM table and the other tables that the interface populates.

Run the Receivables Update process to post the pending items and update customer balances.