Though we tried to compile a comprehensive list of all PeopleSoft tools tables but we may have missed some of those. If you know of any other important tables which are not present in above list, please do share with us in comment section below.
Utilizing PeopleTools 8. This table holds all of the information about fields in a table. I wanted to check my project and see all the objects that it contains. In addition to the tables identified there are some additional tables that I am trying to track down that deal with the BI Publisher Report Definitions — I believe I have found the major ones, but not the one that specifically states what template name it is actually utilizing.
When we patched to Image 7 it wiped out our custom definitions and replaced them with PeopleSoft — I would like to track the name of the template files we have in place. Thanks Dan. Great list, Prashant! May I please get the downloaded version of this list? Very helpful! Thanks, Elizabeth. I am not able to migrate properly the BI publisher template and file definition. But it is showing in the tables.
Webprofile related tables are missing. This table is useful when using a load balancer. The virtual address data will be saved in this table. I tried several times to copy the body here but I get an error when I submit. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Tags: PeopleTools. Register or Login. Welcome back! Sign in with Email.
In addition, you should consider whether to create a separate file reference record for each storage location. Doing so can prevent file name conflicts, eliminates the need to store the URL string or URL identifier with each file reference, and can ease the use of the CopyAttachments function. Save the PeopleCode with the new record. You can use this copy of the sample PeopleCode as the basis for your own application.
It is not intended for direct use as part of an application running in production. Instead an application-specific clone of it must be used. Oracle can change the delivered sample PeopleCode in future releases. Using application-specific PeopleCode makes it easier to manage during upgrades and your PeopleCode can be reused in other components that use file attachment functionality.
You must also implement the PeopleCode to manage the data in your file reference table or tables. Use the records you created in the previous steps to create the file attachment component and page.
The following table summarizes the delivered record definitions for use in a file attachment application:. Insert this subrecord in any record definition for target tables that will store attached files. Do not add other fields to this record. Insert this subrecord in any application-specific record for tables that will store references to attached files.
The fields in this subrecord store the system file name and the user file name. To use a database table as a storage location, you must create an application-specific record definition associated with the target table that will receive the attachments. The system file name, which must be unique to the storage location in order to avoid unintended file overwrites. Furthermore, if the file reference table to be used will contain references to file stored at more than one storage location, then the system file name must also be unique to that table.
PeopleTools maintains the values in this table. Therefore, do not reuse the fields in this table to store incomplete or nonstandard versions of the file name or other data. Your application must populate these fields with the system file name, user file name, and any information about the file that will be needed for later use.
Contains a PeopleCode program used for uploading an attachment from an end-user machine to the specified storage location via the AddAttachment built-in function. Contains a PeopleCode program used for downloading an attachment from the specified storage location to be saved on the end-user machine via the DetachAttachment built-in function. Contains a PeopleCode program used for deleting an attachment from the specified storage location via the DeleteAttachment built-in function. Contains a user-defined PeopleCode function that can be called to determine by file name extension whether the attachment operation will be permitted on a file.
In this function, an array of file name extensions identifies which types of files will be regarded as impermissible. Contains a PeopleCode program used for downloading an attachment from the specified storage location to be viewed on the end-user machine via the ViewAttachment built-in function.
When you create a file attachment application, you create an application-specific record to be associated with the table that will store file reference information and any additional information about the file attachments. Then, you would add fields for any other information related to the transaction you want to store.
Your application should use the fields in file reference tables as follows:. This is the name of the file as it exists at the storage location and is also a key field of your file reference table. This is essentially the base name of file selected by the end user for uploading and would be used to allow end users to identify the file in other file attachment operations such as viewing, downloading, or deleting.
When your application is downloading or deleting files for example, with ViewAttachment, DetachAttachment, or DeleteAttachment :. This field is also passed as a parameter to some of the built-in PeopleCode functions. The PeopleTools Test Utilities page contains a sample file attachment application that allows you to upload Attach button , save Detach button , delete Delete button , and open View button a file attachment.
The page allows you to specify a storage location as a URL identifier or as an ad hoc string. After clicking the Attach button, you are prompted to select a file to upload to the storage location. Once the selected file has been successfully uploaded, buttons appear that allow you to open, save, or delete that file from its storage location.
This demonstration application permits the user to enter a URL of up to characters only. These programs are provided as working examples of how to use the following file attachment functions: AddAttachment, DeleteAttachment, DetachAttachment, and ViewAttachment. In addition, do not directly call these PeopleCode programs from any PeopleCode programs you implement. Oracle might modify these sample programs in a future release of PeopleTools. The IsLegalAttachmentType function compares a given file to an internally defined array of illegal file extensions.
This programmatic methodology can be contrasted with restricting file types through the use of file extension lists. File extension lists can be provide an easier, more flexible, and more manageable approach to restricting file types than a programmatic method. Do not combine these two methodologies in the same application. If the source file name specified using one of the file attachment. The actual error message can be found in the logs. When the file is uploaded to or downloaded from a storage location, the following characters are replaced with an underscore:.
In general, you should exercise caution when using an or : character in the name of a file selected for uploading. This means that these functions should not be used in any of the following PeopleCode events:. If you want to transfer files in a non-interactive mode with functions that aren't think-time functions, see GetAttachment and PutAttachment. Think-Time Functions.
Generally, a PeopleCode program that calls PutAttachment will also need to save for later use the name of each uploaded file as it ended up actually being named at the specified storage location. So, the only way for your PeopleCode program to ensure that it is saving the correct name is to either avoid using special characters in the destination file name or to simulate the conversion process in something like the following example:.
Unlike the PutAttachment function, the AddAttachment function automatically returns the converted file name for reference and later use. For example, the file name My Resume. CopyAttachments does not modify the contents of any of the associated file reference tables. You must design your application in such a way that using CopyAttachments does not, by itself, require any subsequent changes to the contents of any of the associated file reference tables.
The topics in this section are of interest primarily to customers deploying file processing applications, and secondarily to application developers. In an environment involving multiple application server domains, a call to one of the PeopleCode file attachment functions must not be passed a parameter designating a file that is located on the file system of a particular application server domain. The problem is that at the time of the call, the application server domain currently in use as a consequence of load-balancing might not be the application server domain that has the file in question.
In this case, a file-not-found error would result. For example, this may be an issue for a call to PutAttachment, or this might cause a call to GetAttachment to result in the file being downloaded to an unexpected location the file system of the wrong application server domain or to fail entirely if the specified destination directory does not exist on the application server domain currently in use.
Therefore, the path to the local file must be specified with this in mind by creating directories that can be comparably accessed regardless of which application server domain actually services the request at runtime. When a browser attempts to open a file attachment, the browser invokes a viewer based on the MIME Multipurpose Internet Mail Extensions type sent in the response header from the web server.
If the web server did not send this content-type header, the browser would not be able to determine the nature of the file being transmitted, and it would be unable to invoke the correct viewer application. The web server maps file extensions to MIME types through entries in a web. A copy of web. After a web server instance is created, edit its deployed copy to add any additional MIME types.
0コメント