PeopleSoftGuys.com Home
Navigate
February 22nd, 2008

PeopleSoft AR transaction tables

The following are the common AR Transaction tables

PS_ITEM  - Item related information will be stored.

PS_GROUP_CONTROL – Groups related information will be stored

PS_PENDING_ITEM  - Pending items related to pending group will be stored.

PS_ITEM_DST - Accounting information related to a pending group will be stored.

PS_PENDING_DST - Accounting information related to a posted group will be  stored.

PS_DEPOSIT_CONTROL - Deposit related information will be stored

PS_PAYMENT - Payment related information will be stored.

February 7th, 2008

Conversion of SBT to PeopleSoft 8.8 FSCM

I’m currently leading a project for a public sector client and we needed to perform a data conversion of legacy data from SBT system into PeopleSoft financials and supply chain system.

The approach I designed to bring the data into the PeopleSoft system is

  • Export the data from SBT system (Which is in FoxPro) to .dbf files
  • Import the data into MS Access database by using MS Access import utility
  • Export the data into Sybase database (which is where PeopleSoft database is located) using MS Access export utility by using Open Database connectivity (ODBC).
  • Once the data is in Sybase database we are planning to import the metadata into Convoy DM tool and map the tables to a target database.
  • Then we are planning to generate the conversion SQRs using Convoy DM.

I will post more info regarding this conversion. Once we start progressing on this. I thought this would be useful for someone as I couldn’t find any information on this anywhere else.

October 18th, 2006

PeopleSoft AR Deposit Entry Errors out with Time out

This was one of the strange situations we faced when we went live with PeopleTools 8.45.17 and Financials 8.8 SP1 Maintenance Pack 3.

After a couple of days that we went live users in Accounts Receivables area started complaining that they can’t enter the deposits any more and the system started throwing them out.

I identified that PGG_SERVICE_TAO. REQUEST_NBR field reached to 9999 and the table is getting locked out and it was not releasing the lock for other people.

The solution to overcome this issue is …..

Either you manually update this field (PGG_SERVICE_TAO. REQUEST_NBR) back to 0  (or) Set the DBFLAGS to 8 in the configuration file and bounce the app server.

For more details on DBFLAGS setting go through the PeopleBooks.
It will set the ‘Disable a persistent second database connection’ action

August 26th, 2006

Common Financials Terms Used

ï‚§ Pre-encumbrance: Amount that you expect to spend, but which you have no legal obligation to spend. A requisition is a typical pre-encumbrance transaction.ï‚§ Encumbrance: Amount that you have a legal obligation to spend in the future. Issuance of a purchase order to a vendor is a typical encumbrance transaction.

ï‚§ Planned: A free-form non-actuals amount. Can be used as a memo entry or an entry to estimate future spending. Can also be used to record third-party source transactions that precede pre-encumbrance documents. The latter usage requires defining a new source transaction type.

ï‚§ Recognized Revenue: Revenue that you have booked and expect to receive.

ï‚§ Business Unit: A business unit is an organizational entity which maintains its own transaction data.

ï‚§ Transaction Tables: Transaction tables store data about day-to-day business activities. Transaction tables in PeopleSoft are keyed in by Business Unit.

ï‚§ Control Tables: Control tables store information that define the accounting structure and processing rules that are used when transactions are entered into your PeopleSoft applications. Control tables include master lists such as customers, vendors, products, items, and chart of accounts. Control tables are static; they change only when you perform specific maintenance, appropriate to changes in your business policies. Most PeopleSoft tables are keyed by Table Set Identifier, rather than by Business Unit. In addition, most are effective-dated.

ï‚§ TableSet Id: Most data recorded in control tables is stored by Table Set ID (also called as SetID). Whenever your enter information in control table, you must enter the SetID to establish the ownership of that information. A grouping of data that is keyed by the same SetID is called a TableSet.

ï‚§ Record Groups: The control tables used by each of the financial and distribution applications are grouped by function into record groups. A record group is a set of logically and functionally related control tables and views. All tables in the same record group will have the same key on each table.

ï‚§ Record Group Control: In the TableSet record group control panel, you specify which SetID you want a business unit to use for each record group. You can specify a single SetID for all Record Groups or a combination of any number of SetIDs.

ï‚§ TableSet Sharing: TableSet sharing allows different business units to use, or share, the same control information.

|