FO_SOA_SRV_VW2 (SQL View)	Index Back
SOA Service Reverse Lookup Allows a reverese lookup to find the transaction id associated with a string comprising the service name and version

FO_SOA_SRV_VW2

(SQL View)

SOA Service Reverse Lookup

Allows a reverese lookup to find the transaction id associated with a string comprising the service name and version

SELECT FO_TRANS_NAME , FO_TRANSACT_ID FROM PS_FO_SOA_SRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FO_TRANS_NAME Character(52) VARCHAR2(52) NOT NULL Transaction Name

2 FO_TRANSACT_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FO_TRANS_NAME	Character(52)	VARCHAR2(52) NOT NULL	Transaction Name
2	FO_TRANSACT_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction ID