Günce Kaya

Hello, This error indicate that user's permission have some absences like PTPT1000 or HCCPCSSA1010 or HCDPALL.. add one of that permissions or give a role that has permission upper ones.  If you want you can add on permission list as bellow, Loves,

Hello, I have created a package and procedure that include a function which defined in package body. This function has three parameter in package. When I change number of parameter of function in package body, I've got PLS-00323 error. Instance of package; CREATE OR REPLACE package SYSPROD.test_procedure is     function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2) return varchar2;     end test_procedure; / Instance of package body; CREATE OR REPLACE package body SYSPROD.test_procedure is     function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2,p_invoice_address  varchar2)  return varchar2 is        PRAGMA AUTONOMOUS_TRANSACTION;     cursor c_cursor is                      /*sql statement as you need....                        ........................                        ........................*/                     /* Declarations ......*/       begin        .....     end; end test_procedure; You can se

Hello, If you create a package body and already close edit page, for editing package body, open schema browser in TOAD than right click and chose Load in Editor and do your changes in package body. Loves,

Hello, I've created a procedure and in the running time I've got that error. Make sure your scheme must have privileges to the tables that you use in your cursor in pl/sql script. I run bellow code and It works to me now. GRANT SELECT ON scheme_name.your_table_name TO your_scheme; Loves,

Hello, I got this error when I run insert script with select statement. This error about tablespaces. I just increased tablespace size. ALTER TABLESPACE PSTEMP ADD TEMPFILE '/data/PSPRD/oradata/pstemp_4.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 500M  MAXSIZE unlimited; Loves,

Hi, When I try to install Oracle client to windows machine, I got "INS-32025 Error" error. To overcome with that issue, go to C:\Program Files\Oracle\Inventory and delete Inventory file. Loves,

Hello, If you get this error when you run your trigger, you need to control your sql script. take out your into statement from your sql, run it and check it, If your result of sql script returns more than one row. Loves,

Hello, You can use bellow code for this subject; Local Grid &MYGRID; Local GridColumn &COLUMN; &MYGRID = GetGrid(Page."PAGE_NAME", "GRID_NAME"); If some_conditions.. Then    &MYGRID.GetColumn("FIELD_NAME").Visible = True;    &MYGRID.GetColumn("FIELD_NAME2").Visible = True; Else    &MYGRID.GetColumn("FIELD_NAME").Visible = False;    &MYGRID.GetColumn("FIELD_NAME2").Visible = False; End-If; Loves,

Hello, Sometimes,  when you use dynamic drop down list with peoplecode, having trouble with invalid value become unavoidable. When I click "Getir" button, Class Name field change invalid value even before using that button I could see true value for that field. I just only check my code that class name is changed. The value that comes in drop down list for class name doesn't pair to the value that comes from Getir button.  You can also control character length of field of drop down list. I checked values with winmessage function and I aware both of values doesn't match. That's all.  Loves,

Hello, With using collapsible Group boxes you can minimize all fields and free up space in your pages. If your page has lots of field and you can make it understandable. Before use it, you should decide to where you want to use Collapsible Group Boxes. In your page; Add a new group box which include your fields that you want to hide or show all of them. Double click head of group box and open Group Box Properties. Give a name for group box's label in Label tab.

Hello, There are lots of script that indicate how you can do that but there is a trick that you need to give a name for specified column. You can use following script; Local Grid &MYGRID; Local GridColumn &COLUMN; &MYGRID = GetGrid(Page."YOUR_PAGE_NAME", "GRID'S_NAME"); If &v_SSR_RES_MARK_OPT = "Y" Then    &MYGRID.GetColumn("COLUMN_NAME").Visible = True; Else    &MYGRID.GetColumn("COLUMN_NAME").Visible = False; End-If; Before using this script change grid's column name. To do that double click column and open page field properties. On General tab, change name of Page Field Name as you want than use this name in bellow row in your code and use it instead of COLUMN_NAME &COLUMN = &MYGRID.GetColumn("COLUMN_NAME"); PS: Do not use table/view's field name for column_name. Loves,

Hello, If you get this error, there are some multiple declarations for the identifications like below code. DECLARE zip_code INTEGER; Zip_Code INTEGER; -- duplicate identifier, despite Z/z case difference BEGIN zip_code := 90120; -- raises error here because of duplicate identifiers END; / Check your declarations and delete reiterated declaration one. Loves,

Hello, If you want to use page anchor in your pages, you need to add two push button. Insert a push button in your page.  Choose hyperlink in Type tab in general properties for first push button and add record name. We will fill Related control field later. Now, you should skip it.

Hello, I would like to share my knowledge about how can you create dynamic drop-down list and use in PS pages with some tricks. Firstly, you need to create new field which must be translate field. Field length must be four for that field cause we want to use this field with translate values.

Hello, If you get error like You are not authorized to access this component (40,20) then you can look at your roles and codes which related with transferred pages and permissions. Firstly, check the role if the role has permissions for peoplesoft menu like bellow; select ROWID,A.* from PSAUTHITEM A where MENUNAME=<Page's Menu Name> CLASSID MENUNAME BARNAME BARITEMNAME PNLITEMNAME DISPLAYONLY AUTHORIZEDACTIONS TEST_ROLE ATTND_MENU USE ATTND_INSTR2 ATTND_INSTR2 0 4 TEST_ROLE ATTND_MENU USE ATTEND_INST_1 ATTND_INST 0 14 TEST_ROLE ATTND_MENU USE CLASS_ATTENDANCE_I CLASS_ATTENDANCE_I 0 2 Check  AUTHORIZEDACTIONS field and update this field as 4 for selected rows. If you use Transfer function in a page, check your transfer code's parameter and make sure your parameters must be same with result of select state

I created some indexes for a table. When I try to delete index which belong to that table, I got error ORA-02429.  To overcome with this issue I did something as bellow; alter table TABLE_NAME drop constraint INDEX_NAME; drop index INDEX_NAME; Loves,

Hello, I want to share some weird experience about security now. We had trouble with securities like multi-language drop-down list which is right side of pages doesn't appear for some users in Peoplesoft pages. To fix this problem; go to My Personalizations page under Main Menu. Than choose Personalize General Options link and change Multi-Language Entry value as yes than save this page. So, after that users can see multi-language drop down list in own page. Loves,

Hello, You can find active sessions in peoplesoft as following scripts; /*Active sessions in Web Server*/ SELECT A. OPRID , A. LOGIPADDRESS , TO_CHAR(CAST((A. LOGINDTTM ) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF' ), TO_CHAR(CAST((A. LOGOUTDTTM ) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF' ), ROUND((CAST(( CAST(SYSTIMESTAMP AS TIMESTAMP)) AS DATE ) - CAST((TO_TIMESTAMP(TO_CHAR(CAST((A. LOGINDTTM ) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF' ), 'YYYY-MM-DD-HH24.MI.SS.FF' )) AS DATE )) * 1440 , 0 ) aktif_sure   FROM PSACCESSLOG A    WHERE ( A. LOGINDTTM = A. LOGOUTDTTM       AND A. PT_SIGNON_TYPE = '1' ) and   LOGINDTTM >= SYSDATE - 1 / 24    GROUP BY   A. OPRID ,   A. LOGIPADDRESS ,   TO_CHAR(CAST((A. LOGINDTTM ) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF' ) ,TO_CHAR(CAST((A. LOGOUTDTTM ) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF' )   ORDER BY 3 DESC -- Active sessions

Hello, If you use Oracle Peoplesoft SIS and want to controlling changes in tables you can use audit records. It's really useful. You can also use trigger but I don't suggest it because when trigger faced some problem, process'll stop obligatorily and you can not continue without overcome with trigger issue. What I have done to create audit record in PS? Login App Designer as three tier mode Open a record which you want to add audit record in this record. Save as this record without associated Peoplecodes in its fields.  Add four field end of the record's field as following fields. AUDIT_OPRID --> use this field to make sure who did changes AUDIT_STAMP --> use this field when changes happended AUDIT_ACTN --> use this field as C for changes, A for added, D for deleted AUDIT_RECNAME --> this is optional, if you use this field you can see which audit record used for this record Save your record as a table and give name as AUDIT_(your_record_name)

Peoplesoft, dünyada çok sık kullanılan ve yakın zamanda Oracle’ın satın aldığı bir ERP sistemidir. Türkiye’de yalnızca Koç Üniversitesinde ve Acıbadem Üniversitesinde kullanılanıyor şuan (Haziran 2016) Kemerburgaz Üniversitesinde de kullanılmaktaydı fakat kurum olarak kullanılmasından vazgeçildi çeşitli sebepler dolayısıyla. Peki Peoplesoft tam da ne için kullanılıyor? İşte bu sorunun cevabı çok uzun olabilir çünkü kullanım alanı fazlasıyla geniş. HR şirketleri, hastaneler, okullar için otomasyon sistemi olarak kullanılıyor. Yurt dışında kullanan çok sayıda üniversite ve şirket bulunmakta. En ilginç gelen modülü benim için içerisinde iş ilanları için yer alan kısım olmuştur. Peoplesoft’u kurduğunuzda içerisinde birçok modül ile birlikte gelir. Örneğin üniversite için ne gerekli olabilir? Not girişi, ders kaydı, öğrenci finansı ekranları, yoklama ekranları, rapor ekranları… eksiksiz tüm ekranlar zaten sistemle birlikte geliyor. İşin güzel yanı siz isterseniz peoplesoft’un ken

Merhaba, Linux açılırken Grub Root Menu ye ulaşmanız gerekir. Bunun için Linux açılırken tuşlardan birine basın. Ekran görüntüsü aşağıdaki gibi olacaktır.