krishnamraju

FIXED format Be careful when you change the length or starting position of any file fields, or if you insert a new file field between two existing ones. It’s possible to overlay fields. Results are unpredictable. When you insert a record into a file layout, fields of type Long are converted to type Character, with a length of 0. You must set a field length greater than 0 before you can save the file layout. CSV format • Both the qualifier and the delimiter accept a blank as a valid value.  • If a field is NULL, you don't have to use qualifiers. In the following example, Field2 is NULL.  Field1,,Field3,Field4. .     XML Format     • Your XML input file must contain at least the fields that are specified in the file layout definition you’re using. If the file is missing any fields, the input rowset won’t contain any data.  • If your XML input file contains extra fields that aren’t specified in the file layout definition, the ReadRowset method will ignore the extra fi

There was several solutions to find the navigation path for component and page. There were several SQL statements for different databases. Finally Oracle as developed page this purpose. In the latest Ptools 8.50 and Application 9.1 application search is possible from two navigations. 1) Main Menu > Enterprise Components > Find Object Navigation. 2) Setup HRMS > System Administration > Utilites > Portal Navigation Path. Search is possible with name of Component,Page,Secondary Page and Content Reference. Search works fine with hidden components as well.

Base Benefit Tables PS_BEN_PROG_PARTIC - EE Benefit program participation. PS_BENEFIT_PARTIC - Ben Plan type enrollment control PS_BENEF_COMMENT - Benefit Comments Dependent Details table PS_DEPENDENT_BENEF - View Dependents/Beneficiaries PS_DEP_BEN - EE Dependents/Beneficiaries PS_DEP_BEN_EFF - EE Dependents Details EFFDT PS_DEP_BENEF_VW - EE Dependent Only View PS_DEP_BEN_ADDR - EE Dependent Address details PS_BEN_NAME - EE Dependent Name PS_DEP_BENEF_NID - Dependent / Benef National ID s PS_DEPENDENT_PHONE - Dependent/Benef Phone Numbers Health Plan Tables – Plan types – 1% PS_HEALTH_PLAN_TBL - Health Plan Attributes Table PS_HEALTH_PLAN_VW - Health Plans types View with its long descr plan type LIKE ‘1%’ PS_HEALTH_PLAN_LNG - Health Plans types view with its long descr lng plan type like ‘1%’ PS_HEALTH_BENEFIT - Health Benefits EE Elections PS_HEALTH_DEPENDNT - Health Benefits EE Dependent Elections PS_HEALTH_VW - EE Current Health Elections Savings Plan Tables – Plan types -

Question # 1: What types of delegations are supported in 9.0? Answer: The following delegations are supported:. • Upward - delegating to your manager • Downward - delegating to your subordinate • Lateral - delegating to a peer Please note that cascading delegation is NOT supported (see question #2 for more information). Question # 2: What is a cascading delegation? Answer: Cascading delegation is the ability to delegate your delegated authority. For example:. If Antonio delegates the ability to approve absence requests to Owen and Owen accepts the delegation, Owen cannot then re-delegate that same absence request approval authority to Will, Laura, or anyone else in the organization. Once a proxy has accepted a delegation request, he/she cannot delegate that authority to someone else and only the delegator (or the Delegation Administrator on behalf of the delegator) can revoke the request. Question # 3: Does the application server need to be bounced when ch

Setup and configure workflow 1)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Register Transaction  ----- Create Approval Process ID (Cross refernce table , Header table , App class ,Approval compoent is defined). 2)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Setup Process Definitions  ----Create Definiation ID for the Process ID, Definaiton Criteria ,Stages ,paths ,steps 3)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Configure Transaction  ----- Add Events and notifications to transaction. 4)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Workflow Transaction  ----- Register workflow transactions. 5)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Maintain User Lists  ------ Define the user list or hierarchy used for routing transactions for approval. 6)  Main Menu > Set Up HRMS > Common Definitions > Approvals > Generic Template

JOB_DATA (Job Data) - It is one of most important component in the HCM which maintains the employees job history details. It is also one of the complex components which have a lot of business logic involved in it. There are 5 other components which are very similar to the JOB_DATA component. JOB_DATA_EMP   - Add employee Instance - Employee Hire component. JOB_DATA_POI     - Add POI Instance - Hire Person of Interest component. JOB_DATA_CWR  - Add CWR -  Hire Contingent Worker. JOB_DATA_CURRENT - Current Job. JOB_DATA_CONCUR  - Add concurrent Job. In an implementation we customize delivered objects in PeopleSoft. Customizing the Job data component can be very painful as it creates a lot of maintainace  issues and lead to additional customizations. A lot of points needs to taken to consideration while any customizations are made to Job data component. Modify the Job record is a very bad customization, avoid modify the delivered records. 1) Any new custom record added to JOB_DATA compon

Script to update the Tablespace for all the records in the Project. when we import Project in the client instance, we can use this SQL to change the tablespace for all the records at time, rather changing it one by one. Update PSRECTBLSPC SET DDLSPACENAME = {NEW TABLESPACE} WHERE DDLSPACENAME = {OLD TABLESPACE}; and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B                Where A.PROJECTNAME = {PROJECTNAME} and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0)

 CREATE UNIQUE INDEX PS_LAC_CLS_TBL ON PS_LAC_CLS_TBL (CRSE_ID, CRSE_OFFER_NBR, STRM, SESSION_CODE, CLASS_SECTION)

EXEC DBMS_STATS.gather_table_stats('SYSADM', ' PS_LAC_CLS_TBL ', estimate_percent => 5, cascade => TRUE); Here PS_LAC_CLS_TBL is the Peoplesoft Table.

%SelectInit (STRM)  SELECT A.STRM   FROM %Table(LAC_COTER_RUN) A  WHERE A.OPRID = %OperatorId    AND A.RUN_CNTL_ID = %RunControl