tag:blogger.com,1999:blog-86199001202242688632024-03-14T06:55:48.392-07:00PeopleSoft BlogMy personal repository of PeopleSoft related findings. They cover various modules in FSCM/HR/Campus/PeopleTools and whatever reusable useful information I can find to make my job easy.Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-8619900120224268863.post-80899693460089700612018-12-25T05:20:00.001-08:002018-12-25T05:22:21.249-08:00FieldEdit vs FieldChange Event in PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;">FieldEdit event
is more of a validation event used to validate the value entered in a field and
throw error/warning if the value is not what is supposed to be when the cursor
is tabbed out. This event </span><span style="font-family: Arial, sans-serif; font-size: 16pt;">won't</span><span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;"> </span><span style="font-family: Arial, sans-serif; font-size: 16pt;">allow</span><span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;"> the user to save transaction unless and until the
appropriate value isn't provided in the field and the validation passed. The
FieldChange PeopleCode fires after the field value has been changed.</span><span style="font-family: Arial, sans-serif; font-size: 16pt;"><o:p></o:p></span></div>
<div style="margin: 0in 0in 0.0001pt;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;"><br />
<br />
FieldChange event is used where you want to change other fields in response to
when another field is changed. The FieldEdit PeopleCode fires before the field
value </span><span style="font-family: Arial, sans-serif; font-size: 16pt;">is</span><span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;"> actually changed.</span><span style="font-family: Arial, sans-serif; font-size: 16pt;"><o:p></o:p></span></div>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 18.0pt;"><br />
</span><b><span style="background: white; color: blue; font-family: "Arial",sans-serif; font-size: 16.0pt;">HAPPY LEARNING:)</span></b><span style="font-size: 16pt;"><o:p></o:p></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com1tag:blogger.com,1999:blog-8619900120224268863.post-40542421309046879522018-12-25T05:15:00.002-08:002018-12-25T05:23:21.316-08:00PreBuild Vs PostBuild Event in PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;">PreBuild fires before any PeopleCode code event on all the rows and fields in the component such as FieldDefault and RowInit. During the PreBuild event, there will not be any data in the component buffer other than the search record as it's executing prior to the component build process.<o:p></o:p></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<br /></div>
<div style="margin: 0in 0in 0.0001pt;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;">During the PostBuild event, you will have access to the data read from the database into the component buffer.<o:p></o:p></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<br /></div>
<div style="margin: 0in 0in 0.0001pt;">
<span style="background: white; color: #222222; font-family: "Arial",sans-serif; font-size: 16.0pt;">PreBuild and PostBuild is most commonly used to hide or unhide pages.<o:p></o:p></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<br /></div>
<br />
<div style="margin-bottom: .0001pt; margin: 0in;">
<b><span style="background: white; color: blue; font-family: "Arial",sans-serif; font-size: 16.0pt;">HAPPY LEARNING :)<o:p></o:p></span></b></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-58930639651263491272018-11-26T10:06:00.001-08:002018-11-26T10:25:07.351-08:00Dynamic view in PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements.<br />
PeopleSoft 8 provides the functionality to create dynamic views. These are essentially SQL statements executed on the fly by the PeopleSoft component processor. We can use dynamic views in Peoplesoft pages only because they are PeopleTools objects, not SQL Objects.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
<strong style="border: 0px; margin: 0px; padding: 0px;">Using Dynamic view as Prompt Table</strong></div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
In this article, we will see the use of Dynamic view as a prompt table. Please note that a dynamic view can be used for other purposes such as search records which will not be discussed in the article.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
One major question that pops up to many of us the first time we use a dynamic view, why not use a normal view instead of a dynamic view. A dynamic view’s select statement may include Peoplesoft’s meta-SQL, and it may be replaced by a different SQL statement while the user is using the page. And also there might be situations where which you do not save the view in the database.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
<strong style="border: 0px; margin: 0px; padding: 0px;">Using Edit Table for prompt tables</strong></div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Assume that you have a page in which the user selects a country and depending on the selection you want a different prompt table for the states. For example, if the user selects US show states for US and user selects Canada show states of Canada.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
This can be achieved by following the steps below</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Step 1: Create two views/dynamic views to show the states of the US and Canada.<br />
Step 2: Go to record field, in our case it is state field (Right click and select <strong style="border: 0px; margin: 0px; padding: 0px;">View Definition </strong>on the state field on the page).<br />
Step 3: Right Click and select <strong style="border: 0px; margin: 0px; padding: 0px;">Record Field Properties</strong><br />
Step 4: Select <strong style="border: 0px; margin: 0px; padding: 0px;">Edits</strong> tab and then select <strong style="border: 0px; margin: 0px; padding: 0px;">Table Edit</strong>. Select <strong style="border: 0px; margin: 0px; padding: 0px;">Prompt table with edit</strong>( or No Edit) as per your requirement. Write <strong style="border: 0px; margin: 0px; padding: 0px;">%EDITTABLE</strong> against Prompt table.*<strong style="border: 0px; margin: 0px; padding: 0px;">EDITTABLE</strong> is a field in table named <strong style="border: 0px; margin: 0px; padding: 0px;">DERIVED</strong>, provided by PeopleSoft.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Step 5: Place the EDITTABLE field from DERIVED Table on the page.<br />
Step 6: On field change of Country Field, write the below code<br />
<br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">if YOURRECORDNAME.COUNTRY = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"US"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">;</code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> DERIVED.EDITTABLE = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"STATE_US_DVW"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">; // dynamic view of list of states of US</code></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><span style="background-color: white; color: #006699; font-weight: 700;">Else</span></code></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> DERIVED.EDITTABLE = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"STATE_CAN_DVW"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">; // dynamic view of list of states of CAN</code></code></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="keyword" style="background-attachment: initial !important; background-clip: initial !important; background-color: white; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-weight: bold !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">End</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: white; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">-if;</code></code></code></code></div>
<div class="syntaxhighlighter nogutter " id="highlighter_774449" style="background: none rgb(255, 255, 255) !important; border: none !important; bottom: auto !important; direction: ltr !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 1em 0px !important; outline: 0px !important; padding: 0px !important; position: relative !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: 960.297px;">
<div class="lines" style="background: none !important; border: 0px !important; bottom: auto !important; direction: ltr !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">
<div class="line alt1" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; float: none !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">
<strong style="border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; margin: 0px; padding: 0px;">Using SQL Text</strong></div>
</div>
</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Instead of creating two views/dynamic views, you can also create one dynamic view and pass the SQL dynamically to change the prompt table.</div>
<div style="background-color: white; border: 0px; color: #4a4a4a; font-family: "trebuchet ms"; font-size: 13px; line-height: 1.6; margin-bottom: 20px; padding: 0px;">
Step 1: Create and save A Dynamic view<br />
Step 2: Give the dynamic view as a prompt table to the state field.<br />
Step 3: On field change of your country field you can write.<br />
<br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">if YOURRECORDNAME.COUNTRY = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"US"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">;</code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> YOURRECORDNAME.FIELD.SqlText = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"Select State from MY_STATE_TBL where country = 'US'"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">;</code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><span style="background-color: white;">ELSE</span></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> YOURRECORDNAME.FIELD.SqlText = </code><code class="string" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: blue !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">"Select State from MY_STATE_TBL where country = 'CAN'"</code><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">;</code></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><span style="background-color: white;">END-IF;</span></code></code><br />
<code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: #f8f8f8; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; color: black; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><code class="plain" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><span style="background-color: white;"><br /></span></code></code> <b style="background-color: initial;"><span style="color: blue; font-size: large;">HAPPY LEARNING :)</span></b></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com3tag:blogger.com,1999:blog-8619900120224268863.post-67288010626881299292017-06-05T11:36:00.002-07:002017-06-05T11:38:03.117-07:00Costed Flag in PS_TRANSACTION_INV table<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; font-family: "roboto" , sans-serif; font-size: 15px;"><span style="color: blue;">COSTED_FLAG = Y or N</span></span><br />
<span style="background-color: white; color: #757575; font-family: "roboto" , sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #757575; font-family: "roboto" , sans-serif; font-size: 15px;">If you are adding a row PS_TRANSACTION_INV, you have to decide if you want the row to be taken into account by the costing process by setting the field COSTED_FLAG either to Y or to N. If you set it to Y, the costing process will skip the row.</span><br />
<span style="background-color: white; color: #757575; font-family: "roboto" , sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: blue; font-family: "roboto" , sans-serif; font-size: 15px;"><b><br /></b></span>
<span style="background-color: white; color: blue; font-family: "roboto" , sans-serif; font-size: 15px;"><b>HAPPY LEARNING :)</b></span></div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-79257523173828194382017-06-05T11:33:00.000-07:002017-06-05T11:33:11.080-07:00Inventory Issues and Resolution<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Completions Pending Putaway =</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">1) Difference between the quantity (field COMPLETED_QTY) in PS_SF_OUTPUT_LIST for an Item by Production ID where MG_OUTPUT_TYPE = CP (Primary Item) or CS (Secondary Co-Product) and the sum of the quantities (field QTY_BASE) in PS_TRANSACTION_INV for the Item by Production ID for the Transaction Groups 021 (Receipts from production) and 221 (Route to Production Kit).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">+</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">2) Quantity (field COMPLETED_QTY) in PS_SF_OUTPUT_LIST for the Item by Production ID if the Production ID's are not found in PS_TRANSACTION_INV for the Transaction Groups 021 (Receipts from production) and 221 (Route to Production Kit).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Part 1 of the above formula is done by running a query against the View PS_CM_NP_PID_VW and part 2 against the View PS_CM_NP_PID2_VW. So in order to check where the problem is, just run the following two queries:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT COUNT(*) FROM PS_CM_NP_PID_VW WHERE BUSINESS_UNIT = 'Your Business Unit' AND CM_BOOK = 'Your Cost Book';</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT COUNT(*) FROM PS_CM_NP_PID2_VW WHERE BUSINESS_UNIT = 'Your Business Unit' AND CM_BOOK = 'Your Cost Book';</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Usually the issues lies in the PS_TRANSACTION_INV that has not been updated properly and this is the second query that returns a count <> 0. Note that if a negative completion following by a positive completion was recorded for the PID in an attempt to solve the issue, this is the first query that returns a count <> 0 and not the second one.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Most of the times, once you are sure that there's no staging error and no staging ID waiting to be processed for your PID, the best way to solve the issue is just to update PS_TRANSACTION_INV with the missing information. You might have to add the missing Putaway with a Transaction Groups 021 into PS_TRANSACTION_INV or update an existing Putaway that was created manually into Inventory. Here is the list of fields that must be updated (there might be others depending on how you are using the system):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">DT_TIMESTAMP</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SEQ_NBR = 1</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">RECEIVER_ID = ALL</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">RECV_LN_NBR = 999</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">TRANSACTION_GROUP = 021</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">QTY_BASE</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">QTY</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">UNIT_MEASURE_STD</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">UNIT_OF_MEASURE</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">COSTED_FLAG = Y or N</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">MA_PRDN_ID_FLG = Y</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">PRDN_AREA_CODE</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">PRODUCTION_TYPE = PR</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">STAGED_TYPE = 1</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">TRANSACTION_SOURCE = WL</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">OP_SEQUENCE</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">If you are adding a row PS_TRANSACTION_INV, you have to decide if you want the row to be taken into account by the costing process by setting the field COSTED_FLAG either to Y or to N. If you set it to Y, the costing process will skip the row.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Once the missing row has been added into PS_TRANSACTION_INV or the existing manual Putaway modified, check the Pending Transactions page to make sure that Completion Pending Putaway = 0. Run then the costing process and check the results to make sure everything is fine.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">=== QUERY VIEW INFORMATION ===</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">*** Query view CM_NP_PID_VW:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT A.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, D.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, A.PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, A.MG_OUTPUT_ITEM</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, (A.COMPLETED_QTY - B.COMPLETED_QTY)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, %Substring(C.MESSAGE_TEXT, 1, 50)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">FROM PS_CE_OUTPUT2_VW A</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PS_CE_PID_CMP_VW B</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PSMSGCATDEFN C</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PS_CM_BU_BOOK_TBL D</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.PRODUCTION_ID = B.PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.MG_OUTPUT_ITEM = B.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND (B.COMPLETED_QTY - A.COMPLETED_QTY) <> 0</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND C.MESSAGE_SET_NBR = 15500</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND C.MESSAGE_NBR = 177</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.BUSINESS_UNIT = D.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND D.CM_BOOK_STATUS = 'A'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">*** Query view CM_NP_PID2_VW:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT A.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, B.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, A.PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, A.MG_OUTPUT_ITEM</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, A.COMPLETED_QTY</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, %Substring(C.MESSAGE_TEXT, 1, 50)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">FROM PS_CE_OUTPUT2_VW A</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PS_CM_BU_BOOK_TBL B</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PSMSGCATDEFN C</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND B.CM_BOOK_STATUS = 'A'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.COMPLETED_QTY > 0</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND C.MESSAGE_SET_NBR = 15500</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND C.MESSAGE_NBR = 177</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND NOT EXISTS (</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT 'X'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">FROM PS_CE_PID_CMP_VW BB</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE A.BUSINESS_UNIT = BB.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.PRODUCTION_ID = BB.PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND A.MG_OUTPUT_ITEM = BB.INV_ITEM_ID)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">*** Query view CE_OUTPUT2_VW:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, MG_OUTPUT_ITEM</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, COMPLETED_QTY</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, MG_OUTPUT_TYPE</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">FROM PS_SF_OUTPUT_LIST</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE MG_OUTPUT_TYPE IN ('CP','CS')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">*** Query view CE_PID_CMP_VW:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, PRODUCTION_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">, SUM(QTY_BASE)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">FROM PS_TRANSACTION_INV</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PRODUCTION_ID <> ' '</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND TRANSACTION_GROUP IN ('021','221')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">GROUP BY BUSINESS_UNIT, PRODUCTION_ID , INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">=====================</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">The 'Insufficient Qty Cost Option' is there for you to decide if you want to cost the negative Depletions or to wait until a new Putaway is received.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">If you decide to cost the negative Depletions, then checking the 'Resolve Negative Inventory' check box on the Run Control page of the CM_CSTACCTG makes the 'Resolver' run. The 'Resolver' looks for any new Putaway to re-cost the negative Depletions based on the new Cost received on the new Putaway. If you do not select the 'Resolve Negative Inventory' check box, the 'Resolver' will not run.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Example in case you set the 'Insufficient Qty Cost Option' to 'Always cost insufficient qty':</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Assume there are 10 units of an Item available in the Inventory Business Unit and a demand line is shipped and depleted for 15 units, then the entire depletion transaction of the 15 units is costed the next time the CM_CSTACCTG process is run, even if this is before sufficient stock is placed in the Business Unit. Of the 15 units, 10 are costed using the existing stock on hand, and 5 are costed using the current Average Cost, current Standard Cost, or last Actual Cost depending on the Cost Method employed.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Assume now you have received the 5 units. Next time you run the CM_CSTACCTG process with the 'Resolve Negative Inventory' check box selected, the 'Resolver' runs and will do the following:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Applies the new Receipt quantities to the previously recorded negative inventory Depletion transactions. The 'Resolver' matches the negative inventory Depletion transactions to the actual Received stock.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Creates Adjustment Accounting entries for the Item using the Deplete Cost Method of Actual Cost. The 'Resolver' creates an entry to reverse the cost previously recorded for the negative inventory Depletion transactions and to record new transactions at the Actual Receipt Cost. The following Accounting Lines are created:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">* A reversing entry to remove the Depletion based on the last Actual Cost received before the negative state,</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">* An entry to record the Depletion based on the Actual Receipt Costs.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">For Items using the Deplete Cost Method at Current Standard, Perpetual Weighted Average, or Retroactive Perpetual Weighted Average, the 'Resolver' does not change the previously recorded cost for the negative inventory Depletion transaction. The Standard or Average Cost at the time of the Depletion is used on the original Depletion and is not changed when the 'Resolver' corrects the negative state by matching the negative inventory Depletion transactions to the actual received stock.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Inserts the resolved negative inventory Depletion transactions into a history table called PS_CM_RESOLVE_HIST.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Note:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Running the 'Resolver' is optional. It is highly recommended that you use this process to resolve all negative Depletion transactions so that reports and queries do not reflect negative states that have been resolved. The 'Resolver' does not impact the total on hand quantity. For costs, it only impacts the total inventory value for Actual Cost Items.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Two inquiries are available to monitor the costing of negative inventory Depletion transactions and the recalculations of the quantities and costs performed by the 'Resolver'. These queries are called CM_PENDING_RESOLVER and CM_RESOLVED_NEG_HIST and can be viewed using the Query Viewer.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">The CM_PENDING_RESOLVER query returns negative inventory Depletion transactions that have not been resolved.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">The CM_RESOLVED_NEG_HIST query returns negative inventory Depletion transactions that have been resolved and recorded in the history table PS_ CM_RESOLVE_HIST.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">================</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">1) Why aren't my rows costing?</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Follow the below step when you find out that some inventory transactions are not being costed by the CM_COSTING or the CM_CSTACCTG process:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Check the Message Log of your Process Instance in the Process Monitor.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Query the PS_TRANSACTION_INV.COSTED_FLAG field for the inventory transactions you want to check.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">If the value is 'X' it means that the inventory transaction doesn't need to be processed, for example because the Item is a non-costed or a non-owned Item.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">If the value is 'N', it means that the inventory transaction has not been processed yet or the process is not able to process it at this time (see the Top Reasons section below).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">If the value is 'Y', it means that the inventory transaction has been processed.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">2) Top Reasons why inventory transactions are not being processed</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Inventory transaction rows expanded for Books but not costed:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Possible reasons:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Costing hasn't been run for this Inventory Business Unit and Book</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_TRANSACTION WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Cost Adjustments not processed:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Possible reasons:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(a) The ''Apply Perpetual Average Adjs' check box has not been selected on the Run Control page.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(b) The Payables Matching process has been run for Voucher(s) before the corresponding Receipt(s) have been putaway.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_MATCHED_COST WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_COST_ADJ WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_ACTUAL_BOOK WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Receipts not costed:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Possible reasons:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(a) There is no cost for the Item.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(b) The process is waiting for the Voucher Cost from Payables or waiting for user to run the process in 'Regular Mode' for period end.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_RECEIPTS WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Depletion rows not depleted:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Possible reasons:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(a) Not enough qty on-hand to satisfy the depletion (see MESSAGE_SET_NBR & MESSAGE_NBR on the CM_DEPLETION rows).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(b) might be explainable if the negative inventory is allowed for the Inventory Business Unit </span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_DEPLETION WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Depletion rows not costed:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Possible reasons:</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(a) There is no cost for the Item.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">(b) The process is waiting for the Voucher Cost from Payables or waiting for user to run the process in 'Regular Mode' for period end.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_DEPLETE WHERE POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">3) SQL statements you can use to help you resolve missing cost issues</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Missing Receipt Costs (Actual and Average Costs):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">This query helps identifying rows from the PS_CM_RECEIPTS table which are not getting processed due to a missing Cost or Actual Cost rows without an Actual Cost.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_RECEIPTS, PS_CM_ITEM_METH_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE NOT EXISTS (SELECT 'X' FROM PS_CM_ACTUAL_COST</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PS_CM_RECEIPTS.BUSINESS_UNIT = PS_CM_ACTUAL_COST.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.INV_ITEM_ID = PS_CM_ACTUAL_COST.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.CM_DT_TIMESTAMP_A = PS_CM_ACTUAL_COST.DT_TIMESTAMP</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.CM_SEQ_NBR_A = PS_CM_ACTUAL_COST.SEQ_NBR)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.BUSINESS_UNIT = PS_CM_ITEM_METH_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.CM_BOOK = PS_CM_ITEM_METH_VW.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.INV_ITEM_ID = PS_CM_ITEM_METH_VW.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_ITEM_METH_VW.CM_TYPE IN ('1')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Missing Receipt Costs (Standard Costs):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">This query helps identifying rows from the PS_CM_RECEIPTS table which are not getting processed due to a missing Cost or Standard Cost rows without a Standard Cost (not accurate for Configured Items).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_RECEIPTS, PS_CM_ITEM_METH_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE NOT EXISTS (SELECT 'X' FROM PS_CM_STDCOSTD_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PS_CM_RECEIPTS.BUSINESS_UNIT = PS_CM_STDCOSTD_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.INV_ITEM_ID = PS_CM_STDCOSTD_VW.INV_ITEM_ID)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.BUSINESS_UNIT = PS_CM_ITEM_METH_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.CM_BOOK = PS_CM_ITEM_METH_VW.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.INV_ITEM_ID = PS_CM_ITEM_METH_VW.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_RECEIPTS.POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_ITEM_METH_VW.CM_TYPE IN ('2')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Missing Deplete Costs (Actual Costs):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">This query helps identifying rows from the PS_CM_DEPLETE table which are not getting processed due to a missing Cost or Actual Cost rows without an Actual Cost.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_DEPLETE, PS_CM_ITEM_METH_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE NOT EXISTS (SELECT 'X' FROM PS_CM_ACTUAL_COST</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_ACTUAL_COST.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_ACTUAL_COST.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_DT_TIMESTAMP_A = PS_CM_ACTUAL_COST.DT_TIMESTAMP</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_SEQ_NBR_A = PS_CM_ACTUAL_COST.SEQ_NBR)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_ITEM_METH_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_BOOK = PS_CM_ITEM_METH_VW.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_ITEM_METH_VW.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_ITEM_METH_VW.CM_METHOD IN ('1')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Missing Deplete Costs (Standard Cost):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">This query helps identifying rows from the PS_CM_DEPLETE table which are not getting processed due to a missing Cost or Standard Cost rows without a Standard Cost (not accurate for Configured Items).</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_DEPLETE, PS_CM_ITEM_METH_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE NOT EXISTS (SELECT 'X' FROM PS_CM_STDCOSTD_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_STDCOSTD_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_STDCOSTD_VW.INV_ITEM_ID)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_ITEM_METH_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_BOOK = PS_CM_ITEM_METH_VW.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_ITEM_METH_VW.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_ITEM_METH_VW.CM_METHOD IN ('8')</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">Missing Deplete Costs (Average Costs):</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">This query helps identifying rows from the PS_CM_DEPLETE table which are not getting processed due to a missing Cost or Perpetual Average Cost row without a Cost.</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">SELECT * FROM PS_CM_DEPLETE, PS_CM_ITEM_METH_VW</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE NOT EXISTS (SELECT 'X' FROM PS_CM_PERPAVG_COST</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">WHERE PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_PERPAVG_COST.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_PERPAVG_COST.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_DT_TIMESTAMP_A = PS_CM_PERPAVG_COST.DT_TIMESTAMP</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_SEQ_NBR_A = PS_CM_PERPAVG_COST.SEQ_NBR)</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.BUSINESS_UNIT = PS_CM_ITEM_METH_VW.BUSINESS_UNIT</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.CM_BOOK = PS_CM_ITEM_METH_VW.CM_BOOK</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.INV_ITEM_ID = PS_CM_ITEM_METH_VW.INV_ITEM_ID</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_DEPLETE.POSTED_FLAG = 'N'</span><br style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;" /><span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;">AND PS_CM_ITEM_METH_VW.CM_TYPE IN ('6').</span><br />
<span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #757575; font-family: Roboto, sans-serif; font-size: 15px;"><br /></span>
<span style="color: blue; font-family: Roboto, sans-serif;"><span style="background-color: white; font-size: 15px;"><b>HAPPY LEARNING :)</b></span></span></div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-22619699243165456832017-05-05T03:04:00.003-07:002017-05-05T03:12:07.026-07:00Insert rows using PeopleCode<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ud14fccf1-6e9c-43e5-a5fc-bd9a726d3ced" style="background: rgb(255, 255, 255); border: 0px; color: #343434; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
When inserting rows using PeopleCode, you can either use the <b>Insert method with a record object</b> or <b>create a SQL Insert statement using the SQL object</b>. If you do a single insert, use the Record Insert method. If you are in a loop and,therefore, calling the insert more than once, use the SQL object. The SQL object uses dedicated cursors and, if the database you are working with supports it, bulk insert.</div>
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ueda711e5-3921-4927-80b2-0d5324ca962a" style="background: rgb(255, 255, 255); border: 0px; color: #343434; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
A <span class="ph emphasis" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u1092db69-411f-49f9-b0b9-a4cf5fb4e20a" style="background: transparent; border: 0px; font-size: 13.3333px; font-style: italic; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">dedicated cursor </span>means that the SQL gets compiled only once on the database, so PeopleTools looks for the meta-SQL only once. This can increase performance.</div>
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__uaa820bfb-a5fc-415e-85a8-56c30f094d73" style="background: rgb(255, 255, 255); border: 0px; color: #343434; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
For <span class="ph emphasis" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ue3431a69-8bcc-4a34-93f5-9fcf2b01782f" style="background: transparent; border: 0px; font-size: 13.3333px; font-style: italic; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">bulk insert,</span> inserted rows are buffered and sent to the database server only when the buffer is full or a commit occurs. This reduces the number of round-trips to the database. Again, this can increase performance.</div>
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__uaa820bfb-a5fc-415e-85a8-56c30f094d73" style="background: rgb(255, 255, 255); border: 0px; color: #343434; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u96e51f07-985e-4861-b6a5-5e61186461a1" style="background: rgb(255, 255, 255); border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: blue;"><b>⇒ The following is an example of using the Record Insert method:</b></span></div>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><span style="color: blue;">&REC = CreateRecord(Record.GREG);
&REC.DESCR.Value = "Y";
&REC.EMPLID.Value = "12180014";
&REC.Insert();</span></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><span style="color: blue;">
</span></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><b style="background-color: blue; font-size: 13.3333px;"><span style="color: white;">⇒ Insert<span style="font-size: 13.3333px;">()</span></span></b></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="p" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__ub5fff510-6f7f-46e9-8616-7de18e2d03b3" style="border: 0px; color: #343434; font-family: arial, helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline; white-space: normal;">
The Insert method uses the field names of the record and their values to build and execute an Insert SQL statement which adds the given record (row of data) to the SQL table.<span style="font-size: 13.3333px;">Because this method results in a database change, it can only be issued in the following events:</span></div>
<span style="color: #880000; font-family: "courier new" , "courier";"><span style="white-space: pre-wrap;">
</span></span><ul class="ul B1" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__u51ce632d-3908-4166-bcf2-f5d164b282cd" style="border: 0px; color: #343434; font-family: arial, helvetica, sans-serif; font-size: 13.3333px; margin: 0px 0px 0px 1.3em; outline: 0px; padding: 0px; vertical-align: baseline; white-space: normal;">
<li class="li" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__uab6bb727-1acb-4809-bbb9-8c8d7987a039" style="background: transparent; border: 0px; font-size: 13.3333px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="p" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__u5c94a3ed-de25-4986-a754-eda4e86eb353" style="background: transparent; border: 0px; font-size: 13.3333px; margin-left: 0.5em; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
SavePreChange</div>
</li>
<li class="li" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__ue3075e7a-bbbf-4290-8969-8a177db098b8" style="background: transparent; border: 0px; font-size: 13.3333px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="p" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__u49d4f3d2-2210-44bc-958f-e9e31aeadb6b" style="background: transparent; border: 0px; font-size: 13.3333px; margin-left: 0.5em; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
WorkFlow</div>
</li>
<li class="li" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__u9358a31d-705a-444d-8e33-9a6f1a2b8c26" style="background: transparent; border: 0px; font-size: 13.3333px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="p" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__ud621c166-39c6-47bc-9b52-36b8a45351c5" style="background: transparent; border: 0px; font-size: 13.3333px; margin-left: 0.5em; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
SavePostChange</div>
</li>
</ul>
<div>
<span style="color: #343434; font-family: "arial" , "helvetica" , sans-serif;"><span style="white-space: normal;">Example:</span></span></div>
</pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><pre class="pre codeblock" id="u2f460c8c-78f6-4542-8e70-2fe0ca5ff115__u3de40bf1-55bd-4876-bd15-b7e00fc84cdc" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; box-sizing: border-box; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><span style="color: blue;">Local record &REC;
&REC = CreateRecord(RECORD.MYRECORD);
&REC.KEYF1.Value = "A";
&REC.KEYF2.Value = "B";
&REC.MYRF3.Value = "X";
&REC.MYRF4.Value = "Y";
&REC.Insert();</span></pre>
</pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__u22dbf83d-2736-43cb-913b-51e6801c9237" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"></pre>
<div class="p" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ub003b397-9082-4b01-80a7-89c15d4f7af2" style="background: rgb(255, 255, 255); border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 13.3333px; margin-top: 0.85em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: blue;"><b>⇒The following is an example using a SQL object to insert rows:</b></span></div>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">&SQL = CreateSQL("%INSERT(:1)");
&REC = CreateRecord(Record.GREG);
&SQL.BulkMode = True;
For &I = 1 to 10
&REC.DESCR.Value = "Y" | &I;
&REC.EMPLID.Value = &I;
&SQL.Execute(&REC);
End-For;</pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #880000; font-family: "Courier New", Courier; font-size: 13.3333px; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><b><span style="color: blue; font-family: "arial" , "helvetica" , sans-serif;">
</span></b></pre>
<pre class="pre codeblock" id="u55cf4626-931c-4c48-aca4-bcbef0f7126a__ua6ddc517-ebdb-4423-8b05-f176a302b0a9" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; margin-bottom: 0.85em; margin-top: 0.85em; max-width: 90%; outline: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"><b><span style="color: blue; font-family: "arial" , "helvetica" , sans-serif;">HAPPY LEARNING:)</span></b></pre>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-32316633251572805552017-02-09T09:17:00.001-08:002017-02-09T09:17:43.070-08:00Creating Left Outer Joins in PSQuery<div dir="ltr" style="text-align: left;" trbidi="on">
To create a left outer join on a new query:<br />
<ol class="LISTNUMBER">
<li class="LISTNUMBER">
On the Query Manager search page (Reporting Tools,
Query, Query Manager), click the Create New Query link.<br />
</li>
<li class="LISTNUMBER">
On the Records page, search for the first (left) record
for the left outer join.<br />
</li>
<li class="LISTNUMBER">
Click the Add Record link on
the same row as the record that you want to add.<br />
<br />
The Query page appears.<br />
<br />
</li>
<li class="LISTNUMBER">
Select the appropriate fields to add to the query.<br />
</li>
<li class="LISTNUMBER">
Navigate to the Records page.<br />
</li>
<li class="LISTNUMBER">
Find the joining record and then click the Join
Record link on the same row as that record.<br />
</li>
<li class="LISTNUMBER">
<div class="NOTETEXT">
Select Join to get additional fields only
(Left outer join). </div>
</li>
<li class="LISTNUMBER">
Complete the join.<br />
<ul class="B2">
<li class="B2">
If the Enable Auto Join preference
is selected on the Query Preference page, click the record name to join with.<br />
</li>
<li class="B2">
If the Enable Auto Join preference
is not selected on the Query Preference page, click the OK button.<br />
</li>
</ul>
</li>
<li class="LISTNUMBER">
Define the join criteria.<br />
<ul class="B2">
<li class="B2">
If the Enable Auto Join preference
is selected, the Auto Join Criteria page appears.<br />
You can clear the criteria from the query. You can also click the Add
Criteria button to add or edit criteria or conditions. If no
common keys are between the two join records, a message appears instead of
the Add Criteria page.<br />
</li>
<li class="B2">
If the Enable Auto Join preference
is not selected, the Auto Join Criteria page does <i>not</i> appear.<br />
If you want, navigate to the Criteria page to add criteria to the ON
clause of the outer join. The <i>This Criteria Belongs To</i> drop-down
list box specifies where the criteria will appear. Select the alias that corresponds
to this join record.<br />
</li>
</ul>
</li>
<li class="LISTNUMBER">
Define the effective date criteria.<br />
<ul class="B2">
<li class="B2">
For 2–3 tier client: If the joined record is an effective-dated
record, the Effective Date Criteria page appears.<br />
You can accept the defaults or change them as desired.<br />
</li>
<li class="B2">
For 4–tier PeopleSoft Pure Internet Architecture:
If the joined record is an effective dated record, a message appears stating
that an effective date criteria has been automatically added.<br />
Optionally, you can navigate to the Criteria page to change the defaults
for this criteria.<br />
</li>
</ul>
</li>
<li class="LISTNUMBER">
To ensure that the left outer join finished successfully,
navigate to the Query page.<br />
Text for the joined records confirms a successful left outer join.<br />
</li>
<li class="LISTNUMBER">
(Optional) If the query has multiple joins to the same security
record, which can be resource intensive and time consuming when it runs, select
the Security Join Optimizer option to improve the performance of this query.<br />
<br />
<br />
<b><span style="color: blue;">HAPPY LEARNING :)</span></b><br />
</li>
</ol>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-33565416148114985602016-12-08T04:33:00.000-08:002016-12-08T04:33:25.831-08:00 Difference between do-while, do-when, do-until and do-select in app engine.<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">I have sometimes found the<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Do</span></i><span class="Apple-converted-space"> </span>actions in an Application Engine to be pretty confusing – especially the nature of iterations that happen with each of these actions. I thought it would be informative to share some insights into the working of these actions in an AE program.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Consider the following scenario:</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="color: blue; font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">If we have a select statement as below:<span class="Apple-converted-space"> </span></span></span><span style="color: blue; font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="color: blue; font-family: Arial; font-size: 13px;"><br /></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="color: blue; font-family: Arial; font-size: 13px;"><span style="color: blue; font-family: Arial;">Select<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">emplid<span class="Apple-converted-space"> </span></span></i>from PS_JOB where action_dt = sysdate order by emplid.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Suppose executing this query on your DB returns 10 rows. To understand the working of the Do actions, if I embed this query in an AE and print the emplid in a file,<b><span class="Apple-converted-space"> </span></b></span></span><span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">how many EMPLIDs will be printed in case of each Do actions?</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">The Do When in the above diagram can be replaced by Do While and Do Select, while checking for the number of iterations. The Do Actions will contain the SQL select statement as mentioned before and the Peoplecode will write the Emplid value to a File. In case of Do Until, Peoplecode will precede Do Until (as Do Until is the last action).</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Coming back to our original question.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">How many times will the EMPLID be written in the file in each of these cases??</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-size: 13px;"><b><span style="font-family: Arial;"><span style="font-family: Arial; font-weight: bold;"><span style="color: blue;">Do When:</span><span class="Apple-converted-space"> </span></span></span></b></span><span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Do When is a loop entry criteria. This will always be executed once and only once as long as the SQL statement fetches a row. Thus, with Do Until, one row will be printed. This is pretty straight forward.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-size: 13px;"><b><span style="font-family: Arial;"><span style="font-family: Arial; font-weight: bold;"><span style="color: blue;">Do While:</span><span class="Apple-converted-space"> </span></span></span></b></span><span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">All those of you who thought that the Do While loop will iterate 10 times will need to rethink the working of this loop. Do While will continue executing until at least one row is fetched. The background execution logic of a Do While loop is as follows: Every time, the AE executes the SQL select statement in the Do While Action, if it returns a row it will proceed to further actions, if not the step will be terminated. What is to be understood here is that, in the absence of a loop termination criteria (or in other words logic to discard already selected rows) the Select statement inside a Do While will always fetch the same row. This will mean that a query like the one we have written (select emplid from ps_job) will go into<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">an infinite loop</span></i>, as there is no termination criterion for this SQL. Thus, this will go into an infinite loop and the same EMPLID (the first Id returned by the query) will be printed in the file. Always keep in mind that a loop termination criterion is absolutely necessary in case of a Do While.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-size: 13px;"><b><span style="font-family: Arial;"><span style="font-family: Arial; font-weight: bold;"><span style="color: blue;">Do Until:</span><span class="Apple-converted-space"> </span></span></span></b></span><span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Do Until is uncomplicated. It will execute<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">until<span class="Apple-converted-space"> </span></span></i>a row is returned by the query and this ensures that the step is executed atleast once. As the query returns a row, the loop gets terminated after the first iteration itself.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-size: 13px;"><b><span style="font-family: Arial;"><span style="font-family: Arial; font-weight: bold;"><span style="color: blue;">Do Select:</span><span class="Apple-converted-space"> </span></span></span></b></span><span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Do Select is the most commonly used Do action. But I left Do Select for the last because even this is kind of tricky like Do While. I do not know how many of you have noticed the various types of a Do Select action:</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN6xb2LQSrihEpttGRKW7jhne5396io-wRNp8_H2m91PgDqq0qjuprQA2tmywIzrfwTFLQ0QVPshiUPkLc6jeqNwSK8C82cTQABHttk9n_QBXsdIV5O6pKsJP4vKy9KkIheQzhSlyDT3M/s1600/Do-Select.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN6xb2LQSrihEpttGRKW7jhne5396io-wRNp8_H2m91PgDqq0qjuprQA2tmywIzrfwTFLQ0QVPshiUPkLc6jeqNwSK8C82cTQABHttk9n_QBXsdIV5O6pKsJP4vKy9KkIheQzhSlyDT3M/s1600/Do-Select.jpg" /></a></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">What concerns us out here is the difference between<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Select/Fetch</span></i><span class="Apple-converted-space"> </span>and<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Reselect</span></i>. Will there be any difference if I run the Do Select in these two different modes?</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">Yes, the working of the Do Select is completely different in these two cases. In case of a<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Select/Fetch<span class="Apple-converted-space"> </span></span></i>the loop will iterate 10 times, while for<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Reselect</span></i><span class="Apple-converted-space"> </span>an infinite loop is triggered (exactly similar to a Do While). The reason lies in the difference in working of these two Do Select types.<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Select/Fetch<span class="Apple-converted-space"> </span></span></i>hits the Db just once, fetches all the values of the Select statement and puts it in a cursor and moves through the cursor during each iteration. This allows a sequential processing which is so integral to row by row processing in an Application Engine. While<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Reselect<span class="Apple-converted-space"> </span></span></i>queries the DB for each iteration and picks up the first row returned by the select statement and puts it in a cursor. Thus, at any given point of time there will be only one row in the cursor of a Reselect type Do Select action. Moreover, Reselect will be slower than a Select/Fetch due to the DB trips involved in the former. Why does Reselect go into an infinite loop? This happens because for each iteration, the same SQL select statement is fired and the row returned first is buffered into the cursor (unlike a Select/Fetch where the SQL is executed against the DB once and then the AE moves successively through the cursor and terminates once it reaches the end of the cursor). Thus, in case of a Do Select of Reselect type, we will get a result similar to Do While – an infinite loop with the same EMPLID printed.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;">So what is the difference between a Do Select of Reselect type and a Do While? Remember that Reselect is used when the Restart function of an AE is turned on. A Select/Fetch Do Select does not execute commits for the entire action and thus will not be useful in case of a restart. This deficiency is overcome by the Reselect type, where commits are executed during the Step execution. At hindsight, I would always recommend to use the<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Restartable<span class="Apple-converted-space"> </span></span></i>function (which is similar to Select/Fetch but with commits turned on) over the<span class="Apple-converted-space"> </span><i><span style="font-style: italic;">Reselect<span class="Apple-converted-space"> </span></span></i>option. Coming to the difference between a Do Select (Reselect) and a Do While boils down the elementary question – why do we have two separate actions if they perform the same function? Do While and Do Select are fundamentally different, the first is similar to a FOR loop (executes for a definite number of times), while the latter is similar to a WHILE loop (executes till a condition is true). That is exactly the reason why a Do While comes before a Do Select.</span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<span style="font-family: Arial; font-size: 13px;"><span style="font-family: Arial;"><span style="color: blue;"><b>HAPPY LEARNING :) </b></span></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-3422008967130907402016-11-14T02:55:00.003-08:002016-12-08T04:34:16.841-08:00Validating Email Address in Peoplecode <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
We have a number of pages in PeopleSoft, where user/admin is free to
enter email addresses. How to validate if a value entered in a
PeopleSoft field is a valid email address?</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
In general, how does an email id look like? It will have few characters
followed by @ symbol followed by few characters and then a .(dot) symbol
followed by few more characters. So, we have to validate the presence
of these.</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
For example, if &email_addr is a variable which contains the string
entered in email address field and needs to be validated then try the
below code:</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">&AT = Find("@", &email_addr);</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">&DOT = Find(".", &email_addr);</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="color: blue;"><br /><span style="background-color: #cfe2f3;"></span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">If ALL(%AT,&DOT) Then</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">/* Validation Success */</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">Else</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">/* Validation Fail*/</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="background-color: #cfe2f3; color: blue; font-family: "arial"; font-size: 10pt;">/* Issue Error message */</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="font-family: "arial"; font-size: 10pt;"><span style="background-color: #cfe2f3; color: blue;">End-if;</span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="font-family: "arial"; font-size: 10pt;">Additionally we could also perform checks to ensure that:</span></div>
<ul style="margin-top: 0cm;" type="disc">
<li class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;"><span style="font-family: "arial"; font-size: 10pt;">the position of @ is not the first character</span></li>
<li class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;"><span style="font-family: "arial"; font-size: 10pt;">.(dot) is not the last character.</span></li>
<li class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;"><span style="font-family: "arial"; font-size: 10pt;">@ is not repeated else where in the string</span></li>
<li class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;"><span style="font-family: "arial"; font-size: 10pt;">Dot is not repeated else where in the string</span></li>
</ul>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="font-family: "arial"; font-size: 10pt;">This can be done by using instr, substr and len functions.</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
</div>
<div class="MsoNormal" style="margin: 0cm 0cm 0pt;">
<span style="color: blue;"><span style="font-family: "arial"; font-size: 10pt;"><b>HAPPY LEARNING</b> <b>:)</b></span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com1tag:blogger.com,1999:blog-8619900120224268863.post-89316600099296129632016-11-09T07:29:00.001-08:002016-12-08T04:34:34.370-08:00Custom Run Control Page<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue;"><b><span style="font-size: large;">Creating a Custom Run Control Page</span></b></span><br />
<br />
This step is the same regardless of whether you will ultimately use the
Run Control page with an SQR or App Engine program. Do the following in
Application Designer:<br />
<br />
<span style="color: blue;"><b><span style="font-size: medium;">Creating the Run Control Record</span></b></span><br />
<br />
<ol>
<li>Open Record definition PRCSRUNCNTL and make a copy by using "Save
As" and giving the Record a new name (for example, "MY_PRCS_RC").</li>
<ul>
<li>When prompted to save a copy of the PeopleCode associated with PRCSRUNCNTL, choose "Yes".</li>
</ul>
<li>Update the following Record PeopleCode definitions on your new Run
Control Record, replacing references to PRCSRUNCNTL with your custom Run
Control Record name:</li>
<ul>
<li>OPRID.RowInit</li>
<li>RUN_CNTL_ID.SaveEdit</li>
<li>LANGUAGE_CD.RowInit</li>
<li>LANGUAGE_OPTION.FieldChange</li>
</ul>
<li>Add any desired additional fields to your custom Run Control Record (for example, "STRM").</li>
<li>Build the Record.</li>
</ol>
<div>
<span style="color: blue;"><b><span style="font-size: medium;">Creating the Run Control Page</span></b></span></div>
<div>
<ol>
<li>Create a new Page definition and save it with a new name (for example, "MY_PRCS_RC").</li>
<li>Insert a Subpage onto your page, and choose "PRCSRUNCNTL_SBP".</li>
<ul>
<li>On the Insert Subpage dialog, change the "Subpage Record Name
Substitution" value to your custom Run Control Record (i.e.,
"MY_PRCS_RC").</li>
</ul>
<li>Drag your custom Run Control fields onto the Page (i.e., "STRM").</li>
<ul>
<li>Note: You do not need to add the default Run Control fields onto
the page (OPRID, RUN_CNTL_ID, etc). These values will be populated
automatically through PeopleCode.</li>
</ul>
</ol>
<div>
<span style="color: blue;"><b><span style="font-size: medium;">Creating the Run Control Component</span></b></span></div>
</div>
<div>
<ol>
<li>Create a new Component definition.</li>
<li>Set the Component Search Record to your custom Run Control Record (i.e., "MY_PRCS_RC").</li>
<li>Save the Component with a new name (for example, "My PRCS_RC").</li>
<li>Register your Component using the Registration Wizard (Tools > Register Component).</li>
</ol>
</div>
<div>
<span style="color: blue;"><b><span style="font-size: large;">Creating the Process Definition</span></b></span></div>
<div>
</div>
<div>
In this step, we create a Process definition entry for our SQR or App
Engine program, and associate the process definition with our custom Run
Control component.</div>
<div>
<ol>
<li>In the PIA, navigate to: PeopleTools, Process Scheduler, Processes</li>
<li>Click the "Add a New Value" tab and enter the Process Type and Process Name.</li>
<ul>
<li>Note: The Process Name must exactly match the name of your App
Engine program, or in the case of an SQR, must exactly match the file
name of your SQR file (without the ".sqr" extension suffix).</li>
</ul>
<li>On the "Process Definition Options" tab:</li>
<ol>
<li>Add your custom Run Control Component under the "Component" grid area on the bottom left of the page.</li>
<li>Add whichever Process Groups are appropriate to grant process security to the appropriate persons.</li>
</ol>
</ol>
<div>
You should now be able to navigate to your Run Control page in the PIA,
fill out the Run Control parameters, and schedule your process to run on
the Process Scheduler.</div>
</div>
<div>
</div>
<div>
<span style="color: blue;"><span style="font-size: large;"><b>Retrieving Run Control Parameters</b></span></span></div>
<div>
</div>
<div>
Now that we have a way to provide Run Control parameters via a Run
Control page, we need to be able retrieve and use those parameters from
within a program. This part of the process is different for App Engine
and SQR programs.</div>
<div>
</div>
<div>
<span style="color: blue;"><b><span style="font-size: medium;">Run Control Parameters in App Engine Programs</span></b></span></div>
<div>
</div>
<div>
The standard way to store Run Control parameters in an App Engine program is to use a State Record. To set up the State Record:</div>
<div>
<ol>
<li>A requirement in naming State Records is that they must have "_AET"
as their suffix. Make a copy of your Run Control record, giving it a
new name (for example, "MY_PRCS_AET").</li>
<ol>
<li>When prompted to save a copy of the PeopleCode associated with the original Record, choose "No".</li>
</ol>
<li>Change the Record Type from "SQL Table" to "Derived/Work". A
Derived/Work Record doesn't persist any data to the database. Instead,
it acts as an in-memory data structure while the program is running on
the Process Scheduler.</li>
<li>Open your App Engine program, and navigate to: File, Definition Properties</li>
<li>On the "State Records" tab search for your State Record definition,
and click the "Add" button to move the definition from the left-hand
panel to the right-hand panel.</li>
</ol>
<div>
Now that the State Record is created and associated with the App Engine program, we need to populate it.</div>
</div>
<div>
<ol>
<li>Add an SQL step as the first step in the App Engine program. To
populate the State Record with values from the Run Control Record, we
use the Meta-SQL %Select function. For example:<br /><br /><span style="font-family: "courier new" , "courier" , monospace;"><span style="color: blue;">%Select</span>(OPRID, RUN_CNTL_ID, LANGUAGE_CD, LANGUAGE_OPTION, STRM)<br />FROM PS_MY_PRCS_RC<br />WHERE OPRID = <span style="color: blue;">%OperatorId</span><br />AND RUN_CNTL_ID = <span style="color: blue;">%RunControl</span></span></li>
</ol>
Now that the Run Control parameters have been stored into the State
Record, they can be referenced from PeopleCode via the State Record.
For example, the following would write the STRM Run Control parameter
value to the message log:</div>
<div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: blue;">MessageBox</span>(<span style="color: magenta;">0</span>, <span style="color: red;">""</span>, <span style="color: magenta;">0</span> , <span style="color: magenta;">0</span>, <span style="color: red;">"STRM="</span> | MY_PRCS_AET.STRM);</span></blockquote>
<br />
<span style="color: blue;"><b>HAPPY LEARNING :) </b></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com1tag:blogger.com,1999:blog-8619900120224268863.post-14397436518660767162016-11-08T08:58:00.001-08:002016-12-08T04:35:32.994-08:00SQLExec function<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="SUBTOPIC">
<span style="color: blue;"><b>Description: </b></span></div>
Use the SQLExec function to execute a SQL command from within a PeopleCode program by passing a SQL command string. The SQL
command bypasses the Component Processor and interacts with the database server directly. If you want to delete, insert,
or update a single record, use the corresponding PeopleCode record object method.
<br />
If you want to delete, insert, or update a series of records, all of the same type, use the CreateSQL or GetSQL functions,
then the Execute SQL class method.<br />
<br />
<div class="SUBTOPIC">
<b><span style="color: blue;">Limitation of SQLExec SELECT Statement:</span></b></div>
SQLExec can only Select a single row of data. If your SQL statement (or your <b>SQL</b>.<i>sqlname </i>statement) retrieves more than one row of data, SQLExec sends only the first row to its output variables. Any subsequent
rows are discarded. This means if you want to fetch only a single row, SQLExec can perform better than the other SQL functions,
because only a single row is fetched. If you need to SELECT multiple rows of data, use the CreateSQL or GetSQL functions
and the Fetch SQL class method. You can also use ScrollSelect or one of the Select methods on a rowset object to read rows
into a (usually hidden) work scroll.<br />
<br />
<b>SQLExec</b> statements that result in a database update (specifically, UPDATE, INSERT, and DELETE) can only be issued in the following
events:
<br />
<ul class="B1">
<li class="B1">
SavePreChange<br />
</li>
<li class="B1">
WorkFlow<br />
</li>
<li class="B1">
SavePostChange<br />
</li>
<li class="B1">
<div style="text-align: left;">
FieldChange<span style="color: blue;"><b> </b></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: blue;"><b>Syntax: </b></span></div>
<div style="text-align: left;">
<span style="font-family: inherit;"><span style="font-size: small;">SQLExec("Select sum(posted_total_amt) from PS_LEDGER</span></span><span style="font-family: inherit;"><span style="font-size: small;"> </span></span></div>
<div style="text-align: left;">
<span style="font-family: inherit;"><span style="font-size: small;">where deptid between :1 and :2", DEPTID_FROM, DEPTID_TO, &SUM);</span></span></div>
<div style="text-align: left;">
<pre> <span style="color: #38761d;"> </span></pre>
<pre><span style="color: #38761d;"><span style="color: black;"></span><span style="font-size: small;">:1 is replaced by the value contained in the record field DEPTID_FROM;</span></span></pre>
<pre><span style="font-size: small;"><span style="color: #38761d;">:2 is replaced by the value contained in the record field DEPTID_TO.</span> </span></pre>
<pre><span style="font-size: small;"><span style="color: #38761d;">&SUM will be assigned value of sum(posted_total_amt) selected.</span></span>
</pre>
</div>
<span style="font-size: small;"><span style="color: blue;"><b>HAPPY LEARNING :) </b></span></span>
</li>
</ul>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-89365346941245341052016-10-31T01:09:00.007-07:002016-12-08T04:35:45.883-08:00 Access level 1 field from level 0<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;">/*Declaring Variables*/</span></span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"></span>Local Rowset &rowset;</span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Local Record &rec;</span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Local Field &field;</span></span><br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"><span style="color: black;">&rowset0=getlevel0();</span> <span style="font-size: x-small;"> /*Get level 0 rowset*/</span>
<br /><span style="color: black;">&row=&rowset0.getrow(1)</span>; <span style="font-size: x-small;">/*Get row 0 of level 0 rowset*/
</span><br /><span style="color: black;">&rowset1=&row0.getrowset(scroll.RECORD_NAME1);</span> <span style="font-size: x-small;">/*Get rowset from
row 0 using the scroll name(can also be the name of the primary record
in the scroll)*/</span>
<br /><span style="color: black;">&row1=&rowset1.getrow(1);</span> <span style="font-size: x-small;">/*get row1 of level 1 rowset*/
</span><br /><span style="color: black;">&rec1=&row1.getrecord(record.RECORD_NAME2); </span><span style="font-size: x-small;">/*get record in the row1*/
</span><br /><span style="color: black;">&field1=&rec1.FIELD_NAME;</span> <span style="font-size: x-small;">/*finallay access the field in the record*/ </span></span></span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"><br /></span></span></span>
<span style="font-size: x-small;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: #38761d;">OR------</span></span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"><br /></span></span></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">&rowset1 = <span style="color: #38761d;"><span style="color: black;">getlevel0(1).</span></span><span style="color: #38761d;"><span style="color: black;">getrowset(scroll.RECORD_NAME1);</span></span></span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"><span style="color: black;">&field = &rowset.getrecord(record.RECORD_NAME).FIELD_NAME;</span></span></span></span><br />
<br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="color: #38761d;"><span style="color: black;"><span style="color: blue;"><b>HAPPY LEARNING :) </b></span></span></span></span></span></div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com3tag:blogger.com,1999:blog-8619900120224268863.post-68986155638759132632016-10-13T11:48:00.000-07:002016-10-31T01:12:44.173-07:00Trigger Peoplecode on selection of radio button.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: inherit;"><span style="font-family: inherit;"><span style="color: #444444;">When we are working with radio buttons, there is a problem say </span><span style="color: #444444;">associated peoplecode does not trigger when we select radio button. Lets learn how </span><span style="color: #444444;">associated peoplecode can be triggered on selecting radio button below.</span></span> </span><br />
<br />
<span style="font-family: inherit;"><span style="color: #444444;">Create a simple Peoplesoft page having radio buttons.</span></span><br />
<br />
<img alt="" height="173" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA3MAAADvCAIAAADXZxqIAAAKn0lEQVR4nO3dTXLbOAKG4RxjrhPfIN7NdVy6zlwlm1TlKllqFqrWcEgQBMGPFMU8T6G6Yog/kNqiX9NO97c7AAC0+f3r5+Oft6/bx/eP0aPf7vf7NwAA2EZZAgCQoSwBAMhQlgAAZChLAAAyymV52N8tAgDgvQz/briyBACgn7IEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBjdVkCAHAxyhIAgJjXlOUfAADe3DAHlSUAAP2UJQAAGScqy//8+1+j8dqXpriAU60QAGiX+sI9bYDKkVedtFgX+51uj4OcqyyDT2y7ubJc3GbVBgDAMbLVNf3DxpPWwyN+up0OoixntZTl3GaNjwIAh5n7orxq/h3LMvLEG71NWU5/AP348/CFLt4unturccvKkhYXWTymH6MDwEu0/KC5Pv9nUniVzVo2qGdM/HSN89cvy2Lwjf59bNlrcffpo+2nK+4rLgHgYNN7PcVtWn7VrbEWKmcpbrzT6YqHqsxfpyxHo/gMF6MttVfHPcvGg1TmAYCdxL86zyXd9kTJnq5y9rnjLx5kzrnKsvISTItztP3GHl08/tzkqoMUuxkAOEDqnuXogI0/C62spLJl5HTDR/+ue5aVF6Jx8s/SC903WTlpx5EriwcAdlL8It7dl5XC26Mst5zuz8pn+neVZXu0dUyuvWc5d7TF0ylLADjY4j2pxvnRo+cvy+wTr3uPsvyz9MPu4gaLexXvii+WZeUn2sWD1M8CABwj+MW32BvTmcq9pMWwyZ5ulYuUJQDAftzWaaQsAQAo+PYiyhIA4GqGbTfXefH515dl5KwAAAyNKuuYuFSWAAAXNK2sA+JSWQIAXFCxsg67c6ksAQCu45iILE4qSwCAS6mE1n7zyhIA4IKekVd5ND6vLAEALuhZWUfGpbIEALigafDVt4nMK0sAgAsq/px6cbON88oSAOCCppV1QFwqSwCACypW1mF3LpUlAMB1HBORxUllCQBwKZXQ2m9eWQIAXNAz8iqPxueVJQDABT0r68i4VJYAABf07UXuyhIAgBRlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoy7dx+7o9x6vXMnbmtc2xZgCIU5Zv4FESH98/nuM8bXHmtc2xZgDYibI8u2dPDCenMyOfPz4fYzRTeWg4c8zanmfsWNLo6ey35sW1DZ/OaHK62j6r1jw919zZN64KAKaU5dk9qmI6/3i55xxZlqvWVsyvLUvqK8v2NdfX1vgiR8py7ZoXT60sAYhTlqc2lxQPi2FRz7jih7uurX7zrLKkyk3BVSvvXnP91avsVX/iu6559Of217D4KdH9eQLAX0VZnpqyfHxYeWpnKMvpGhoDdKc1Fxcweuj+//nb8jkzmgSAKWV5avuV5f2f2uhOn8i9tPYlzbXaMWVZWdtwYcVXe+0it695tIbRTEdEKksAGinLU7twWa5aUiUoX16Ww83mlneGstxye1JZAtBIWZ5d9984WbzJN3f7au+1TT+sL6kxMfdec8vLVVnzlhrb8re4Kn9WlgDEKcuzu33dfv/6OWqI6cxT+52qSFmuWtu9LRP3Lsu+13NxbfU1byzLta9zcQ2Li1w1CQBTyvJtPEpiVU/cl1IslQuNaxueq9I9xcnRXhubuH3NHWubripVYx2v8+jDuW8n5p5RcfftTwSAq1KWAABkKEsAADKUJQAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkKEsAADKUJQAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkKEsAADKUJQAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkKEsAADKUJQAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkKEsAADKUJQAAGa8sSwAArkdZAgCQ8ZqyjJwVAIDrUZYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWQIAkKEsAQDIUJYAAGQoSwAAMpQlAAAZyhIAgAxlCQBAhrIEACBDWW51+7qZNHnwJFTcvm6P0TJ5wC59C3vhJLCFstzkcT0qXnlNmtxpEiqGny3DCqxssPcuaxf22klgI2W5yQmzw+TlJ6FR8TOn2FX77dKxsPNMAh12L8vPH5+fPz7nPmzfsbhB3xqeM8PReKiRE2aHyctPnsGWd83zCPVjHn+tWHtNaNymeLXZ/gK2UJbKEo73rmW56ro8V5Z9R3saXomKV16TJuOTJ7ExjIq7v/xaMdyypVZX1ecxKTm02E/TDfbYpWNhJ5kE+rysLOe+dy/OF7/dr2xQOVRlVWu/sN3++dXv2+AXwE2a3HXyJObeHZW3UuX9WzzmkdeK+gK6D1u5nsw9u8ozXdumxc+Z4eR0gz126VjYSSaBPi8uy7mvHKNH53afnqJ+qPqqOspy+meTJnedPIm5MptuUH97Vo552LWiZQF9h20vy5ZnOve6FbX0U/3D1C4dCzvDJNDt9fcsFyeHH3aU5fRQo6O1f+UbKn7vbtLkfpOnUnmDFN+q9YYrTh52rVhcQPdh28uycpyOspSVshJe6D3KsuX7+MbrfuOqlKXJs02eytwbZPEdWtn9VdeKxQV0HzZYlnNrnrq1/WbF8BNsv106FvbySWCjNyjLvu/j9y5L+Jt1v+kq769XXSuCC5gesO/gcxsAnN97/J5l+2W9fqjFVc1tDwy1l2V7Lb3qWlFff/dhG6853ScCOKcj/kvpz0t/y9eYyvV07gijDeqHKh5wupfLN1TMvYMWJ0dHqB92tOV+14rKvt2HTZVlfc0AZ/Oy/wfPaa+Sp10Y/J28JQHeiLL8H3cF4IS8KwHeiP9vOAAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkKEsAADKUJQAAGcoSAIAMZQkAQIayBAAgQ1kCAJChLAEAyFCWAABkLJTl718/R7O/f/00DMMwDMMwjOKoleXdPUsAANaYLcvf7lkahmEYhmEYK0e5LKezt6+bYRiGYRiGYdRHoSw/vn+MZj++fxiGYRiGYRhGffg9SwAAMprKEgAA1lKWAABkKEsAADKUJQAAGff7/b8wj9BaS4tlwAAAAABJRU5ErkJggg==" width="640" /><br />
<br />
<span style="color: #444444;">Now go to page properties and <u>uncheck allow Defferred Processing</u>.</span><br />
<br />
<img alt="" height="633" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjEAAAIrCAIAAACRQF9eAAAgAElEQVR4nO3dvZHkOtqm4RLbhBVWHEe6PJijrQEjjRcdacLnxroyyhdBL1ZeMVfIPQwU3h8CJEi8AG7EFR1ZTBIAQRJPMVld9bX9938+vigUCoVC6VvIJAqFQqFEKWQShUKhUKIUMolCoVAoUYqVSW8KhUKhUO4srz+v79/fP7Ln9ef1YWUVAAB3UDLp+/f3R5ZJv/7xbwAAbqJn0p5XZBIA4DFkEgCgvapnSN+/vz9bkUkAgPbe73fVA6TPVnomWT/j0H0nAQBDaJlJ+/1UlknZ3VbzHbivcqdF60sAwGlpJmWfwGVLjjPJ+uwunbWbz+C3Vn7YIgCgoew+KQ2XLGjaZ5J6f6Pe9zh3Qmrl6QurBusGy1pzry1boWqPuh9vAIjsLT67U1Pm3vskZ363Fspt5SYnqq2trapCAIBPZpL6IV6DTPJvIAojwcqk7C0rNmS1JW05tRVuK7sNAJDeD98npQ1X5YSzA37l19uqyiSrh8QSABx6P/w8KW14kUxy+gkASL0b/tzdfjdQkkm/Cn6cwV+YvqXWbLXl1ymXO7X90rJNvmuNAAAg9W74/5Os+6TTPbt1HicnACCacJn02I0FmQQA0bzf7/1XAh3i990BAG60/82jQp+tyCQAQBRkEgAgirpMKnxgBQDAOWQSACAKMgkAEAWZBACIgkwCAERBJgEAoiCTAABRkEkAgChmy6R319J99wFgaFNlUvdU+P793X0QAGBcDTKp761JWiKM5po7DgBNXM2kOHcGEabmz2g+326cowAAV1zKpAgxEKozvTKpV7sA0NYSmZR1/r5nY2QSAFxBJrUfzef3nUwCMAclk/Yn56cz6fApVBNZ5WEzSQ6j1QG5vLCrZBKAObS/T3osAJpkkrXLV0bTb71qTMgkAEtRMun15/XRJJPucz2TshdZOJ0ezcMBIZMAQKVkklXkxrWZlFW1J4FzpyJfy0RxOqOuaWXP4f4WjubhgFgRKPeUTAKwlBs/u3MiRKbR4TQtm2iSSVmHm4ymbN0KY3WPrMisbRcAhtP+ZxycGT+rzUopZx3rLaszh13KWrc2qRpNv3WnOTIJwOKe+xkHa2pOXzvrHK7s/2C6tSPWLl8ZTX9A1P6TSQCw3f0zDumGfqgcLrmYSU+OpjMg1q6RSQCwqZn0/fv741wmbT/vNpy7EHXy9dexanY68/xoytGwllhp5A97YbsAMJxb/s9sFxE6w+9xAIAryKT2o7lOuwDQFpnUfjTXaRcA2tIzaf+XTDoxmuu0CwBtnbxPOvXXUG8vQUaz9zBQKBRK9GJ9G30+k7oHAABgRM5HO2QSAOBRZBIAIAoyCQAQBZkEAIiCTAIARFGXSd//+q/vf/0XmQQAuMOZTPr+13+RSQCA5qo/uyOTAAA3IZMAAFGQSQCAKAJlklPnaXfUCQC4SaxMcr68gjQCgCGQSQCAKB7NpNefl7S/a2WSbEU27X8659Ss1nZYobM7ACLjgXdwr4czSf6pjP1dp859he1nwFhL1A3ll6cr3PeUQqEMVMik+Koz6VOuZJL1rnOXkzakRkhJmMkvT1cIYERkUnzRM6nkJuYwNq7cJwGYBpkU32yZVHKftP19J1TeBIAJkEnxRc+kzf2JBrmksOYsdeTmfoUARkQmxRcok044nRncCQELIpPiGy+TrHarNs+WdD8MAB5AJsVXnUn7vxHukwCgHFNQfOPdJwHAOUxB8ZFJAFbBFBQfmQRgFUxB8fE8CcAqmILi4z4JwCqYguIjkwCsgikoPjIJwCqYguKL+zyp+99ZAa5g7guI4xLfK+x90qd5YET+hYBeyKT4omfSm0IJUKouKjIpLDIpvgEy6dc//g109DlpC9Nrv6KY+wIik+KrzqQnnyeRSYhgz6SqK4q5LyAyKT7uk4ADZNI0yKT4RsqkvfUms8xNK2M+ZNI0yKT4hsmkLJzkwtpZ5qaVMR8yaRpkUnzDPE9Sg4FMwgOyTPrSiryimPsCIpPiG/I+KZ0s0hWyL7MV0nWcreRbWdPqcmeJ1RZGIe+TnPOfTIqMTIpvmEz6Zcz76gzyS6TLL+PTP7mVXEFmUnk9ha0jMplJWxJL1hXF3BcQmRTfSJmUzhHZi1/ivqQwFaytajOppHV554QhqJm0/fd/ZCBtZFJsZFJ8wzxPyuYI68WvmjsVZ0lVJtUuwVisTPKvKOa+gMik+Ia5T7LuTqx3I2cS+TQWMmkaZFJ8w2TSL+NnBMo/PZPrHG5ltSiXH9Zs9R/xkUnTIJPiGymTgqjtUsBdQBUyaRpkUnxk0pkZqmQd7oqmQSZNg0yKj0wCDnxO2vK/5kcmhUUmxTdAJlEo3Qt/028OZFJ8oTOp++gApzH3BUQmxRc3k578LphCuaN0v7yRIZPiq8ukv/7518cDmQQAbTEFxXfmPolMAjAipqD4qu+TPrFEJgEYDlNQfHx2B2AVTEHxVX92RyYBGBRTUHw8TwKwCqag+PjsDsAqmILii/v/k5rsW0q++2RzrZp4bPSA+ZBJ8U2eSel/YJQTetvOHDbXqonHBhCYDFdQfPNn0mOtP9AcVxRwBVdQfMtl0v7B2v5vuiS9uck+hcs23MQnaU4myQ/0DpfI1x833YEBKyCT4qvOpP3fITIpe8DzmdD3z9ayL/cV0n3Zl2Qbyt1Rm9v+jq6sqpIlWcfSprmugBPIpPjmv09KS9qHNJPk8k27O7HWVJtT73KyqvYRy26qrOTjigKu4AqKb/5Mshb6SSPvTgozyWooi6usY2QS8ACuoPjIJDOTrJDYkoc95Zm0LyxZQiYBd+AKim/y50mnM2mzP7vb13HudTaRJfIhk79E3Ty9hwNQi0yKb+b7JKsz+8L3z58XUF/sJV1u7Ui2MP0yradwifpW1hMA5cik+CbPpDvGS35qB2AIE0xB0yOTqslP7QAMYY4paG4zP08CgBRTUHzcJwFYBVNQfGQSgFUwBcVHJgFYBVNQfDxPArAKpqD4pr1Pev38LXMqzs5eODrogvMqvpkz6fv3t8PvKjg6mA+ZFN/kmeSvY3Um/W49Xai+9hc6FbbazcI+hNL26Fzf6/sOEEIhk+Kb9nnS6VnvlfxG8PfPPznx/vsX08ltXz//3F9Jha12M+1JyQg3nMqDHJ3r59Ur+d3txNLEyKT4uE866GQaRe/kb1ioW6k7KBc2HIRzmZTu0TOH46ajs4nfV3t9GJm2JsbBjY9MOuhkOoNbgbSvqb5r7bX6AZT8wNBfInvrfK6VNZGtVtiZUEdHPUZOn60P6KxMsgaTe6lBkUnxkUkHnczmuxN752yVfQC1p1r6SWC2jlwie2utkN7MZS/KO9NkOr4jk5zhskYvrSGNn/2IW6PN1DYoDlx81Zm0wvOkw8/u1K2yfw/3Op0H04TYfoZH2tt0E3UdK4HUJeoMa3Um3a/rB/GmTJL3Ommf5ehlNWRxZVWY5hbGQibFx33SQSfVGdzZSk5Y1jS6GX9bfTMyafs5dabbqm1dzyS1zlBHp6rPcvSccXMWMq+Ni2MXH5l00ElrhrK2soIk/VLWdphJ6lZOb2Ul8taqKpPSmT3U0Snvs3MECzPp9fPDQAyHTIqPTNK3fWlPF+RsKLdy3pIVvoxP4bIgUbfatB85cxrKqs32wqk264x/iLscncPhskbPHzdnWJjaBsWBi686kwZ6nnS4jtMZ9ROebH25+b6+9ZasMF2otuVsZfXK2iSr1m/I6UzAo3M4XNbo+ePmDEuTccDDyKT4pr1PepeV7gdgTRwddEEmxTdtJgFAhikoPjIJwCqYguKb9nkSAGSYguLjPgnAKpiC4iOTAKyCKSi+UTPJ6UCTatMl3Q8SgCbIpPhGfZ6UNdokOYgiYG5kUnwD3yc5XzapE8BkyKT44mZS+ute0l/x8mFlkvrhW7bQ+sRPzaTPwvJKDncBwK14pD20V+RMcv5jv9OBfYVN+zhOLsm2kpFWUq3K+O0EFArlrkImja46k76eep7kr2wlQdYrNZP8MMvqV+OnsBIADyOTRhf9Psl617k3Sl/7SxwykwrvjQB0RCaNbulM+tI+l8teq0lGPgExkUmjmyqTNveHEeQSZ/OsoapKAPRCJo1u1OdJJ5AfwPTIpNGNep9UyOokgCmRSaObPJMALIVMGh2ZBGAeZNLoFnqeBGB6ZNLouE8CMA8yaXRkEoB5kEmjI5MAzINMGh3PkwDMg0waHfdJAOZBJo1utkx64K+zYDXMYgPxjxdHM77XfJn0/fsbaMU/pRENmTS66kwK/jzp0+k3hWKUqtOJTBoOmTS6Oe+Tukx2lCHKVvz3f/dr480sNg4yaXRkEmWt4p+i6rVRuD4iIJNGRyZR1ir+KapeG4XrIwIyaXTzP09SM/Wx0qVRilP8U1S9NgrXRwRk0ugmv0/KIqEwIQiSiYt/iqrXRuH6iIBMGt1amVRYyKSJS3qKfmlFXhtvZrFxkEmjWzGTsh1J98h6rX5pfR6Yrf/WPj+UQ0p5pmSnqHMmk0kjIpNGN/nzpMJMkhFSuKZswqrKWkgsPVzkKaqexhuZNCYyaXTcJ5nxoy48zCSrqmwTdVQpDxT1FJWBtJFJYyKTRkcmeVF0LpMKq6J0Kf4pql4bhesjAjJpdGtlkswVNWmuZJJalbWOfItyd/FPUfXaKFwfEZBJo5v8eVLW1WzhW8un/ctsc7k8eyErV4dLrZbyWPFPUfXaKFwfEZBJo5v8PolCyYp/iqrXRuH6iIBMGh2ZRFmr+Keoem0Uro8IyKTRkUmUtcrnJClEJg2HTBrd/M+TKJS08Df95kYmjW7C+6TuY4rJMIsNhEwa3WyZ9NR325S1SvcLFYXIpNHNlkkAVkYmjW6250kAVkYmjY77JADzIJNGRyYBmAeZNDoyCcA8yKTR8TwJwDzIpNFxn3TXsD5s3LFi5NEQmTQ6MunGYX2MP+xLYeQXRyaNjky6cVi9/4TZtPjDvhRGfnFk0uh4nnTjsDIzMvJ4GJk0Ou6TbhxWZkZGHg8jk0Y3bSZlvVLfletkS/xKDodVDpc6euo6YWfG8iGy3jo9qidGfh9b61gMNPIoQSaNbulMspbv7zbJpGzc1OnSXyfUzHg9tg+/FbhCZlIW/OOOPEqQSaOb+XlS2jHrtbrJY5nkzJVhZ8ahM0kO/kAjjxJk0uimvU/aCjIpfZHuS/oi/XIrnj3XzKTsfHCGV45q9t3AafJTU2tIyaQpkUmjI5OUt+RcuVVOl/7zJHUGVMc54Mz4JYo1ws7wOofgosJMGvG7AZQgk0Y3cyZt2uToJJBcYqVa4bD6s541AwafGbNxyPI7PSVODPh16sg73w2QSZMhk0Y38/OkLXAmOdNf8JnRySRn8MuXXJSNvPyOqjCfAo48SpBJo5v8PmlzcyVOJg00M5ZkUpD7pMNhH2vkUYJMGh2Z9P9fZPtycfY8fJ6kTo7ZOjFnRmsM02H0h1c9Iq3C6TCT5Pk8ysijBJk0uvkzqeOwnpjjzhV/2OO4HjmMPHxk0ugmf57Ud1iZGTftHpSRx33IpNFxn3TjsDIzMvJ4GJk0OjLpxmFlZmTk8TAyaXRk0l3D+nCL444VI4+GyKTR8TzpFo99n56W7nsdASO/ODJpdNwnAZgHmTQ6MgnAPMik0ZFJAOZBJo2O50kA5kEmjY77JADzIJNGRyYBmAeZNDoyCcA8yKTR8TwJwDzIpNFxnwRgHmTS6EJnEgDUIpOG9gqbSW8KhUI5VZpMQeiiOpMee54EAG0xBcUX9z4JANpiCoqPTAKwCqag+MgkAKtgCoqP50kAVsEUFB/3SQBWwRQUH5kEYBVMQfE9nUkA0BGZFNzryedJp/8HHIVCobQq3addOKoz6VPOZRIAAA4yCQAQBZkEAIji0edJAAA4uE8CAERBJgEAoiCTAABR8DwJABAF90kAgChiZZJaobVm97EDALQVKJPSevbXVvaQSQAwn0DPk9SYIZMAYB2P3iepv6Z3f9fKpM/y7M4p/TLrQ/dfPAwgOB57h/V6/u8nOb+jV1YoP8RLM0ldUzZBoVAoeyGTIuuQSSXdsqJoE5lkdQMAVGRSZNWZ9HXhedIdmdR9BAGMhUyKLNB9kv+R3ZY8W9rcz+4AwEEmRRYokzbj/ydZ+eRsAgAWMimyWJnkI3gAXEcmRRb0eVKGOyEArZBJkY10n4RD3f/bB+7GFdTkMmEYw3qRSTP5HDPMyr++UH6ZMIxhkUlT+Ryz2v9CSOlVqg4umdTwMmEYw6rOpC7Pk1CITBqrbMW/dmS/UN9cQS0uE4YxLO6TpkImjVX860Ue2fL14Q8mwxgWmTQVMmms4l8v8siWrw9/MBnGsMikqVzJpPT4yi8La5CnSmFz59a8o7kni3+9yCNbvj78wWQYwwr9PMlp5YryCgvXyWpr2NVzh3Of8rJDpv6brWx9WVKy71oK1yysVm6iNmfVfNhi1Vi1Kv71Io9s+frwB5NhDCv0fdKX8UuGrlDDw6r5sMWq2qp29srhlFOt/1pdcjGT/BqaZ9JhzbX3UuX5eqWk18uXVrIj619fKL9MGMawls6kw5qrMuliP+/IpFb3SdbRz2bYwxr2JfJ1+qXV/5LM21fLKrSas9pS/21esuvFuazIpIbIpMiGzCTZruyM2jdZZ7ryJu51TteW1nnYZ6sPpw/nufnRmvGtyd3ZxKpBrcR56zAV1DPT6bbT+S5FXi/WmUYmNUQmRTb28yQ5iVtL1GrlOmomnahNrad8ycXDeW5+dALmy/52pKQGuYlVodquXO503nqhnrdOhc8U9XpRzwQyqSEyKbKR7pPS5WnT6vxudU+t33pxsTanBnVJq8N5bn78Kg6Y2hrkJupbMnu+bsgkp5Lni3+9qBdq4frwB5NhDGu8TFJnfGdJSf2HmXSuNqeGkiWnD+e5+fEwUazMUL/0X5dk0n7KWXGiNiHP0sLOdyn+9SKPbPn68AeTYQxr/kzKKlHfyhaqyXS6thNLLh7O01OkeqzfPyf3dLXCzeUm1rmUNecEmNMTqxW/812Kf72oF2rh+vAHk2EMK/rzJGt51rSzxNlcbevLiJny2gprsDa09rr8cHacZEOVIMHjFP96US/UwvXhDybDGFbo+6QTrkzorWroiEz6lDh3Qn7xrxd5ZMvXhz+YDGNYM2SS1ZNz9XQ/JFeQSWOVrebPMJJJDS8ThjGsGTIJ2THrNMFSqgt/06/XZcIwhhX6eRJqvf68uvcBt+IKuo6JKDLuk6by+Df6lA6l+2k2OiaiyMgkAGthIoqMTAKwFiaiyHieBGAtTESRcZ8EYC1MRJGRSQDWwkQUGZkEYC1MRJHxPAnAWpiIIuM+CcBamIgiI5MArIWJKDIyCcBamIgi43nSVMp/yTQGxRXU5DJhGMN6cZ80k88xw6z86wvllwnDGBaZNJUXf6tiqFJ1cMmkhpcJwxgWmTQVMmmsshX/Kvf9Qn1zBbW4TBjGsKoziedJkZFJYxX/epFHtnx9+IPJMIYV+j7JaeW00xW26sCtzZFJYxX/epFHtnx9+IPJMIYVPZOcL89JK6mqcPpMSo+v/LKwBnmqFDZ3bs07mnuy+NeLPLLl68MfTIYxLDLpZGfu1iSTvn5+3Kr+m61sfVlSsjOkcM3CauUmanNWzYctVo1Vq+JfL/LIlq8PfzAZxrBCP0+yMkm2Kzuj9m2zM8mpU7Zutet0QLYrN1ErPHE45VTrv1aXXMwkv4bmmXRYc0mL5WPVqqTXy5dW5IX6ZjK9jEyKLPp9ktXKvsJmT/fpErVOq1GnTqvm7N2SLsnEcrpddTizydT/15p55eGWRz+bYQ9r2JfI1+mXVv/9Dmc1ZxVazVltqf82L9n14pzwZFJDZFJk0TPJWp42bU33avfkyod1piv4VX1VZtLhknOH89z8aM341uTubGLVoFbivHWYCuqZ6XTb6XyXIq8X9aTdyKSmyKTIxsuk2sn9cPPCGvzYmDiT5Gv1lHBqkJtYFartOpmktqW+2P+1Ot+lqNeLeujJpIbIpMhGep4kF56Y3E9kkpU35zJpH7GBMumtzfXlNchN1LeeySSnkueLf72oF2rh+vAHk2EMa7z7pM39iQa55HDbwhqsMEtXy9bJWslWq62w/HCemx+/jhJFTuvWJoevZeXqW19unKhNfImztLDzXYp/vagXauH68AeTYQwrdCadUDuJj96uesxOT5HqsX7/nNzT1Qo3l5tY51LWnBNgTk+cwHM636X414s8suXrwx9MhjGsGTLJ6snderV7eDj7zK/xSpDgcYp/vcgjW74+/MFkGMMK/TwJtcikT4lzJ+QX/3qRR7Z8ffiDyTCGNcN9ErJj1md+pdSXrebPMJJJDS8ThjEsMmkqZNJYhb/p1+syYRjDIpOm8vrz6t4H3Ior6Domosh4njSVx7/Rp3Qo3U+z0TERRcZ9EoC1MBFFRiYBWAsTUWRkEoC1MBFFxvMkAGthIoqM+yQAa2EiioxMArAWJqLIyCQAa2EiioznSQDWwkQU2dP3SQDQHZkU1uvJTCr/n+oUCoVya+k++UL1aCYBAOCozqQrz5MAAHBwnwQAiIJMAgBEQSYBAKLgeRIAIArukwAAUTyUSf/nf/4D8HW/GAB0RyYhiu4XA4DuHnqe1H2+Q3zdLwYA3XGfhCi6XwwAuiOTEEX3iwFAd2c+u5Ml3awkk7rvNiLgrACQ6fM8qftvqkcEnBXoiP+1EtOrKpOskm5Wkknlv0+eMnHhrKD0KmRSWH0yqftuIwLOCvRCJoVVl0n/9+9CJuE6zgr0QiaFRSahG84K9EImhUUmoRvOCvRCJoVFJqEbzgr0QiaFRSahG84K9EImhVWXSf/7f/2PxzKJ/2Ewvdr/n8ThRiucTmGFzqTv398Oqy2MIjsrONx4DJkUVvRMcv7Xm9XWR9arz5fZwnLWzpY0fZrchapuNO9AczKTThxuOSxWt+Xy7iOMXsiksIbMpK+vr+czyarZb/cKdRfuaKiXVpl0+hBMP8KwkElhjZdJnxb9TJIJ1DCT/HrIpHJkEnohk8IaIJO+tL+RcTGTsp47Lw6/lFU5rezdsNZJl5T0obCqwyXql+mgFXayyq2ZVHL0C49yyTG6Php4EpkUVtyfBU8z6evnLyMvn6Ss6TVbIVtts6cnZzWrqsJWrL6lX6pTYXlVh12yhstaTXaySvPnSSU7WzvC8rhXHTXERCaFNUwmZYF0RyZZ6zhfynEofOtwncM+qDsodypbWR41p5W7p+Au90m1I5yNm1WzdTkgJjIprAEySd4hlX/jnM28JbOVOqFbX1oTYuFbzjqHfXCqcjJJHWp/7xbPpNqQxhDIpLDGyKT3z6dKziTlz1DOrOTPs9a7zvRU8lbVdH8lkw6XOF+Onkn7KfpMJpFPQyCTwhomkwonqZJM2pJ7KXVDtRJ1Z2VVWT3qW846TlslM6ZV1eES9UtnwnUGpNzdP3e3d886+iUjrK7vLDk9GngSmRRWXSaldy3Whd0wkw7X4azqrmEmHa4f8HATQoMik8KqzqSvnz8Cd18mOd8yZ98+42FNbpI2cVaMcrhb7T46IpPCinufhOlxVqAXMiksMgndcFagFzIpLDIJ3XBWoBcyKay4z5MwPc4K9EImhcV9ErrhrEAvZFJYZBK64axAL2RSWGQSuuGsQC9kUlh9nicBUveLAesgk8Lqc58ESN0vBqyDTAqLTEIU3S8GrINMCotMQhTdLwasg0wKi+dJiKL7xYB1kElhPXSftNdYfh6c+1sVuy/792M6b5WsXLX5Yw19lf3ZhVZ7VL7JYwMIlCOTwpozk77cv/5JJl3fIzIJQyOTwlook7IOy3X21+lOyR1Up9RsKNQX6gppT9QOW5v7vXI6ULLE75g6CId7ajVXeD4ADZFJYT30PGmv8YFMktO9ujD9Vy5XV5BVWa07lZQsKex8trJ6UM51QKZR1mJtQ4fjDDyJTAprwvuki5lkLXSWbMZNmNPKHZnkbFueQOpeOPUXVnI4zsCTyKSw5swk2beqTNrcedNfMnQmHe7X4SCULHeqBZ5BJoU1WyaVz4kyPA7jxG8ie12SiGq7alXO7qi9uphJfpBcGWd1BApPCaAVMims2Z4n+TN72mE/jfzpWO67ukTdKluy2bOzXNmZx/1MsnpoLVE7UDvOhR0oPB+AhsiksELfJx2uc+Wsuns2ZLYFwiKTwoqbSc4dUna3dM59mcG3/0BwZFJYcTMJAG7CXBRW3OdJAHAT5qKwuE8CsBzmorDIJADLYS4Ki0wCsBzmorB4ngRgOcxFYXGfBGA5zEVhkUkAlsNcFNaEmfT689plyws3P1xyd4sX1z+xC/5q6XK/qs+7Jc3V7nXb1rE4MimsCZ8nfVr5lGx6KmlddvKw281bPFTSnxNNWKuly/2q9ncPmzt3MpS0znSDQ5wkYc15n5S2cuIu5FwmNWzx+ghkdzYNMynbQfm6cF9O7/Vh60w3OMRJEtYSmfT5cp+/1Ck7ezdbstcgP6CrbbG8fvki/XL/V+1Pdmcjv1RHwOmJuoPWa6eHJW0d7v5h659k8o+yNXpYAZkU1lqZtH+2ln3Iln7s9hIfxGUbyg/oqlq06rd6YtW/z6dWf7JgSNMiayVd4vdE7m9JKjhtqf3J9vpE63676jpYCpkUVnUmPfY8Kf2G2qLW5ifElnzfnX2fvs+S2TSXzrBq01UtWvU7PbEy6TPJ+is4VVn764/Jvqb6b5ZJWQ9LWncCtap1mY5yj9TRwwo46GFVZ9KnPJNJ37+/HVZbhwmxic+Fsu/crVny/bOcbtGZhdWeOJFz2IHtZxAWpoIzJtbIlOdNyRKr5vLW5ZppcUYPK+CghxU9k/x1DjNJ/eY9fat2lky3bduic7+S7WlVJlkvDvfXWpK2ku5p2skrmeTXXN6604q6TuFpiTlw0MOaM5N2mzZVZW+9xKc62ebZhmpIlLdYUn8WIc5dgjqw6ZdqFBYK2BQAAAs6SURBVPkjoI6Jmgp+B5yUVduyelvynYe1+1YrZNLiOOhhVWfSk8+TzmXS9vNv1KrrZ29l68vNsw1lu+Ut7jHj1y9nZ1lttgv+yKj76/Rfjok//moH1BWctkpqLm/dP3YlTWBWZFJYE94nBVc4COoNGYAmyKSwyKQOCrst77oANEEmhUUmAVgOmRTWhM+TXqd+EeqJlWsH+sr65ZtnP0NR1aXCVqzVZJ/LO/PMcbnv+GIsZFJYE94nZTOg06g6Kd90ptbW7PwsWcmGn+JPwbLO8mdd1sjLPhd2pu3o3V0PRseZENa0mbS/5WfSuUn53EA/mUnpl86aWXjfkUlNxpZMQlucCWGFzqTDdZyZcd88y6d0IpafKak9lFtlndz/lVN81g1/nXSJnNCtbvi7cLj72bvWymrf1H087IlTs7Ozhdue6zlWQyaFVZ1Jjz1PepcVq5V09tlf7NXuKZJVYvVQbpW1tVeeplS2Vck66RLZMbUb5Umg7kgWq87Kat+skdl+JkG2707Nzs4WbnvYc7kOVkMmhVWdSZ/yQCZd2aV0YlXn7iy3/B5m32Vb9aStZPVY6xzWrHbMCl1/Q6sG+e/hWMm7DXWv02hJ971wPNWu+i2W1/YSd05YCsc9rJkzafv5edS5TFK/yy6cQ51epSm1ly6ZlO5jVSb5I2Md7pK99uPT2vZwoJyRv/ucRDRkUlhk0nEmOVN5YUodtm6t43Rj70A25rLakkyyXli9PVxiHe4TI6NmnrrtuZ7ffUIiIDIprOpMeux50pVdcubobB7PpqSXeASSLczCwJr1ZFsl66htyT5sP2NGhqhcU939tAk1ig77li0pySS/5r1jVlcPt63tuX/GYlZkUljVmRT/Pkn2If1SflwjV06LXJgu2TdXK5SbHK6jtmUtt8bTqsHvUuFY+SPjjLzTjWzJnrVqV/1tT/T8vvMQYZFJYc2ZSdOb+3t8zhPcjXMsLDJpVHN/jz/xriEC5qKwJnyeBAA+5qKwuE8CsBzmorDIJADLYS4Kqy6TrJJuRiYBCI65KCwyCcBymIvC4rM7AMthLgqL+yQAy2EuCov7JADLYS4Ki/+fBGA5zEVhcZ8EYDnMRWGRSQCWw1wUFpkEYDnMRWHxPAnAcpiLwuI+CWekfyUPOKHvVNC9A7C8yCSc8Dk5gHO23n+OhLkoLDIJZ3xOjjeF8n6/Ky9qMgmO6kzieRI2Monys2w//7q8U/YZ500mQRP6PslppSFZ831tTYNMoqRlK84YMgm+6JnkfNkKmXQCmURJy0YmoREy6T/ZLtx6TzYNMomSlo1MQiOhnydZmZS1K3uSZYy6TrqCk0lqzYdtdT+udyOTKGnZyCQ0Ev0+qTBvTixRV8hWtrKtsOaJkUmUtGzJhf+llezM2cgkGKJnkr/wgUzKdrOq5omRSZS0bD8vfGd+IJPgI5OUuyL5oqr1FZBJlLRs4sJXJ4eNTMKRkZ4nyYWHCeTc38gv/Uwqb2sFZBIlLZt24auXA5kE33j3SVvBzzhsIo2s3qqtyHqclFLb6n5c70YmUdKy8TMOaCR0JhUqyYAVcuJJZBIlLRuZhEbIJJxBJlHSspFJaCT08ySERSZR0rKRSWhkhvskPI9MoqRlI5PQCJmEM8gkSlq2mj/zSCbBQSbhDDKJkhb+ph9a4XkSznj9eXXvA4ZGJkHFfRLOePwbccqEpeMJzFwUFpkEYDnMRWGRSQCWw1wUFpkEYDnMRWGRSQCWw1wUFpkEYDnMRWHVZdJf//zrr3/+RSYBGBpzUVjV90mfWCKTAIyLuSgsMgnAcpiLwiKTACyHuSgsnicBWA5zUVjcJ+GM8l8CDVg6zgZ9W4fjRSbhhM/JAZy2df01rMxFYZFJOOPF36qg/CxV5w+ZBEtdJvE8CR97Jv36x79D6Tkrr1224t8Wv086bzIJQvV90qeQSYsjkyhZ2Yb68+fMRWGRSThDZtJb5FM6YamBURIthwuzptvOs5TyspFJaCF0JjmtVGlVj6ywZM3ySpr07RmHmaR++S67r1KrtRZ+CpnUvWxkElqInklNdrLtXK+miNVEyfLDSp7cu0JZJr1F5Ly1+FEXFq7mbPsmkwKUjUxCC9WZtP9LJpU0UbWcTCKTxi1bcu1/aSU7eTYyCZrB7pPS5tTPvmR/1HrkyvvrdHltbZu46bF662TS4U5ZPX9Smknvo4/a1MA4jCW5mrXtm0wKULJr35kiyCQ4omeSNZVnc7S6pKQeubnfVlahbFHNJGtNNWz8nfKXPOZ0JpXcJ9XeM73JpABFXvvq/LCRSXBFzyRrieyA0yWnnu1UJqn9UV8c9s1qyNpQXdLrvHn/nUlpIZPWLOq1r56cZBIcgz1PcnKiJDnUJc9kUsluOr0q3JfHpL/HQQ2MtxYbcuXDHHprIadWTib1LRs/44AWBr5PyhbKJSX1yM0PM0ltKFuoJtNhb0tWK8mtBxxm0i/t6VE2i/mxJNexNnyTSQHKRiahhVEzabvhZxwOX/gNOdFS2NsmGz6D3+NAyYp/7cuTp3z9m07gjq3DETqTBtXlxuVhrTJJTm1k0qBlI5PQQujnScNR79KmxO8Fp2RlI5PQAvdJOINMomRlq/lLj2QSLGQSziCTKFnhb/qhCTIJZ7z+vLr3AaMjkyDxPAlnPP5dOGXO0usEZi4Kqy6T9vfIJADjYi4Ki8/uACyHuSgs7pMALIe5KKy6TNp/lJNMAjAu5qKw6jJp/zlOMgnAuJiLwuJ5EoDlMBeFRSYBWA5zUVhkEoDlMBeFRSYBWA5zUVhkEoDlMBeFxf9PArAc5qKw+P9JAJbDXBRWXSZZJd2MTAIQHHNRWHx2B2A5zEVhkUkAlsNcFBaZBGA5zEVh8TMOAJbDXBQWP+MAYDnMRWHx2R2A5TAXhUUmAVgOc1FYZBKA5TAXhUUmAVgOc1FYZBKA5TAXhUUmAVgOc1FYZBKA5TAXhUUmAVgOc1FYZBKA5TAXhUUmAVgOc1FY/G4hAMthLgqL38EKYDnMRWHVZdL37+8PMgnAuJiLwqrLpPffhUwCMC7morDIJADLYS4Ki0wCsBzmorDIJADLYS4Ki0wCsBzmorDIJADLYS4Ki0wCsBzmorCeziQAiIBMiun1ZCYBAOAgkwAAUdySSd3vygEAg2qcSfvvxAMA4ISWmQQAQHNkEgAgCjIJABAFmQQAiIJMAgBEQSYBAKIgkwAM4Gv2Inf5PXXhZ8EBDCydmiYrnylY7vJ73l+X0/7/zALAkz5TU/duNLdPwfKtKfc33Wt/QMgkAHGRSTMhkwCMjUyaCZkEYGxk0kzIJABjuzuT1LnOet3Q3Zl03xx+pUIyCcDYbs2kbH7bv5Qvmrs1k6z9umPQTuy1PyBkEoC4OmbSrbPfk5l066Cd2Gt/QMgkAHH1yqS7p74umZTN6nv0Zp9V+kvIJADrIpOu75e1gppPch1nybm99geETAIQV69Mku+21fc+qTxvZByQSQDW1TGT5AoNPZ9J5+6BSpbU7rU/IGQSgLj6ZpJcp5Xnf+6uNpPKc6t2r/0BIZMAxHVrJm0F/z9JftlEl/+flC1Ud9nZ6vpokEkAxnZ3JvXC73GwBoRMAhAXmTQTMgnA2MikmZBJAMZGJs2ETAIwNjJpJmQSgLF9pqbXn9d8yCT5FpkEILSvr6/v39+zsjKpe17emsTqgSaTAAzga/Yid7l7Ut5NPdBkEgAgCjIJABAFmQQAiIJMAgBEQSYBAKIgkwAAUZBJAIAoyCQAQBQVmdT9//0CAKZXmkkUCoVCoTxdyCQKhUKhRClkEoVCoVCiFDKJQqFQKFEKmUShUCiUKOVNoVAoFEqM8v8ArPp9BQ/TVxYAAAAASUVORK5CYII=" width="640" /><br />
<br />
<span style="color: #444444;">Now you will see that associated peoplecode will trigger when you select a radio button. </span><br />
<span style="color: #444444;"><br /></span>
<span style="color: #444444;">HAPPY LEARNING :)</span><br />
<br />
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-58509525449682001562016-10-09T07:27:00.000-07:002016-12-08T04:36:06.021-08:00What is an Applcation Designer?<div dir="ltr" style="text-align: left;" trbidi="on">
Lets understand what is an Application Designer in PeopleSoft.<br />
<br />
<div style="background-color: white; color: #333333; font-size: 16px; margin-bottom: 20px; margin-top: 5px; padding: 0px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">PeopleSoft Application Designer or App Designer – as it is commonly called, as the name suggests, is used to create and modify PeopleSoft applications. With App. Designer, you can create and modify most of the objects in PeopleSoft.</span></div>
<div style="background-color: white; color: #333333; font-size: 16px; margin-bottom: 20px; margin-top: 5px; padding: 0px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">This is the Integrated Development Environment (IDE) that you can use to work with numerous PeopleSoft definitions like Fields, Records, Pages, Components, Menus, PeopleCode and more.Like any other standard IDE, Application Designer supports graphical user interface and drag and drop facility.</span></div>
<div style="background-color: white; color: #333333; font-size: 16px; margin-bottom: 20px; margin-top: 5px; padding: 0px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM4MOhanrVynGGIoaU9s3iUujvrKnOsYTc0_6vKXoPnNJZewH8osooxCnlwFlOML01q5DLBMGCph2oMIFDKiHool_p4zAA6gaavOMc2k78iEKA3DuhdugJzDE7IrUk6wXmwH_BYD31k44/s1600/application-designer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM4MOhanrVynGGIoaU9s3iUujvrKnOsYTc0_6vKXoPnNJZewH8osooxCnlwFlOML01q5DLBMGCph2oMIFDKiHool_p4zAA6gaavOMc2k78iEKA3DuhdugJzDE7IrUk6wXmwH_BYD31k44/s640/application-designer.png" width="569" /></a></div>
<div style="background-color: white; color: #333333; font-size: 16px; margin-bottom: 20px; margin-top: 5px; padding: 0px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br /><span style="color: blue;"><b>HAPPY LEARNING :) </b></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-52604058624751815372016-10-09T07:11:00.002-07:002016-12-08T04:36:15.675-08:00PeopleTools<div dir="ltr" style="text-align: left;" trbidi="on">
<h4 style="text-align: left;">
</h4>
<h4 style="text-align: left;">
</h4>
<h4 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Here are some PeopleTools we can learn.</span></h4>
<div style="text-align: justify;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">1. Application Designer</span></b></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> We use it for creating Fields, Records, Pages, Component, Menu.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">2. Application Engine </span></b></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> We use it to create background processes.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYyCgpcp_7zFl52ls8kg73w6ahqndHYyLW-0igdUt6cp3WBWgvls7Gr5p-bIT7gOWUY7LQWjXCmaXO_BeWNhL2cw8tEMq2KZ3skz5KkPw5MdiAZL-deFKHvufMwn6py7tCCM61axk_uwU/s1600/peopletools.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="80" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYyCgpcp_7zFl52ls8kg73w6ahqndHYyLW-0igdUt6cp3WBWgvls7Gr5p-bIT7gOWUY7LQWjXCmaXO_BeWNhL2cw8tEMq2KZ3skz5KkPw5MdiAZL-deFKHvufMwn6py7tCCM61axk_uwU/s200/peopletools.png" width="200" /></span></a><b><span style="font-family: "arial" , "helvetica" , sans-serif;">3. BI Publisher </span></b></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> It is a reporting tool, We use it for reporting.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">4. nVision </span></b></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> It is a reporting tool.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">5. Component Interface </span></b></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> It is used to expose a peoplesoft Component to third party applications like excel etc.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">There are some more tools in peoplesoft but we will discuss them later.</span><br />
<br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: blue;"><b>HAPPY LEARNING :) </b></span></span></div>
<div style="text-align: justify;">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com0tag:blogger.com,1999:blog-8619900120224268863.post-29984655199821355952016-10-06T11:31:00.000-07:002016-12-08T04:36:26.900-08:00History of PeopleSoft ? What is PeopleSoft ? <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background: #F8F9F9;">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">Dave Duffield and Ken Morris founded PeopleSoft in 1987, when
they engineered the company’s first human resources application. Built on a
client-server architecture, their solution offered flexibility and ease-of-use
to a class of users previously barred from simplified access to the information
and capabilities centralized in mainframes.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">By
putting ease of functionality directly in the hands of users, PeopleSoft
quickly assumed industry leadership status in human resources solutions.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">This
would be the first of many innovations that would transform the way enterprises
do business on a global scale. In 2000, PeopleSoft introduced the Pure Internet
Architecture®. Even today, it is the only pure-internet architecture with no
code on the client.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">It has
enabled what PeopleSoft calls the Real-Time Enterprise. It allows organizations
to connect people directly to business processes, eliminating intermediaries,
inside and outside the enterprise. It creates unprecedented efficiency and
lowers costs.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">It
provides businesses with an unmatched competitive advantage. The Real-Time
Enterprise sets the standard for business performance in the 21st century, and
PeopleSoft is at the forefront of enabling businesses to make this model a
reality.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">PeopleSoft was the world’s second largest provider of enterprise
application software. PeopleSoft’s business solutions are built with the
flexibility to fit your business today and the adaptability to change with your
business over time.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">A broad
portfolio of applications with industry-specific functionality gives you
unprecedented flexibility to optimize business operations and compete more
effectively.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">PeopleSoft is a worldwide leader in providing complete solutions
for more than 24 industriesfrom industrial manufacturing and consumer goods to
financial services, healthcare, and public sector organizations.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">More than
12,200 organizations worldwidefrom mid-sized manufacturing companies to the
largest service enterprises in both the private and public sectorsare using
PeopleSoft solutions to build stronger and more profitable businesses.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">PeopleSoft applications are built on innovative and open
technology, enabling easy integration with third-party applications and legacy
systems. And PeopleSoft’s pioneering Total Ownership Experience initiative
ensures the best overall user experience at the lowest cost of ownership.<o:p></o:p></span></div>
<div style="background: rgb(248, 249, 249);">
<span style="color: #4e4e4e; font-family: "arial" , sans-serif; font-size: 10.5pt;">Founded in 1987 and headquartered in Pleasanton, California,
PeopleSoft has 12,000 employees and annual revenues of more than $2.3 billion.<o:p></o:p></span></div>
<br />
<span style="color: blue;"><b>HAPPY LEARNING :) </b></span><br />
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/12654415615066686296noreply@blogger.com2