Friday, April 20, 2018

Banner error not authorized access SOAIDEN


Banner error not authorized access SOAIDEN


Check GURUOBJ

select * from BANSECR.GURUOBJ where GURUOBJ_USERID = 'your userid'



Resolution:

Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
  Values ('SOAIDEN', 'BAN_DEFAULT_M', 'your userid', SYSDATE, 'BANSECR');

Banner ORA-20104: Invalid version of object is being used ORA-06512: at "BANSECR.G$_SECURITY_PKG"

Ellucian Banner 9 admin

Error:

ORA-20104: Invalid version of object is being used.
ORA-06512: at "BANSECR.G$_SECURITY_PKG", line 821
ORA-06512: at line 1

Root cause:

Java Code of form and DB is mismatched

Resolution:

Ex: GEAPART form:

Option 1: update DB

UPDATE GURAOBJ SET GURAOBJ_CURRENT_VERSION_ALT = '9.3.3', GURAOBJ_ACTIVITY_DATE = SYSDATE WHERE GURAOBJ_OBJECT = 'GEAPART';

Option 2: update code
GEAPART form controller

@ActionTrigger(action="LOAD_CURRENT_RELEASE")
public void Wfacrlv_LoadCurrentRelease()
{

getFormModel().getFormHeader().setCurrentRelease(toStr("9.3.3"));
}

Monday, April 16, 2018

Banner error not authorized to access GUAINIT


Banner error not authorized to access GUAINIT

need to grant access on bansecr

grant select on bansecr.gubiprf to userid;


Wednesday, February 28, 2018

Thursday, February 1, 2018

Oracle CPQ: build TAB by ArraySet, Array Control, Attribute as Array

In Oracle CPQ, we can build from with multiple TAB

1. define form attributes as array
2. define one array control as integer: number of form
3. go to array set, create new one with array control above and put dependency relate to all array attributes
4. set display as TAB

how to: Procedure returns multiple rows to java with array and cursor


create  type test_obj AS object
(
                                P_Program  VARCHAR2(400)
                           
);

CREATE TYPE test_nt AS TABLE OF test_obj;


Procedure Proc1 (P_Cursor Out SYS_REFCURSOR)
AS

Cursor C1 Is
 Select * from .......;


Cursor C2  (P_Program_In In Varchar2) Is
    Select * from where program = P_Program_In ;

P_Program  VARCHAR2(400);


v_prog_nt test_nt;
i integer := 0;

Begin
    --SELECT test_obj(P_Program ) BULK COLLECT INTO v_prog_nt FROM DUAL;

   v_prog_nt := test_nt();
 
    For Ds In C1
    Loop
 
      For Rs In C2(Ds.Program)
      Loop
   
       v_prog_nt.extend;
       i:= i+1;
        P_Program := Rs.Program;
   
   
        v_prog_nt(i) := test_obj(P_Program  );

        --dbms_output.put_line(i);
        dbms_output.put_line(v_prog_nt(i).P_Program);

      End Loop;
    End Loop;

Open P_Cursor
  For
  Select P_Program  from table(v_prog_nt);

End;

Store Procedure PLSQL returns Cursor in Loop to Java


create  type test_obj AS object
(
                                P_Program  VARCHAR2(400)
                             
);

CREATE TYPE test_nt AS TABLE OF test_obj;


Procedure Proc1 (P_Cursor Out SYS_REFCURSOR)
AS

Cursor C1 Is
 Select * from .......;


Cursor C2  (P_Program_In In Varchar2) Is
    Select * from where program = P_Program_In ;

P_Program  VARCHAR2(400);


v_prog_nt test_nt;
i integer := 0;

Begin
    --SELECT test_obj(P_Program ) BULK COLLECT INTO v_prog_nt FROM DUAL;
 
   v_prog_nt := test_nt();
   
    For Ds In C1
    Loop
   
      For Rs In C2(Ds.Program)
      Loop
     
       v_prog_nt.extend;
       i:= i+1;
        P_Program := Rs.Program;
     
     
        v_prog_nt(i) := test_obj(P_Program  );

        --dbms_output.put_line(i);
        dbms_output.put_line(v_prog_nt(i).P_Program);
 
      End Loop;
    End Loop;

Open P_Cursor
  For
  Select P_Program  from table(v_prog_nt);

End;

AWS how to delete VPC when it has error with Network interface , Gateway decencies

   how to delete VPC when it has error with Network interface , Gateway decencies  in AWS 1. Check if it is running on EC2 instance then Sto...