Tuesday, May 12, 2009

Register A Supplier From An External URL

The URL for the suppliers to execute their own registration is:

http://[server_name]:[port]/OA_HTML/jsp/pos/suppreg/SupplierRegister.jsp?ouid=[replace_with_the_HASHKEY]

Replace the server name and port.
To get the hashkey execute:

1. Login to sqlplus as the user with "write" permission
2. Enter "set serveroutput on"
3. Run $POS_TOP/patch/115/sql/get_org_hash.sql from Sqlplus as the user.
4. Script will prompt for "operating_unit_id" value.
Enter "operating unit"
5. Script will output "hash key is (hash)"

Execute the following to check if hash key was generated:

SQL> select ORG_ID, HASHKEY from POS_ORG_HASH;

The person who registers the supplier will be added as supplier user. This supplier user will have the responsibility assigned from the profile POS: Default Responsibility for Newly Registered Supplier Users.

1 comment:

Unknown said...

oh, have you heard about the service of how to import .sql file microsoft sql? it is the fastest way to open not accessible files