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
|
Hi, Sales Groupp id is not being populated in oe_sales_credits table when running order import concurrent program. I am passing sales_group_id in OE_CREDITS_IFACE_ALL table.
ReplyDelete