People. Soft: FAQ1. People. Soft FAQ1. Can we insert sub record into another subrecord? Ans: Yes,we can insert a Sub- record into another Sub- record. When a Sub- record definition is opened goto Insert and Sub- record. Difference between Save Prechange & Save Postchange? Ans: In Save Prechange we can get the data from Component Buffer for that particular Component where as in Save. Post change Component Buffer is cleared we have to get data from Database and this is used to update values outside the database. What is naming convention of SQR program? Ans: The program must End with . Ans: Yes we can run using properties of Push Button. That are Specifying Destination = Process Process Type = SQR Report and Name = SQR report name. Order of Execution of Deferred processing? Ans: This is similar to Interactive Processing where as in this Field Change, Field Edit Peoplecode events & System edits will be differed until we press the Save Button. What are Data Buffer Classes in Peoplesoft? Ans: There are totally 4 Data Buffer Classes in Peoplesoft. They are 1. Row Class 3. Field Class 2. Rowset Class 4. Record Class. 7. Define Signon Process? They are 1. Builtin. Functions 2. Internal Peoplecode Functions 3. External Peoplecode Functions & 4. External Non- Peoplecode functions 9. Does Save Edit & Save Prechange Are in Component Level or Comp? Ans: These are available in Component Level. Ans: These SQC’s are useful for Heading & Footing Sections of an Report. One of the important Footing SQC is . Some of Heading SQC’s are some “PATxx. HDG. SQC’. 1. 1. What is Application Messaging? Ans: This is mainly used to publish or subscribe Messages to other Systems . This is kind of communication as per my knowledge. Where and when do we use SQR? Ans: 1. Where the Programing logic is more. If We need to Generate different kinds of reports. Background SQL processing. Ans: There are mailnly 3 steps for running SQR in People. Soft Environment. Making our SQR program API aware. Creating Run Control Table and Run Control Page (Using PRCSRUNCNTL. Scheduling our program in Process Scheduler. How do you perform People Code Debugging? Ans: 1. First we have to set the Debugger mode by selecting “Enter Debugger Mode” in “Debugg” menu in the Application. Designer. 2. Next we have find which variables we need to Debugg,this we can do by selecting local,component or Global variables from the “Debugg ” menu. Next we have to set the Break. Points using “Toggle Break at Cursor” or “Break Point at Start” from the menu items of the “Debug” menu. How do you conect to Client Database? Ans: Using VPN (Virtual Protocol Network) Protocol. In our company we use . What is PS Enterprize Portal? What is Effective Date? Ans: This is an important Concept for an ERP using this we can enter more than one values to row for the same key fields depending on date. Here we can maintain History, Current & future rows. While PeopleSoft Application Engine does not. A state record is a PeopleSoft. Multiple programs can use the same state record, and each program. APPLICATION ENGINE PROGRAM ELEMENTS. State Records It is a PeopleSoft Record that must be created and maintained by the. Reasons why PeopleSoft does not recomd. We can also maintain more number of rows for same effective date using Effective Sequence. This concept is minly used in most of the Control Tables. Select A. ENPLID FROM PS. EMPLID='1. 23. 45'AND A. EFFDT = (Select MAX(B. EFFDT) From PS. These fields play a vital role in Peoplesioft. How to build customer indexes? Ans; By using Key fields & Alternate search key we can create system indexes. Where as we can create User defined indexes using App. Path is: In menus Tools - > Data Administration - > create indexes. What are types of instances in which you are working? Understanding PeopleSoft. A state record is a PeopleSoft record that must be created and. A strong benefits program will help you attract. PeopleSoft Benefits Solutions Data Sheet. Management Linux Networking Oracle PeopleSoft Project and. App engine state records. Ans: In our company we have Development & Tesing Instances of databases. I worked on Development Instance. How do you interact with client and how do you deliver output to client? Ans: 2. 4. Current Version working? Ans; I am presently working on Tools 8. HRMS Application 8. Purpose of Upgrade Tab? Ans: This is mainly used for version upgradation. How do you send project to client and How do you test the project? How to Debug AE program and Ways of running AE Program? Application Engine Trace file- You can track the step execution of your application execution. Application Engine Interactive Debugger – First click on the trace tab and turn off the statement timings. Select Profile - > Edit Profile- > Process Scheduler Tab - > Application section Select Debug check box. Query Views are designed using Query Manager Tool where as we write SQL in Dynamic Views. Query View is Built and Exists in the Database where as Dynamic View can’t be build so it doesnot exists in Database. How work will be assigned in Production Envoronment? Ans: Actually I don’t know because I am in Development Environment. How do you assign Search Record to Component? Ans: By going to the component properties , Use Tab and Specifying the search record in that particular area ie; . We have some specific commands in Flat files handking in SQR such as OPEN, CLOSE, FOR WRITING, FOR READNG & FOR APPENDING, WRITE and Finally READ commands. Interaction with client? What is your Team size? Say about your team? What is your Role in the Current Project? How will be the interaction with the Team Leader? How do you open a file? Ans: In SQR the Syntax is OPEN . In SETUP section By Defining printers what we need . It Automatically Executes. Engine? Ans: There are Totally 9 Actions. They are. 1. Do When 4. Do Select 7. SQL2. Do While 5. People Code 8. Log Messages. 3. Do Untill 6. Call Section 9. XLAT4. Difference between Do Select & Do When? Ans: Do Select is like FOR Loop in C. How many rows it retrives that many times it performs the Do When & SQl actions below it. Where as Do When is like a condition operator such as IF statement in C. Pupose of App. Engine? Ans: 1. Backgroung SQL processing. To pass data between Modules. To pass data between Databases. To populate Reporting tables using data in Transaction Tables. For integration purpose. Validation of data. Data Manipulations. For Version Up gradation. Archive Data . Etc. It contains keys, names, return vlaue, 5. Commands in the File- Handling? Ans: 1. Open for- Reading. For- Writing. For- Appeding. Close 3. Read. 4. Write. 55. Diff between ASK & INPUT Commands? Ans: ”ASK”1. This is used in the Setup section i. Compile Time Variable. This prompts for the values during the compilation time. This does not have the datatype and length.“INPUT”1. This can be used in other than the Setup section i. Run t. Time Variable. This prompts for the values during the Execution Time. Here,we can specify the datatype and the length. Debugging in SQR? Ans: Using Debugging commands we can do debugging in SQR. They are 1. Display(to display only one variable)` 2. Show(to display more than one variable)3.#IF Debug#END- IF5. Effdt and Eff. Seq Quries? Ans: Select * from Table. A where A. Eff. Dt= (Select Max (B. Eff. Dt) from Table. B where A. keys B. AND A. Eff. Dt< = as of Date)Select * from Table. A where A. Eff. Dt= (Select Max (B. Eff. Dt from Table. B where A. keys B. AND A. Eff. Dt< = as of Date AND B. Eff. Seq=(Select Max(C. Eff. Seq from Table. C where B. keys=C. AND B. Eff. Dt=C. Eff. Dt AND B. Eff. Seq=C. Eff. Seq)5. What is SQC , List out some of them? Ans: SQC is used as Functional Library mainly used to re- use code and get some predefined functionalities used for our SQR programs. Some of the Important SQC are STDAPI. SQC,SETENV. SQC,RESET. SQC,SETUPxx. SQC,NUMBER. SQC,STRING. SQC,DATETIME. SQC etc. 5. 9. What is Process. Scheduler? Ans: This is a Peopletool used to Schedule and monitor the Execution of any Process or Report or Program in Peoplesoft Environment. What is Scroll Area ? How many can we keep on a Page? Ans: Scroll Area is a Page Control which contains Child Records’- Fields which is used to maintain the Parent- Child Relationship between Tables. We can place any number of scroll areas on a page. Duration of the Project? What is Data. Mover? Ans: Data. Mover is a Peopletool which is used to move Data between different Data. Bases. 6. 5. Diff between Migration , Import and Export? What are Upgrade Instances of Databases? To Whom you will Report ? Who Will give Specification to you? Why you are Leaving Current Organization? Where is the Location of the Current Organization? Can we send SQR Output to Ms- Word or Crystal Reports? Ans: Yes. 7. 1. How do we refer Component Buffer in the Object- Based or Procedural- Based People. Code? Ans: In Procedural Based Peoplecode by using scrollpath we can refer. In Object- Oriented Peoplecode by Instantiating Objects to Record , Row , Row Set ,Field we can refer the Component Buffer. Limitaion of SQL Exec function in Peoplecode? Ans: 1. Used in only Save. Prechange , Work. Flow , Save. Postchange, and for DML commands and for Select statements used other Event types. Results only one Single row of data. What is the State. Record? Ans: State Record is used to pass values between Sections. What are the Actions available in the AE Program? How will you read Data from the CSV file or Excel file and Upload it into the Database using AE Progrm? Ans: Using File Layout Integration Tool. Why are SQC files used in SQR? Which SQC is used to read Data from the Translate table? Ans: Read. Xlat. SQC7. How will get the System. Date in Oracle? Ans: 8. Effective Date Event in SQR? What is a Sub- Query? Why it is used? 8. Why is Load- Lookup used in SQR? Ans: Used to increase the performance mainly in the case of Master Detail Reports. Why are Field Edit and Field Change Events Used? Ans: 8. 4. Why is Save Edit Event Used? Why is SQLExec function is used and how many rows you can retrive using it? Ans: This is mainly used to Directly access the Database by- passing the Component. Buffer. 8. 6. What is a Sub- Page? Why it is used? Ans: Sub- Page is a Page control which is mainly used to insert Sub- Records. Why is Derived Work record used? Ans: Derived. Work record is mainly used for the Online page calculations and also used as Functional Libraries in People. Code. 9. 1. How will you delete the button . Diff between the User- Profiles,Roles and the Permission Lists? Ans: 9. 4. What is the Diff between the Prompt Table and the Translate Table?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |