Procure to Pay Cycle Query

PROCURE TO PAY QUERY WITHOUT RECEIPTS SELECT DISTINCT reqh.segment1 req_num, reqh.authorization_status req_status,                poh.segment1 po_num, pol.line_num,                poh.authorization_status po_status, i.invoice_num,                i.invoice_amount, i.amount_paid, i.vendor_id, v.vendor_name,                c.check_number, h.gl_transfer_flag, h.period_name           FROM ap_invoices_all i,               ...

Read more »

HZ tables in Oracle Receivables

This article describes few important HZ tables in AR and their relationships with each other.HZ_PARTIES:The HZ_PARTIES table stores basic information about parties that can be shared with any relationship that the party might establish with another party. The primary key for this table is PARTY_ID.Few Important Columns are   1. PARTY_ID: Party identifier   2. PARTY_NUMBER: Unique identification number for this party   3. PARTY_NAME: Name of the party   4..PARTY_TYPE: The party type can only be Person, Organization, Group or Relationship. HZ_PARTY_SITES:The HZ_PARTY_SITES table links a party (HZ_PARTIES) and a location...

Read more »

Oracle Purchasing Module Step by Step in R12

 All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle: RequisitionàRFQàQuotationà Quotation AnalysisàPurchasingàReceivingàInvoice à PaymentàReconciliation PO-Integration: PO is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO Responsibility             Step1: Define PO Responsibility                         Nav: System administratoràSecurityàResponsibilityàDefine             Step2: Assign PO options...

Read more »