You are browsing the archive for Oracle Purchasing.

by oracleguru

Advanced Shipment Notice Discrepant Receipts

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Purchasing

Report Short Code: RCVDSC
Report Name: Advanced Shipment Notice Discrepant Receipts
Module: Oracle Purchasing

Report Summary: This report compares the ASNs information with actual receipts and generates exception report. If Suppliers notifies 20 quantity shipped through ASN, but only 18 quantity were received, this report will show the discrepancy.

Navigation: Oracle Purchasing -> Reports -> Run -> Select Report Name as ‘Advanced Shipment Notice Discrepant Receipts Report’

Advanced Shipment Notice Discrepant Receipts

Advanced Shipment Notice Discrepant Receipts

Report Parameters:

  • Begin Date
  • End date

 

Report Output:
Report output shows ASN discrepancies with actual PO receipts.

Tags: , , No Comments »

by oracleguru

PO Buyer Vacation Rules Setup

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Purchasing

If a buyer goes on vacation or out of office on a business trip/training, he can setup vacation rules so that his approvals can be delegated some other person.

Navigation: PO Buyer responsibility -> Notification summary ->

PO Notification summary

PO Notification summary

Click on ‘Vacation Rules’

Vacation Rule

Vacation Rule

Click on ‘Create Rule’

Create Vacation Rule

Create Vacation Rule

Enter delegation details like item type to delegate, start and end date and name of the person to be delegated.

Delegation Details

Delegation Details

Save the details.

Now based on effective dates the delegation of approvals will kick-off. To turn-off the delegation prior to end date you can follow the same navigation and delete the delegation rule.

Tags: , , No Comments »

by oracleguru

Oracle Purchasing Tables

ORACLE APPS COMMUNITY > Tutorial > Procurement > Oracle Purchasing

  • POA_BIS_SAVINGS
  • POA_BIS_SAVINGS_EFC
  • POA_BIS_SAVINGS_RPT
  • POA_BIS_SAVINGS_RPT_EFC
  • POA_BIS_SUPPLIER_PERFORMANCE
  • POA_BIS_SUPPLIER_PERFORMAN_EFC
  • POA_CM_DISTRIBUTIONS
  • POA_CM_EVALUATION
  • POA_CM_EVAL_SCORES
  • PO_ACCEPTANCES
  • PO_ACCRUAL_ACCOUNTS_TEMP_ALL
  • PO_ACCRUAL_RECONCILE_TEMP_ALL
  • PO_ACCRUAL_WRITE_OFFS_ALL
  • PO_ACCRUAL_WRITE_OFFS_ALL_EFC
  • PO_ACTION_HISTORY
  • PO_AGENTS
  • PO_APPROVAL_LIST_HEADERS
  • PO_APPROVAL_LIST_LINES
  • PO_APPROVED_SUPPLIER_LIST
  • PO_ASL_ATTRIBUTES
  • PO_ASL_DOCUMENTS
  • PO_ASL_STATUSES
  • PO_ASL_STATUS_RULES
  • PO_ATT_TMP_RECORDS
  • PO_AUTOSOURCE_DOCUMENTS_ALL
  • PO_AUTOSOURCE_RULES
  • PO_AUTOSOURCE_VENDORS
  • PO_CHANGE_REQUESTS
  • PO_COMMODITIES_B
  • PO_COMMODITIES_TL
  • PO_COMMODITY_CATEGORIES
  • PO_COMMODITY_GRANTS
  • PO_CONTROL_FUNCTIONS
  • PO_CONTROL_GROUPS_ALL
  • PO_CONTROL_RULES
  • PO_CONTROL_RULES_EFC
  • PO_DISTRIBUTIONS_ALL
  • PO_DISTRIBUTIONS_ALL_EBS
  • PO_DISTRIBUTIONS_ARCHIVE_ALL
  • PO_DISTRIBUTIONS_GT
  • PO_DISTRIBUTIONS_INTERFACE
  • PO_DOCUMENT_TOTALS_GT
  • PO_DOCUMENT_TYPES_ALL_B
  • PO_DOCUMENT_TYPES_ALL_TL
  • PO_EMPLOYEE_HIERARCHIES_ALL
  • PO_ENCUMBRANCE_GT
  • PO_GA_ORG_ASSIGNMENTS
  • PO_GA_ORG_ASSIGNMENTS_ARCHIVE
  • PO_HAZARD_CLASSES_B
  • PO_HAZARD_CLASSES_TL
  • PO_HEADERS_ALL
  • PO_HEADERS_ALL_EBS
  • PO_HEADERS_ARCHIVE_ALL
  • PO_HEADERS_GT
  • PO_HEADERS_INTERFACE
  • PO_HISTORY_POS_ALL
  • PO_HISTORY_RECEIPTS
  • PO_HISTORY_REQUISITIONS_ALL
  • PO_HISTORY_VENDORS
  • PO_INTERFACE_ERRORS
  • PO_JOB_ASSOCIATIONS_B
  • PO_JOB_ASSOCIATIONS_TL
  • PO_LINES_ALL
  • PO_LINES_ALL_EBS
  • PO_LINES_ARCHIVE_ALL
  • PO_LINES_INTERFACE
  • PO_LINE_LOCATIONS_ALL
  • PO_LINE_LOCATIONS_ALL_EBS
  • PO_LINE_LOCATIONS_ARCHIVE_ALL
  • PO_LINE_LOCATIONS_GT
  • PO_LINE_TYPES_B
  • PO_LINE_TYPES_TL
  • PO_LOCATION_ASSOCIATIONS
  • PO_LOCATION_ASSOCIATIONS_ALL
  • PO_MASSCANCEL_INCLUDES_ALL
  • PO_MASSCANCEL_INTERIM
  • PO_MC_DISTRIBUTIONS
  • PO_MC_HEADERS
  • PO_NOTES
  • PO_NOTE_ATTRIBUTES
  • PO_NOTE_REFERENCES
  • PO_NOTIFICATIONS_ALL
  • PO_NOTIFICATION_CONTROLS
  • PO_ONLINE_REPORT_TEXT
  • PO_POSITION_CONTROLS_ALL
  • PO_PRICE_DIFFERENTIALS
  • PO_PRICE_DIFFERENTIALS_ARCHIVE
  • PO_PRICE_DIFF_INTERFACE
  • PO_PURGE_PO_LIST
  • PO_PURGE_RECEIPT_LIST
  • PO_PURGE_REQ_LIST
  • PO_PURGE_VENDOR_LIST
  • PO_QUALITY_CODES
  • PO_QUOTATION_APPROVALS_ALL
  • PO_RELATED_TEMPLATES
  • PO_RELEASES_ALL
  • PO_RELEASES_ALL_EBS
  • PO_RELEASES_ARCHIVE_ALL
  • PO_REQEXPRESS_HEADERS_ALL
  • PO_REQEXPRESS_LINES_ALL
  • PO_REQUISITIONS_INTERFACE_ALL
  • PO_REQUISITIONS_INT_ALL_EFC
  • PO_REQUISITION_HEADERS_ALL
  • PO_REQUISITION_LINES_ALL
  • PO_REQUISITION_LINES_ALL_EFC
  • PO_REQUISITION_SUPPLIERS
  • PO_REQ_DISTRIBUTIONS_ALL
  • PO_REQ_DISTRIBUTIONS_ALL_EFC
  • PO_REQ_DIST_INTERFACE_ALL
  • PO_RESCHEDULE_INTERFACE
  • PO_RETRIEVED_TIMECARDS
  • PO_RFQ_VENDORS
  • PO_RULE_EXPENSE_ACCOUNTS
  • PO_SUPPLIER_ITEM_CAPACITY
  • PO_SUPPLIER_ITEM_TOLERANCE
  • PO_SYSTEM_PARAMETERS_ALL
  • PO_UNIQUE_IDENTIFIER_CONT_ALL
  • PO_UN_NUMBERS_B
  • PO_UN_NUMBERS_TL
  • PO_USAGES
  • PO_USAGE_ATTRIBUTES
  • PO_VALIDATION_RESULTS_GT
  • PO_VENDORS
  • PO_VENDORS_EBS
  • PO_VENDOR_CONTACTS
  • PO_VENDOR_LIST_ENTRIES
  • PO_VENDOR_LIST_HEADERS
  • PO_VENDOR_SITES_ALL
  • PO_VENDOR_SITES_ALL_EBS
  • PO_WF_CANDIDATE_REQ_LINES_TEMP
  • PO_WF_DEBUG
  • PO_WF_USER_TMP
  • RCV_ACCOUNTING_EVENTS
  • RCV_ACCOUNTING_EVENT_TYPES
  • RCV_FTE_TRANSACTION_LINES
  • RCV_GAPLESS_INVOICE_NUMBERS
  • RCV_HEADERS_INTERFACE
  • RCV_LOTS_INTERFACE
  • RCV_LOTS_SUPPLY
  • RCV_LOT_TRANSACTIONS
  • RCV_MC_REC_SUB_LEDGER
  • RCV_MC_SHIPMENT_HEADERS
  • RCV_MC_SHIPMENT_LINES
  • RCV_MC_SUB_LEDGER_DETAILS
  • RCV_MC_TRANSACTIONS
  • RCV_PARAMETERS
  • RCV_RECEIVING_SUB_LEDGER
  • RCV_ROUTING_HEADERS
  • RCV_ROUTING_HEADERS_OLD
  • RCV_ROUTING_STEPS
  • RCV_SERIALS_INTERFACE
  • RCV_SERIALS_SUPPLY
  • RCV_SERIAL_TRANSACTIONS
  • RCV_SHIPMENT_HEADERS
  • RCV_SHIPMENT_LINES
  • RCV_SHIPMENT_LINES_EFC
  • RCV_SUB_LEDGER_DETAILS
  • RCV_SUPPLY
  • RCV_TRANSACTIONS
  • RCV_TRANSACTIONS_INTERFACE
  • RCV_UPGRADE_STEPS

Tags: No Comments »