You can enable custom company reports in the Portal, which can be started from the View Reports drop-down list.
Which reports are available and displayed in the list is controlled by the CIP m_pck_company_custom.get_report_urls. The CIP is called by the user interface upon certain context changes. The context parameters are passed to the CIP to determine which reports are available in a given context, and these reports are returned in a list, with title and URL of the report. This is the CIP description:
get_report_urls
===============
This CIP returns a context specific collection of customer reports that will be accessible to the end user in the Smart Materials Portal application. This is the detailed description of the input parameters:
1. p_company_id - primary key value in table m_companies that identifies the company of the logged-on user (unless the log-on is solely based on a p_lre_id value at the earliest possible stage of company registration).
2. p_sup_id - primary key value in table m_suppliers in case such an entry is associated with the company of the logged-on user.
3. p_lre_id - primary key value of table m_login_requests in case such an entry is associated with the company of the logged-on user (or at the earliest possible stage of company registration).
4. p_ccp_id - primary key value in table m_company_contact_people that represents the logged-on user (unless the log-on is solely based on a p_lre_id value at the earliest possible stage of company registration).
5. p_lrc_id - primary key value in table m_login_request_contacts that represents the logged-on user (at the earliest possible stage of company registration).
6. p_uie_id - primary key value in table m_ui_elements that makes up the context for which to determine and display available reports.
7. p_pk_type - primary key type alias indicating the type of object that parameter p_pk_id identifies. Given below are the list of values that it can have.
Primary key type |
Implied context |
---|---|
POH |
Agreement |
PL |
Packing list |
PCK |
Package |
PPL |
Preliminary packing list |
PP |
Preliminary package |
EML |
EMLs |
TSHIP |
Shipments |
8. p_pk_id - the primary key value of the object for which the user shall be able to generate reports.
9. p_nls_id - the NLS ID reflecting the UI language selected by the logged-on user.
The CIP returns a collection of report title/report URL pairs which may be empty.
The standard CIP includes a sample implementation which can be used to apply your own logic.