Order-to-Cash flow

Order-to-Cash flow

Overview
CTO – Configure to Order
PTO – Pick to Order
ATO – Assemble to Order

ATP – Available to Promise
Order Fulfillment models
1.    Ship from stock
2.    Make to Order
3.    Internal Order
4.    Configure to Order, ATO, PTO
5.    Back to Back Orders
6.    Drop Ship to Customer

Standard Order to Cash flow
Ordering
1.    Starts with an Order Creation (Manual Entry or  Order Import)
Sales Order Form or Quick Sales Order form or OrderImport process or Process Order API

      Order Status:
      Order Line Status: Entered or Booked

      Check for the Availability and Pricing, Credit Rating

2.    Invoke the Pricing Request Engine to get the Selling Price (Advanced Pricing)

3.    Schedule the Order Lines

     Schedule – Line : Reserves the Demand, Sets the Shipment Schedule Date

     Create Supply: Sub flow paths based on the Type of the item shipped
         Configurable Items – Must complete the Create Supply activity which
                                        takes an Order Line to build cycle (WIP)
         Drop Ship Items - Must complete the Create Supply activity. After the
                                   Purchase order is raised advances to Shipping activity
         Standard Shippable Items – Directly advance to Shipping activity

     Ship Line: Changes the Order Line Status to Awaiting Shipment

*** Shipping Execution starts at this stage. Order Lines awaiting shipment are called Delivery Lines

4.    Pick Release Sales Order Lines (Deliveries)
     Delivery Lines must be ‘Ready to Release’

     Auto Pack (Shipping Transactions form) or Packing Workbench form –

    Release Sales Orders for Picking form or
    Shipping Transactions form (Launch Pick Release action) or
    Pick Release concurrent program or
    Pick Release API

5.    Confirm the Shipment
     Delivery Lines must be ‘Staged/Pick Confirmed’
     Quick Ship form

Changes the Order Line Status to Shipped

Collecting
6.    If the Ship Confirm is Successful then System decrements the Inventory and updates the Sales Order Line

7.    Invoke the Auto Invoice process to generate the Invoice in the Receivables System

8.    Collect the Payments in AR and apply against the Invoices

Accounting
9.    Receive the Statement and Reconcile the Bank Statement in Cash Management System
10. Post the Transactions to GL










Order Management

Overview
Order Creation Methods:
1.    Manual through Quick Sales Orders Form or Copy existing Orders
2.    Order Import Process through External Systems
3.    EDI – Electronic Data Interchange through Oracle e-Commerce Gateway
Ex: Internal Purchase Orders
4.    CRM suite (ex iStore, iSupport, Sales Online etc)

Defaulting Rules: Defaulting Rules are used to populate the Sales order with your customer’s preferences such as freight carrier and contacts, payment terms, price list and salesperson etc. You can create a set of Defaulting Rules for each entity on the Sales Orders window.
Setup > Rules > Defaulting

Processing Constraints: Processing constraints is a common security framework in Order Management where you can define and build security rules around sales entities
Setup > Rules > Security -> Processing Constraints

Order Category - ORDER, MIXED or RETURN
Order Transaction Type Code – LINE or ORDER
Transaction Types – Order Category + Transaction Type Code + Order Workflow + Document details + Pricing + Credit Check + Shipping + Auto Invoice defaults

Sales Order Attributes:
Order Types – (nothing but Transaction Types) can be used as a data source for defaulting rules and additionally determines both the order and line workflow processes your orders will flow

Sales Order Line Attributes:
Line Type -
Order Line Statuses-
1.    Entered – If few information like Payment Terms, Sales Person, Ship To Location Or Bill To Location is not entered
2.    Booked – If all the required information is entered
3.    Awaiting Shipping
4.    Picked
5.    Hold
6.    Shipped
7.    Invoiced
8.    Closed
Invoice Interface Line Status -
Open Interfaces
Order Import (OEOIMP) - Order Import can import new, changed, and completed sales orders or returns from other applications such as a legacy system (OE_ORDER_IMPORT_MAIN_PVT.ORDER_IMPORT_CONC_PGM)

OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL

OE_CUSTOMER_INFO_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_ACTIONS_IFACE_ALL (Operation Code: BOOK_ORDER, CREATE, etc)

High Volume Order Import (OEHVIMP) – To import the orders in Bulk
OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM

Receivables Interface (OE_INVOICE_WF.INVOICE_INTERFACE) – To collect order and return information and to populate the receivables Auto Invoice interface
OE_INVOICE_PUB.INTERFACE_HEADER/INTERFACE_LINE

Ship Confirm Open Interface – Mentioned in shipping execution

Public APIs
OE_ORDER_PUB.PROCESS_ORDER -> Process Order
Transaction Tables
Setup:
OE_ORDER_SOURCES
OE_TRANSACTION_TYPES_VL

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL

OE_PRICE_ADJUSTMENTS
OE_ORDER_PRICE_ATTRIBS
OE_PRICE_ADJ_ATTRIBS
OE_PRICE_ADJ_ASSOCS
OE_SALES_CREDITS
OE_LOT_SERIAL_NUMBERS

Processes
Order Import Statistics

Cancel Orders (OEMCEO – Spawned)
Close Orders (OEOCSO – Spawned)
Copy Orders Validation (OEXCPVAL – PL/SQL)
Order Purge (Order Purge – PL/SQL)
OrderImport (OEOBOE – Spawned)

Schedule Orders
Forms
Setup:
Order Import Sources – Order Import Source, Enabled
Order Types

Order Organizer
Sales Orders
(Uses the Workflow Activity - OE_ORDER_IMPORT_WF)

Quick Order Organizer
Quick Sales Orders

Pricing and Availability
Reports
Unbooked Orders Report (OEXOEUBK)







Advanced Pricing

Overview
Price Lists –
Price Agreements –
Price Modifiers – Price Actions that can be used to adjust the list price
Price Qualifiers – Determine Eligibility rules & Determine who receives the price benefits
Price Formulas –
Price Attributes/Product Attributes/Qualifier Attributes –
Freight and Special Charges

Interface Tables
QP: Bulk Import of Price List Concurrent Program(QPXVBLK)
  QP_INTERFACE_LIST_HEADERS - Captures the Price List header data
  QP_INTERFACE_LIST_LINES – Captures the Price list line data
  QP_INTERFACE_QUALIFIERS: Contains the header qualifiers associated
                                              with the price lists to be imported
  QP_INTERFACE_PRICING_ATTRIBS: The product and pricing attributes data
                                              is captured in this table
Public APIs
Price List Setup API: QP_PRICE_LIST_PUB
  PROCESS_PRICE_LIST- API to insert, update and delete price lists and to set up a price list for a given P_PRICE_LIST_REC record structure. Takes two record types and six table types as input parameters

Custom Price API: QP_CUSTOM
  GET_CUSTOM_PRICE

Pricing Engine API: QP_PREQ_GRP
Transaction Tables
Setup:
QP_PRICING_PHASES
QP_EVENT_PHASES

QP_PRICE_REQ_SOURCES
QP_PTE_REQUEST_TYPES_B
QP_PTE_SEGMENTS
QP_PTE_SOURCE_SYSTEMS

Transaction:
QP_PRICING_ATTRIBUTES

QP_LIST_HEADERS
QP_LIST_LINES

QP_PRICE_FORMULAS_B
QP_PRICE_FORMULA_LINES

OE_AGREEMENTS_B
QP_QUALIFIERS
Processes

Forms

Reports

Profiles
QP: Get Custom Price Customized
QP: Batch Size for Bulk Import
QP: Break UOM Proration Allowed
QP: Pricing Transaction Entity





Shipping Execution (WSH)

Overview
Two main Shipping Processes
1.    Pick Release process
2.    Ship Confirm Process

Trips:
Stops:
Deliveries:
Containers:
Ship Method:
Interface Tables
Delivery–based Ship Confirm Open Interface:

WSH_DELIVERIES_INTERFACE
WSH_PICKING_DETAILS_INTERFACE
WSH_PACKED_CONTAINER_INTERFACE
WSH_FREIGHT_CHARGES_INTERFACE

WSH_DELIVERIES_INTERFACE       <-> WSH_DELIVERIES_PUB.DELIVERY_ACTION and WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY

WSH_PICKING_DETAILS_INTERFACE  <-> WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES

WSH_PACKED_CONTAINER_INTERFACE <-> WSH_CONTAINER_PUB.CREATE_CONTAINERS

WSH_FREIGHT_CHARGES_INTERFACE  <-> WSH_FREIGHT_COSTS_PUB.CREATE_UPDATE_FREIGHT_COSTS



Public APIs

Trips API (WSH_TRIPS_PUB)
  CREATE_UPDATE_TRIP - Create and update trip records
  TRIP_ACTION - Perform actions on trips. Action Codes are PLAN,UNPLAN,DELETE,WT-VOL,PICK-RELEASE

Stops API (WSH_TRIP_STOPS_PUB)
  CREATE_UPDATE_STOP - Create and update stop records
  STOP_ACTION - Action Codes are PLAN,UNPLAN,ARRIVE,CLOSE,DELETE,PICK-RELEASE

Deliveries API (WSH_DELIVERIES_PUB)
  CREATE_UPDATE_DELIVERIES -> Create or Update deliveries(trip stop records)
  DELIVERY_ACTION - Perform actions on deliveries (PLAN,UNPLAN,DELETE,WT-VOL,PICKRELEASE,RE-OPEN,CLOSE)
  DELIVERY_ACTION - Assign and un assign deliveries to and from trips and stops (ASSIGN-TRIP,UNASSIGNTRIP,AUTOCREATE-TRIP (For ASSIGN-TRIP, provide trip name)
  DELIVERY_ACTION - Ship confirm deliveries (CONFIRM - Provide actual ship date)

Delivery Details API (WSH_DELIVERY_DETAILS_PUB)
  DETAIL_TO_DELIVERY -> Assign and un assign delivery lines to and from deliveries
  SPLIT_LINE -> Split delivery lines
  UPDATE_SHIPPING_ATTRIBUTES -> Confirm actual shipped quantities
  AUTOCREATE_DELIVERIES -> Auto-create deliveries
  AUTOCREATE_DEL_TRIP -> Auto-create deliveries and trips

Container APIs (WSH_CONTAINER_PUB)
  CREATE_CONTAINERS - Create containers
  UPDATE_CONTAINER -> Update containers
  CONTAINER_ACTIONS - Pack and unpack delivery lines into containers (PACK,UNPACK)
  CONTAINER_ACTIONS - Assign and un assign containers to deliveries (ASSIGN,UNASSIGN)
  AUTO_PACK -> Create containers and auto-pack

Freight Cost APIs (WSH_FREIGHT_COSTS_PUB): Create freight cost records, update freight cost records, validate freight cost types, delete freight cost records
CREATE_UPDATE_FREIGHT_COST
VALIDATE_FREIGHT_COST_TYPE
DELETE_FREIGHT_COSTS

Exceptions API: WSH_EXCEPTIONS_PUB
EXCEPTION_ACTION - procedure enables you to carry out actions on an exception
GET_EXCEPTIONS  - gets the exceptions based on the entity name (‘DELIVERY’, ‘TRIP’, ‘STOP’,’CONTAINER’ and ‘DETAIL’)

Pick Release API (WSH_PICKING_BATCHES_PUB)
CREATE_BATCH - Enables you to create a new pick release batch
RELEASE_BATCH - Enables you to release a batch

Transaction Tables
WSH_TRIPS
WSH_TRIP_STOPS
WSH_NEW_DELIVERIES
WSH_DELIVERY_DETAILS
WSH_FREIGHT_COSTS
WSH_EXCEPTION

WSH_PICKING_BATCHES
WSH_PICKING_RULES
WSH_PICK_SEQUENCE_RULES
WSH_PICK_GROUPING_RULES
Processes
Process Delivery SRS
Release Sales Orders SRS
Ship Confirm Deliveries SRS
Import Delivery Lines
Forms
Shipping Transaction Form (Shipping -> Transactions)

Create LPNs (License Plate Numbers)
Packing Workbench form

Release Sequence Rules form (Shipping -> Setup -> Picking -> )
Pick Slip Group Rules form (Shipping -> Setup -> Picking ->)
Define Release Rules form (Shipping -> Setup -> Picking ->)
Release Sales Orders for Picking (Shipping -> Release Sales Orders ->)

Ship Confirm Rules form (Shipping -> Setup -> )
Quick Ship form (Shipping -> Quick ship)
Shipping Parameters form
Global Shipping Parameters form

Define Shipping Exceptions (Shipping -> Setup -> )
View Exceptions (Shipping -> Exceptions)

Reports






Account Receivables

Overview
Auto Accounting - Specify how you want Receivables to determine the general ledger accounts for transactions that you enter manually or import using Auto Invoice. Revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, bills receivables accounts, and Auto Invoice clearing (suspense) accounts

Accounting Rules - Accounting rules determine the accounting period(s) in which the revenue distributions for an invoice line are recorded

Invoice Rules – Invoicing rules determine the accounting period in which the receivable amount is recorded

Receipt Class – Creation Method, Remittance Method, Clearance Method, Require Confirmation, Payment Method

Receipt Source – Receipt Source Type, Receipt Class, Batch Numbering

Freight Terms -
Payment Term –
Transaction Class – Invoices, Credit memos, Debit memos, Charge backs, Guarantees, Deposits

AR Transaction Types – Transaction Class, Print Option, Transaction Status, Payment Terms, Accounts

Transaction Sources –

Open Interfaces
AutoInvoice Import Program (RAXTRX) – To import invoices, credit memos, debit memos and on-account credits

RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
AR_INTERFACE_CONTS_ALL
RA_INTERFACE_ERRORS_ALL

Lockbox Interface – For processing bank receipts and conversion of historical data
AR_PAYMENTS_INTERFACE_ALL
Interim Quick Cash tables:
AR_INTERIM_CASH_RECEIPTS_ALL
AR_INTERIM_CASH_RCPT_LINES_ALL

Sales Tax Rates Interface – Load Sales Tax information from feeder systems

Tax Vendor Extension -

Public APIs
AR System Initialization Packages
  DBMS_APPLICATION_INFO.SET_CLIENT_INFO - To set the ORG context
  ARP_GLOBAL.INIT_GLOBAL: For setting public variables
  ARP_STANDARD.INIT_STANDARD: For setting public variables

AR Adjustment Public API: AR_ADJUST_PUB
  CREATE_ADJUSTMENT  - To create an adjustment for an invoice
  MODIFY_ADJUSTMENT  - To modify an adjustment’s status, comments, and reason code
  APPROVE_ADJUSTMENT - To approve an adjustment
  REVERSE_ADJUSTMENT - To reverse an adjustment

Credit Memo Approval and Creation API: AR_CREDIT_MEMO_API_PUB
  CREATE_REQUEST ROUTINE - To initiate the Credit Memo Request workflow process by making a credit memo workflow request
  GET_REQUEST_STATUS - To view the status of an existing request

Credit Memo Application API: AR_CM_APPLICATION_PUB
  ACTIVITY_APPLICATION - Applies an on-account credit memo to an activity
  ACTIVITY_UNAPPLICATION – Un applies an on-account credit memo from an activity

AR Deposit  API: AR_DEPOSIT_API_PUB
  CREATE_DEPOSIT - Creates a single deposit and completes it
  INSERT_NON_REV_SALESCREDIT - Creates non-revenue sales credit for a deposit

AR Invoice Creation Public API: AR_INVOICE_API_PUB
  CREATE_INVOICE - Creates multiple invoices in a batch. Populate four global temporary tables for Header, Lines, Distributions and Sales Credits
  CREATE_SINGLE_INVOICE: Create a single invoice and return customer_trx_id

AR Prepayments API: AR_PREPAYMENTS_PUB
  CREATE_PREPAYMENT - Use this routine to create a prepayment receipt
  GET_INSTALLMENT - Use this routine to calculate the amount of all installments of a given payment term

AR Receipt Creation Public API: AR_RECEIPT_API_PUB
  CREATE_CASH - Creates a single cash receipt, as in the case of manually created cash receipts
  CREATE_MISC - Creates a single miscellaneous receipt
  REVERSE - Reverses the specified receipt

  APPLY - Applies a cash receipt to a particular installment of a debit item
  CREATE_AND_APPLY - Creates a cash receipt and applies it to a specified installment of a debit item in one pass
  UNAPPLY – Un applies the application of a particular installment of a debit item against the specified cash receipt

  APPLY_ON_ACCOUNT - Creates an on-account application for a cash receipt
  UNAPPLY_ON_ACCOUNT – Un applies the on-account application on the specified receipt

  ACTIVITY_APPLICATION - Applies to an activity, such as Receipt Write-off
  ACTIVITY_UNAPPLICATION – Un applies from an activity, such as a Receipt Write-off

  APPLY_OTHER_ACCOUNT - Applies to other account activities, such as Claim Investigation (for Trade Management customers only)
  UNAPPLY_OTHER_ACCOUNT – Un applies from other account activities, such as Claim Investigation

  APPLY_OPEN_RECEIPT - Creates a receipt-to-receipt application (payment netting)
  UNAPPLY_OPEN_RECEIPT – Un applies a receipt-to-receipt application
Transaction Tables
Setup:
AR_RECEIPT_CLASSES -> Receipt classes
AR_RECEIPT_METHODS -> Receipt methods
AR_BATCH_SOURCES   -> Receipt sources
AR_RECEIVABLES_TRX -> Receivables activities

Receipts Tables:
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_APPLICATIONS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
AR_PAYMENT_SCHEDULES
AR_DISTRIBUTIONS

Invoice Tables:
RA_BATCHES_ALL
RA_CUSTOMER_TRX _ALL
RA_CUSTOMER_TRX_LINES _ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_ADJUSTMENTS_ALL

Archive/Purge Tables:
AR_ARCHIVE_HEADER
AR_ARCHIVE_DETAIL
AR_ARCHIVE_PURGE_INTERIM
AR_ARCHIVE_CONTROL

Document Sequences:
FND_DOC_SEQUENCE_USERS
FND_DOCUMENT_SEQUENCES
FND_DOC_SEQUENCE_ASSIGNMENTS
Processes
Auto Invoice Purge program

Archive and Purge Program

Auto Lockbox Program
   Import Step - Import the data from the Bank file to Lockbox Interface table
   Validate Step - Transfers receipt data from Lockbox interface table to Quick Cash tables
   Post Quick Cash Step - Transfers data from Quick Cash tables to Receivables system tables
Forms
Transactions Setup:

Payment Terms – Terms of Payment like Discounts (ex: 30 Net)
Transaction Types – Invoice, Credit Memo, Debit Memo etc.
Transaction Sources – Manual or Imported
Transaction Batches – Manual type of Transaction Sources

AutoAccounting – Account Type, Segment, Table Name, Constant
Invoicing and Accounting Rules Form - Type, Active, Period, Number of Periods
AutoInvoice Grouping Rules Form - Line Ordering Rule, Transaction Class, Optional Grouping Characteristics
AutoInvoice Line Ordering Rules - Name, Order by Sequence, Order by Transaction Attribute, Type (asc, desc)

AutoInvoice Interface Exceptions
AutoInvoice Interface Lines

Transactions:

Transactions Summary Form
Transactions Form
Credit Transactions Form
Copy Transactions Form

Receipts Setup:

Profiles
AR: Transaction Batch Source
AR: Change Customer on Transaction
AR: Allow update on existing Sales Credits
AR: Use Invoice Accounting for Credit Memos
AR: Override Adjustment Activity Account Option
AR: Default Exchange Rate Type


Trading Community Architecture (TCA)

Overview

Open Interfaces
Import Batch to TCA Registry program:
(Only at Party Level)

Loading Data into the Interface Tables: You can load data through:
SQL/ETL Load: Create scripts or use tools to extract the source information, transform the values to meet the data requirements of the interface tables
D&B Load: Use the standard D&B bulk file that you receive from D&B and run the D&B Import Adapter request set to automatically map and load the D&B
information into the interface tables
File Load: Use Oracle Customers Online (OCO) or Oracle Data Librarian (ODL) to load data from a comma-separated value (CSV) file, or file delimited by
another allowed character, into the interface tables

HZ_IMP_PARTIES_INT
HZ_IMP_CONTACTS_INT
HZ_IMP_ADDRESES_INT
HZ_IMP_ADDRESSUSES_INT
HZ_IMP_CONTACTPTS_INT
HZ_IMP_CONTACTROLES_INT

HZ_IMP_FINREPORTS_INT
HZ_IMP_FINNUMBERS_INT

AR Customer Interface Program – (RACUST: Spawned Process) To Import and validate current and historical customer information
(At Party and Customer Level)

RA_CUSTOMERS_INTERFACE_ALL - Stores customer, address, and business purpose information
RA_CUSTOMER_PROFILES_INTERFACE - Stores customer profile information
RA_CUST_PAY_METHOD_INTERFACE - Stores payment method information for a customer or for a specific Bill-To address
RA_CUSTOMER_BANKS_INTERFACE - Stores bank information for a customer or for a specific Bill-To address
RA_CONTACT_PHONES_INTERFACE

APIs
Organization Party API:
HZ_PARTY_V2PUB.CREATE_ORGANIZATION / UPDATE_ORGANIZATION

Tables:
HZ_PARTIES (Party type as ORGANIZATION)
HZ_ORGANIZATION_PROFILES
HZ_ORIG_SYS_REFERENCES

Person Party API:

HZ_PARTY_V2PUB.CREATE_PERSON / UPDATE_PERSON
Tables:
HZ_PARTIES (Party type as PERSON)
HZ_PERSON_PROFILES
HZ_ORIG_SYS_REFERENCES

Group Party API:

HZ_PARTY_V2PUB.CREATE_GROUP / UPDATE_GROUP
Tables:
HZ_PARTIES (Party type as GROUP)
HZ_ORIG_SYS_REFERENCES

Party Info (Credit Ratings) API:

HZ_PARTY_INFO_V2PUB.CREATE_CREDIT_RATING
Tables:
HZ_CREDIT_RATINGS

Party Contacts API & Party Contact Roles API:
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT
Tables: HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT_ROLE
Table: HZ_ORG_CONTACT_ROLES

Party Site API & Party Site Use API:
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
Table: HZ_PARTY_SITES

HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
Table: HZ_PARTY_SITE_USES

Locations API
HZ_LOCATION_V2PUB.CREATE_LOCATION / UPDATE_LOCATION
Tables:
HZ_LOCATIONS

Contact Points API
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT / CREATE_EDI_CONTACT_POINT / CREATE_EMAIL_CONTACT_POINT
Tables:
HZ_CONTACT_POINTS
The supported types of contact points are PHONE, PAGER, EMAIL, TELEX, WEB, EFT, and EDI

Relationship Type, Relationship, and Hierarchy Retrieval APIs
HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE
TABLE: HZ_RELATIONSHIP_TYPES

HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP
TABLE: HZ_RELATIONSHIPS

HZ_HIERARCHY_V2PUB.CHECK_PARENT_CHILD

Customer Account API:
HZ_CUST_ACCOUNT_V2PUB

Account Site & Site Use APIs:
HZ_CUST_ACCOUNT_SITE_V2PUB


Transaction Tables
Customer Interface Tables:

• HZ_PARTIES
• HZ_PARTY_SITES
• HZ_PERSON_PROFILES
   HZ_CONTACT_POINTS
• HZ_LOCATIONS
• HZ_ORG_CONTACTS

• HZ_CUST_ACCT_RELATE_ALL
• HZ_CUST_ACCT_ROLES
• HZ_CUST_ACCT_SITES_ALL
• HZ_CUST_ACCOUNTS
• HZ_CUST_PROFILE_AMTS
• RA_CUST_RECEIPT_METHODS
• HZ_CUST_SITE_USES_ALL
• HZ_CUSTOMER_PROFILES
• AP_BANK_ACCOUNT_USES
• AP_BANK_ACCOUNTS
• AP_BANK_BRANCHES


General Ledger

Overview
General Ledger is the central repository for the accounting information, receiving transaction from all sub ledgers

Primary functions of General Ledger are,
Journal Entries
Budget Creation
Account Balances

Each Numerical Value in GL must fall into one of three categories:
Actuals
Budgets
Encumbrances

Payables post the Transactions of Type:
Payments & Invoices

Receivables post the Transactions of Type:
Receipts, Invoices, Credit Memos, Debit Memos, On-account Credits,
Adjustments, Guarantees, charge backs, deposits etc.

Financial Statement Generator (FSG) - It is a powerful report building tool for Oracle General Ledger. With FSG,
1) Generate financial reports, such as income statements and balance sheets, based upon data in your general ledger
2) Generate presentation quality financial reports with XML Publisher
3) Schedule reports to run automatically
4) General Ledger standard accounting reports and listings include Trial balances, Journals, General ledgers, Account analysis reports, Chart of account listings etc

Open Interfaces
GL Journal Import Interface
GL_INTERFACE_CONTROL
GL_INTERFACE

GL Daily Rates Interface
GL_DAILY_RATES_INTERFACE – Database triggers are defined on this table to automatically insert the data into setup table, GL_DAILY_RATES

GL Budget Interface
GL_BUDGET_INTERFACE - Budget upload (ex: ADI, SQL Loader)

Public APIs
-
Transaction Tables
Setup
GL_JE_CATEGORIES
GL_JE_SOURCES
GL_DAILY_RATES

Set of Books
GL_PERIOD_STATUSES
GL_PERIODS
GL_PERIOD_SETS
FND_CURRENCIES
FND_FLEX_ID_STRUCTURES
GL_CODE_COMBINATIONS
GL_SETS_OF_BOOKS

Journals
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES

Budget
GL_BUDGETS
GL_BUDGET_VERSIONS
GL_BUSGET_ENTITIES
GL_BUDGET_ASSIGNMENTS

Balances
GL_BALANCES

Processes
Journal Import Process
Post Journals Process

Forms


Install Base

Overview

Interface Tables

Public APIs
The APIs provided for the new Install Base are organized into the following packages

CSI_DATASTRUCTURES_PUB: Contains all public data structures exposed to Install Base API users

CSI_ITEM_INSTANCE_PUB: Contains all APIs for item instance management.
Create_Item_Instance / Update_Item_Instance / Expire_Item_Instance

CSI_INSTANCE_RELATIONSHIP_PUB: Contains all APIs to manage instance-to-instance relationships (instance configuration)
Create_Relationship

CSI_SYSTEMS_PUB: Contains APIs for creating, updating and deleting the systems
Create_System
Transaction Tables
CSI_INSTANCE_INTERFACE
CSI_II_RELATIONSHIPS
CSI_SYSTEMS_B

CSI_I_PRICING_ATTRIBS
CSI_TRANSACTIONS
CSI_ITEM_INSTANCES
*/