10 th anniversary 1999 - 2009 integrating ssb and bdms chasing a bunny trail
TRANSCRIPT
10th Anniversary 1999 - 2009
Integrating SSB and BDMS
Chasing a bunny trail.
General Announcements:
Please turn off all cell phones/pagers If you must leave the session early, please
do so as discreetly as possible Please avoid side conversations during the
session Questions will be answered …..
Thank you for your cooperation
SSB---BDMS
Overview of process to generate custom self service page based on custom Xtender application
Account setup Tables involved Code Output Issues
Links to document in BDMS
Hard coded links to
other web pages.
Result set view from Document Manager
SSB---BDMS
SSB---BDMS
Step 1 - Define and set-up Super-User ID’s Create account in AppGen
Multiple Logins at global level Display access at application level
Create the same account in Banner BAN_DEFAULT_C BAN_MES_AAA_EVERYBODY BAN_XTENDER_C
Login to Banner using this account and access imaging to sync passwords.
SSB---BDMS
Step 2 – Create seed data for EOBUSER
SSB---BDMS
Column Name Value Description
EOBUSER_USERNAME BXSIMGD Account created in step 1
EOBUSER_PASSWORD X#X#X#X# Random text that will be changed shortly
EOBUSER_APP_NAME MC-CUSTOM-GENERAL The BDMS application
EOBUSER_ACTIVITY_DATE
2/9/2009 9:23:12 AM Date record was added
EOBUSER_USER_ID DMINICH ID of the user that added this record
EOBUSER_DATA_ORIGIN MANINSERT Source System that added the row
SSB---BDMS
Step 2 – cont. Run euuser.sql to encrypt the password set
in EOBUSER /u01/app/sct/banbanr/extsol/plus Run as banimgr
Step 3 – Create seed data for EOBPARM
SSB---BDMS
Column Name Value Description
EOBPARM_NAME MC_SSB_BXS_DIRVIEW.VIEW_DIR_ DOCS
Package.Procedure that generates the html
EOBPARM_DOC_NAME EMPLOYEE DIRECTORY – GENERAL SSB Doc Name
EOBPARM_QUERY_IND Y Is this field used to query Xtender Y or N
EOBPARM_ACTIVITY_DATE 2/9/2009 9:23:12 AM Date record was added
EOBPARM_USER_ID DMINICH ID of the user that added this record
EOBPARM_PARMNAME DOCUMENT TYPE Name of parameter used in SSB
EOBPARM_MAPNAME FIELD2 Name of mapped parameter in BXS
EOBPARM_DATA_ORIGIN MANINSERT Source System that added the row
Select * from table where Field2 = ‘EMPLOYEE DIRECTORY – GENERAL’
Bunny Trail
select
appname, ae_apps.appid, coldesc, colname
from
otgmgr.ae_adefs, otgmgr.ae_apps
where ae_adefs.appid = ae_apps.appid and
ae_apps.appname = 'MC-CUSTOM-GENERAL'
APPNAME APPID COLDESC COLNAME
MC-CUSTOM-GENERAL 526 DOCUMENT TYPE FIELD2
EOBPARM_NAME EOBPARM_DOC_NAME EOBPARM_PARMNAME EOBPARM_MAPNAME
MC_SSB_BXS_DIRVIEW.VIEW_DIR_DOCS
EMPLOYEE DIRECTORY – GENERAL DOCUMENT_TYPE FIELD2
Select * from table where FIELD2 = DOCUMENT_TYPE
Select * from table where FIELD2 = ‘EMPLOYEE DIRECTORY –GENERAL’
MC_CUSTOM_GENERAL application
SSB---BDMS
Step 4 – Create seed data for EOBDOCM
Column Name Value DescriptionEOBDOCM_NAME MC_SSB_BXS_DIRVIEW.
VIEW_DIR_DOCSPackage.Procedure that generates the html
EOBDOCM_DOC_NAME EMPLOYEE DIRECTORY – GENERAL SSB Document Name
EOBDOCM_DISPLAY_IND Y Link Visible in SSB Y or N
EOBDOCM_MODULE_ CODE
G Self Service module
EOBDOCM_VIEW_IND Y Indicates if document is viewable Y or N
EOBDOCM_DOWNLOAD_ IND
N Indicates if document may be downloaded Y or N
EOBDOCM_UPLOAD_IND N Indicates if document may be uploaded Y or N
EOBDOCM_ACTIVITY_ DATE
SYSDATE Source System that added the row
EOBDOCM_USER_ID DMINICH User that created or updated record
EOBDOCM_APP_NAME MC-CUSTOM-GENERAL Name of application
EOBDOCM_DESC EMPLOYEE GENERAL DIRECTORY Description of document for SSBLink text
EOBDOCM_DATA_ORIGIN MANINSERT Source system that created or updated the row.
SSB---BDMS
Relationship between EOBPARM & EOBDOCM
EOBPARM_NAME = EOBDOCM_NAME
and
EOBPARM_DOC_NAME = EOBDOCM_DOC_NAME
SSB---BDMS
Step 5 – (4.0.1) create/add necessary code to package & procedures.
Bunny Trail
Twbkbxmn.p_set_bxs_parm Owned by WTAILOR
Twbkbxmn.p_get_bxs_url Owned by WTAILOR
Ewkwrslt.P_Disp_Page
Twbkbxmn. p_set_bxs_parm--------------------------------------------------------------------
-- Sets the value of the parameter passed in name to value.
-- p_bxs_parmtable is a dynamic table.
-- Parmeter "v_name" is required field.
-- Parmeter "v_value" is required field.
--------------------------------------------------------------------
PROCEDURE p_set_bxs_parm(v_name VARCHAR2,
v_value VARCHAR2) IS
BEGIN
p_bxs_parmtable(UPPER(v_name)) := UPPER(v_value);
END;
Twbkbxmn.p_get_bxs_url---------------------------------------------------------------------- Calls BXS procedure p_get_url of pacakge EWKWTOW.-- It retrieves the three URL's for the page & document name passed-- Parmeter "v_pidm" is required field and is an IN parameter.-- Parmeter "v_page_name" is required field and is an IN parameter.-- Parmeter "v_doc_name" is required field and is an IN parameter.-- Parmeter "v_upload_url" is OUT parameter.-- Parmeter "v_download_url" is OUT parameter.-- Parmeter "v_view_url" is OUT parameter.-------------------------------------------------------------------- PROCEDURE p_get_bxs_url(v_pidm IN OUT NUMBER, v_page_name VARCHAR2, v_doc_name VARCHAR2, v_upload_url OUT VARCHAR2, v_download_url OUT VARCHAR2, v_view_url OUT VARCHAR2) IS
sql_string VARCHAR2(2048); BEGIN
sql_string := 'BEGIN EWKWTOW.p_get_url(:1, :2, :3, :4, :5, :6); END;'; EXECUTE IMMEDIATE sql_string USING IN OUT v_pidm, IN v_page_name, IN v_doc_name, OUT v_upload_url, OUT v_download_url, OUT v_view_url;
END;
Where the errors are EXRRSLT Used in baseline code for testing
-- dmm test code
insert into dminich.bdms_ssb_testing values('TWBKBXMN','p_get_bxs_url',v_pidm,v_page_name,v_doc_name,v_view_url,'Step 1');
commit;
-- dmm test code
Used in custom procedure for testing
-- debugging use only
twbkfrmt.P_TableRowOpen('left');
twbkfrmt.P_TableData(doc_type_count||' Document Type = '||v_type(doc_type_count)||' Document Description = '||v_desc(doc_type_count),calign=>'left');
twbkfrmt.P_TableRowClose;
-- debugging ends;
SSB---BDMS
Step 6+ – (For custom pages) Setup web tailor
Create public synonym for MC_SSB_BXS_DIRVIEW.VIEW_DIR_DOCS
Add menus and procedures Grant access
SSB—BDMS for Finance
Still in development User Account BXSIMGF Application B-F-DOCS Example uses custom SSB page
MC_SSB_BXS_FINVIEW.VIEW_ADMN_DOCS If baseline – BWFKVINV.P_VIEWDOC
SSB---BDMS for Finance
Column Name Value Description
EOBUSER_USERNAME BXSIMGF Account created in step 1
EOBUSER_PASSWORD X#X#X#X# Random text that will be changed shortly
EOBUSER_APP_NAME B-F-DOCS The BDMS application
EOBUSER_ACTIVITY_DATE 2/9/2009 9:23:12 AM
Date record was added
EOBUSER_USER_ID DMINICH ID of the user that added this record
EOBUSER_DATA_ORIGIN MANINSERT Source System that added the row
EOBPARM_NAME EOBPARM_DOC_NAME EOBPARM_PARMNAME EOBPARM_MAPNAME
MC_SSB_BXS_FINVIEW.VIEW_ADMN_DOCS JOURNAL VOUCHER DOCUMENT_ID FIELD1
MC_SSB_BXS_FINVIEW.VIEW_ADMN_DOCS JOURNAL VOUCHER DOCUMENT_TYPE FIELD3
for Finance
select
appname, ae_apps.appid, coldesc, colname
from
otgmgr.ae_adefs, otgmgr.ae_apps
where ae_adefs.appid = ae_apps.appid and
ae_apps.appname = ‘B-F-DOCS'
APPNAME APPID COLDESC COLNAME
B-F-DOCS 506 DOCUMENT ID FIELD1
B-F-DOCS 506 DOCUMENT TYPE FIELD3
EOBPARM_NAME EOBPARM_DOC_NAME EOBPARM_PARMNAME EOBPARM_MAPNAME
MC_SSB_BXS_FINVIEW.VIEW_ADMN_DOCS JOURNAL VOUCHER DOCUMENT_ID FIELD1
MC_SSB_BXS_FINVIEW.VIEW_ADMN_DOCS JOURNAL VOUCHER DOCUMENT_TYPE FIELD3
Select * from table where FIELD1 = DOCUMENT_ID and FIELD3 = DOCUMENT_TYPE
Select * from table where FIELD1 = ‘J0012852’ and FIELD3 = ‘JOURNAL VOUCHER’
B-F-DOCS application
Column Name Value DescriptionEOBDOCM_NAME MC_SSB_BXS_FINVIEW.
VIEW_ADMN_DOCSPackage.Procedure that generates the html
EOBDOCM_DOC_NAME JOURNAL VOUCHER SSB Document Name
EOBDOCM_DISPLAY_IND Y Visible in SSB Y or N
EOBDOCM_MODULE_ CODE
F Self Service module
EOBDOCM_VIEW_IND Y Indicates if document is enabled Y or N
EOBDOCM_DOWNLOAD_ IND
N Indicates if document may be downloaded Y or N
EOBDOCM_UPLOAD_IND N Indicates if document may be uploaded Y or N
EOBDOCM_ACTIVITY_ DATE
SYSDATE Source System that added the row
EOBDOCM_USER_ID DMINICH User that created or updated record
EOBDOCM_APP_NAME B-F-DOCS Name of application
EOBDOCM_DESC JOURNAL VOUCHER Description of document for SSBLink text
EOBDOCM_DATA_ORIGIN MANINSERT Source system that created or updated the row.
SSB—BDMS for Finance
Lines of code that would differ in p_get_url
twbkbxmn.p_set_bxs_parm('DOCUMENT ID', global_doc);
twbkbxmn.p_set_bxs_parm('DOCUMENT TYPE', ‘JOURNAL VOUCHER’);
Setting 2 parameters instead of 1.
To alter baseline add BDMS code to BWFKVINV.P_VIEWDOC
Open to the Floor
Questions Comments