How to assign Oracle Workflow Administrator privileges to users

Note: Oracle By default and design, only SYSADMIN user can views other user’s notifications. What if a requirement comes to enable everyone/certain group of people to view everyone’s notifications.

In the field ‘Workflow System Administrator’ set the value to which you want to assign the workflow administrator privilege.

Setup steps to be followed.

• Login as SYSADMIN User
• Navigate to Workflow Administrator Resp go to Administrator Workflow and Administration page.

In the admin page you will see this message “Set * to grant admin privilege to all users”

Put * in the text box “Workflow System Administrator” and click Apply.

To make all users workflow system administrators set the value as " Workflow Administrator Web (New)"  

Finally who to assign responsibility of “Workflow Administrator Web (New)" Can able to view approval notifications.

In case of any error or process struck up with Approval workflow to force to retry once again.

Oracle P2P Accounting entries for Expense Item

In Oracle purchasing Expense Items

1.      Enter Purchase Order:     No accounting takes place

2.      Oracle Inventory Enter a Receipt:

Accounts	Debit	Credit
Inventory Receiving A/c	Dr
Accrual A/c		Cr

3.      Receiving Transaction

- For Expense Item direct receipt – delivered to inventory

Accounts	Debit	Credit
Expense A/c	Dr
Inventory Receiving A/c		Cr

- For Expense Item standard receipt – delivered to inventory

Accounts	Debit	Credit
Expense A/c	Dr
Inventory Valuation A/c		Cr

    

4.      Oracle Payable

a.      Regular payment

·         Enter Invoice

Accounts	Debit	Credit
Accrual A/c	Dr
Liability A/c		Cr

·         Payment against Invoice

Accounts	Debit	Credit
Liability A/c	Dr
Cash Clearing A/c		Cr

b.      Prepayment invoice

·         Enter Invoice

Accounts	Debit	Credit
Prepayment A/c	Dr
Liability A/c		Cr

·         Payment against Invoice

Accounts	Debit	Credit
Liability A/c	Dr
Cash Clearing A/c		Cr

·         Apply Prepayment to Invoice

Accounts	Debit	Credit
Accrual A/c	Dr
Prepayment A/c		Cr
Liability A/c		Cr

5.      Clearing (Cash Management)

Accounts	Debit	Credit
Cash Clearing A/c	Dr
Bank		Cr

iSupplier portal Table Names

Oracle iSupplier Portal - Base Tables

TABLE NAME	DESCRIPTION
POS_ACCT_ADDR_REL	Supplier bank account and address assignments
POS_ACNT_ADDR_REQ	Table for supplier bank account and address assignment requests
POS_ACNT_ADDR_SUMM_REQ	This table stores the details of supplier bank account and address assignment requests.
POS_ACNT_GEN_REQ	Table for supplier bank account requests
POS_ACNT_PAY_PREF	This table stores the payment preferences of suppliers for their addresses.
POS_ADDRESS_NOTES	Notes for supplier addresses
POS_ADDRESS_REQUESTS	Supplier Address Requests
POS_ADDRESS_UPGRADE	Supplier address upgrade staging table
POS_ASN_LOAD	This table will record ALL upload Excel ASN requests
POS_ATTRPG_CONFIG	Supplier Data Hub project.  Used to store RFI template association to operating unit during onboarding configuration.
POS_BANK_ACCNT_OWNERS_INT
POS_BANK_ACCOUNT_DET_INT
POS_BUS_CLASS_ATTR	Supplier Business Classification Attributes
POS_BUS_CLASS_REQS	Business Classification Requests for Suppliers
POS_BUSINESS_CLASS_INT
POS_CAPACITY_TOLERANCE_TEMP	This Table is used to Store Cange in Capacity Tolerance Orders
POS_CONT_ADDR_REQUESTS	Requests for supplier contact and address links
POS_CONTACT_REQUESTS	Supplier Contact Requests
POS_CONTACT_UPGRADE	Supplier contact upgrade staging table
POS_FISCAL_CLASS_INT
POS_IMP_BATCH_SUMMARY
POS_MFG_CAPACITY_TEMP	This Table is used to Store Cange in Capacity for Orders
POS_ORDER_MODIFIERS_TEMP	This table is used to store the order modifier request
POS_ORG_HASH	Hash keys for operating unit identifier
POS_OSN_ASSOCIATIONS	Table for storing the association between Oracle Supplier Network trading partners and the iSP vendors
POS_OSN_REQUESTS	Table for storing inbound requests from Oracle Supplier Network
POS_PARTY_TAX_PROFILE_INT
POS_PARTY_TAX_REG_INT
POS_PRODUCT_SERVICE_INT
POS_PRODUCT_SERVICE_REQUESTS	Requests for supplier products and services
POS_PRODUCTS_SERVICES_GT
POS_PROMPTS	Dummy Table used for AK Region Definitions
POS_RFI_TEMPLATE_CONFIG	Supplier Data Hub project.  Used to store RFI template association to operating unit during onboarding configuration.
POS_SPMNTF_SUBSCRIPTION	This table stores information on which users to send email notifications when supplier makes changes to their profile.
POS_SUP_BANK_ACCOUNT_REQUESTS	This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12.
POS_SUP_ONBOARD_CONFIG	Configurations for flexible supplier registration and onboarding
POS_SUP_PRODUCTS_SERVICES	Supplier product and service classification
POS_SUPP_GENERATE_XML_RPT
POS_SUPP_PROF_EXT_B	Supplier Data Hub project.  Extension table to store user-defined attributes for Supplier related entities.
POS_SUPP_PROF_EXT_INTF	Supplier Data Hub project.  Interface table for Supplier user-defined attributes
POS_SUPP_PROF_EXT_TL	Supplier Data Hub project.  Translation table for POS_SUPP_PROF_EXT_B
POS_SUPP_PUB_HISTORY
POS_SUPP_PUB_RESPONSES
POS_SUPPLIER_INT_REJECTIONS
POS_SUPPLIER_MAPPINGS	References to supplier parties and/or supplier requests
POS_SUPPLIER_REGISTRATIONS	Supplier Registrations and Supplier Onboarding Requests
POS_SUPPLIER_UDA_MERGE_GTT
POS_SURVEY_CONFIG	Supplier survey configuration
POS_SURVEY_TRANSACTIONS	Supplier survey transaction table
POS_UPGRADE_USERS	This table will record all the users upgraded for ISP
POS_VENDOR_UPG_TMP	This table is used during release 11i to release 12 upgrade.  It stores vendor_ids of vendors who are considered in iSupplier Portal TCA Supplier upgrade scripts.

Oracle iSupplier Portal - View Tables

VIEW NAME	DESCRIPTION
POS_AP_CHECKS_V	used to select the payment info details
POS_AP_INVOICES_V	used to select the invoice details
POS_AP_INVOICE_PAYMENTS_V	used to select the payment  info associated with an  invoice
POS_ASN_VIEW_FOR_SEARCH
POS_BILL_ONLY_ORDERS_V	used to select consumption advices.
POS_BLANKET_AGREE_V	View used to display blanket agreements. This view is created for convenience to be used to define the BC4J object
POS_CHV_AUTHORIZATIONS_V	used to select the detailed info related to authorization
POS_CHV_ITEM_ORDERS_V	used to select the item orders details info
POS_CHV_SCHEDULE_HEADERS_V	used to select the schedule and vendor info
POS_CHV_SCHEDULE_ITEMS_V	is one of the views used to select schedule related info
POS_CONSIGNED_SHIPMENTS_V	Used to select consigned shipments.
POS_DISTRIBUTIONS_V	used to select the detailed info for distributions
POS_HEADERS_V	used to select the header info for Advance Shipment Notice created
POS_HORIZONTAL_SCHEDULE_V	used to select schedule related info
POS_LINES_V	used to select the line-level info for the Advance Shipment Notice
POS_MTL_ONHAND_ITEMS_DMMY_V	used to select the inventory_item_id info for on-hand items
POS_MTL_ONHAND_ITEMS_KFV	used to select the detailed info for on-hand items
POS_MTL_ONHAND_LOCATOR_KFV	used to select the location info for on-hand items
POS_MTL_ONHAND_LOT_KFV	used to select the lot_number and related  info for on-hand items
POS_MTL_ONHAND_REV_KFV	used to select the  info related to on-hand items
POS_MTL_ONHAND_SERIAL_KFV	used to select the serial number info for on-hand items
POS_MTL_ONHAND_SUB_KFV	used to select the sub_inventory  info for on-hand items
POS_ORDER_SUMMARY_V
POS_ORD_MODIFIERS_V	Fetches the items from approved supplier lists
POS_ORG_ADDRESS_V	This view is used to fetch address information from the mtl_organizations view
POS_PARTIES_V	View for use with Party Merge
POS_PARTY_SITES_V	View used in party merge
POS_PER_PEOPLE_X_V	This is a view which retrieves the data related to an employee.
POS_PLAN_SCHEDULE_HEADERS_V	Used to select schedule and vendor info for planning schedules.
POS_PO_ARCH_SUMMARY_V
POS_PO_DETAILS_V	Fetches all the information related to a purchase order
POS_PO_EMPLOYEE_DETAILS_V	View to retrieve employee details.
POS_PO_EXPECTED_RECEIPTS_V	This view fetches the orders which are available to receive
POS_PO_HEADERS_ARCHIVE_V	Displays PO Revison Histories
POS_PO_INVOICE_SUP_ORDERS_V	Fetches the invoices associated with a Purchase Order and the details of the PO and the invoice.
POS_PO_LATE_RECEIPTS_V	Displays Overdue receipts
POS_PO_LINES_ARCHIVE_V	Fetches information from the po_lines_archive_all table. Needed to show Purchase Order History information.
POS_PO_LINES_V	Fetches information related to shipments for the Purchase Order. Used to fetch records for which an ASN could be created.
POS_PO_LIST_USERS_V	Not Used
POS_PO_LOCATION_DETAIL_V	Fetches address information from HR_LOCATIONS
POS_PO_OSP_V	Fetches PO details related to items which need outside processing.
POS_PO_QA_SHIPMENTS_V	Fetches shipment information for POs created for outside processing items.
POS_PO_REVISIONS_HEADER_V
POS_PO_REVISIONS_LINE_V
POS_PO_REVISIONS_TEMP_V
POS_PO_RFQ_HEADERS_V	Displays RFQ Headers
POS_PO_RFQ_LINES_V	Displays RFQ Lines
POS_PO_SUMMARY_V	Displays all Purchase Orders
POS_PO_SUPPLIER_AGREEMENTS_V	Displays Blankets
POS_PO_SUPPLIER_INFO_V	Displays Supplier Information
POS_PO_SUPPLIER_ITEMS_V	Displays all items from ASL
POS_PO_SUPPLIER_ORDERS_V	Displays All Types of PO's
POS_PO_USER_DETAILS_V	Displays User Information
POS_PO_VENDORS_V	Displays Vendors
POS_RCV_EARLY_LATE_RECEIPTS_V	Displays All receipts
POS_RCV_REJECTED_ITEMS_V	This view contains the information about Rejected Items
POS_RCV_RETURNS_V	Displays Returns for Shipments
POS_RCV_TRANSACTIONS_V	Displays Receiving Transactions
POS_RECEIPT_HEADERS_V	Displays Receipts
POS_SHIPMENTS_V	Displays Shipments
POS_SHIP_SCHEDULE_HEADERS_V	Used to select schedule and vendor info for shipment schedules.
POS_SUPPLIER_USERS_V	Queries the list of supplier users
POS_SUPP_AGREEMENTS_V
POS_SUPP_PROF_EXT_OCV	Supplier Data Hub project.  Supplier Profile Extension Classification View
POS_SUPP_PROF_EXT_VL	Supplier data hub project.  User-defined attribute MLS view.
POS_SUPP_PUB_HISTORY_V
POS_SUP_AP_BANK_ACCOUNTS_V	An internal view for supplier bank accounts in Oracle Payables
POS_VIEWPO_SUMMARY_V
POS_VIEW_ASN	This View is used to Display ASN's in the Buyers System
POS_VIEW_PO_SUMMARY_V	This view is used to display all Purchase Orders from archive tables.