Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Month End Close with Oracle R12

Posted on June 22nd, 2009 by Sanjit Anand ||Email This Post Email This Post

Fig 1 below outlines the period end dependency for Oracle Payables, Oracle Purchasing, Oracle Inventory, Oracle Receivables, Oracle Assets, Oracle Order Management, Oracle Projects and Oracle General Ledger (Release 12).
Period Closure

Fig 1: Period Close dependecy among the modules

If you are coming from 11i then you might see beacuse of SLA there would be additional steps you need to perform.Fig 2 will be a quick compare of steps between two versions.

Period Closure1

Fig 2: Process and flow changes between two versions

In almost all modules the period end process consist of 5-6 major activity as:

  1. Completing the Transactions
  2. Creating Accounting
  3. Followed by Reconcile Transactions
  4. Post to GL
  5. Reconcile Accounting
  6. Close Period

You can check some of closure process & checklist from previous post :

 

Posted in Oracle General Ledger, Oracle Payable, Oracle Purchasing, Oracle Receivable, R12, Subledger Accounting | No Comments »

Encumbrance Accounting process flow in Oracle’s GENERAL LEDGER application

Posted on May 30th, 2009 by Sanjit Anand ||Email This Post Email This Post

Here is figure (Adopted from Chapter 3 of the Oracle General Ledger Users Guide shows the encumbrance accounting process with the budgetary control flag enabled:

The following flow chart explains the process followed during the encumbrance cycle. The encumbrances can be created in GL as well as from Payables and Purchasing.

Encumbrance Flow

  1. You need to enter encumbrances manually, if necessary. When you post encumbrance transactions, General Ledger automatically posts offset amounts to this account.
  2. Use MassAllocations to allocate encumbrances across cost centers, departments, and divisions. You need to enable Budgetary Control for your ledger to automatically create encumbrance entries from Oracle Purchasing and Oracle Payables
  3. Import encumbrances using Journal Import.
    • Open encumbrance years to enter and post encumbrance entries to future periods.Your initial encumbrance year is opened automatically when you open the first
      period for your ledger.
    • Remember , GL uses the last period of your latest open encumbrance year to determine how far to calculate your project-to-date encumbrance balances
  4. Enter encumbrances via Purchasing and Payables
    • Purchasing automatically creates unposted encumbrance entries for General Ledger when you approve a requisition or purchase order.
    • Payables automatically creates unposted encumbrance entries for General Ledger to encumber funds for purchase order variances and unmatched invoices. See: Encumbrance Entries in Payables, Oracle Payables User’s Guide.
    • General Ledger immediately updates your funds available when you reserve funds for your transactions in Purchasing and Payables. However, you must post your encumbrance entries to review funds available in Financial Statement Generator reports.
  5. Reserve funds for encumbrance entries to allow posting of encumbrances. To do so, do one of the following:
    • Reserve funds online in the Enter Encumbrances window. See: Entering Encumbrances, in the Oracle General Ledger Users Guide.
    • Reserve funds in batch mode by running the Mass Funds Check/Reservation program. See: Running the Mass Funds Check/Reservation Program, in the Oracle General Ledger Users Guide.
  6. You need to review unposted encumbrance journal entries online.
  7. Post encumbrances.
  8. Relieve encumbrances.
  9. Review funds available.
  10. Define and submit encumbrance reports using the FSG. or standard reports to review your encumbrance balances and activity. Such Reports limited to following:
    • Encumbrance Trial Balance Report
    • General Ledger Report
    • Account Analysis Report
  11. Perform year-end encumbrance processing.
  12. Carry forward year-end encumbrances.

Posted in Basic Accounting, Oracle Purchasing | No Comments »

Out of the box business events availability in Purchasing module

Posted on March 18th, 2009 by Sanjit Anand ||Email This Post Email This Post

I have searched in the application and noticed the following events availabile in Purchasing module.

1. These events are introduced for ASL integration with ERES. The ER documentation might have more info.

oracle.apps.po.asl.create -> PO ERES ASL Creation
oracle.apps.po.asl.update ->PO ERES ASL Update
oracle.apps.po.event.create_asl->Create New Approved Supplier List Entry
oracle.apps.po.event.update_asl ->Update Existing Approved Supplier List Entry

2. These events are launched during the XML Communication in PO Approval wf,after the PO is approved.

oracle.apps.po.event.setxml -> Set up PO via XML
oracle.apps.po.event.xmlpo
-> Send PO via XML
oracle.apps.po.event.xmlpogen
-> XML PO document is generated
oracle.apps.po.event.xmlposent
-> PO Sent via XML

3. These events are newly introduced for Change Requests and signature flow (11.5.9 – 11.5.10.CU2)

oracle.apps.po.buyersignature -> Buyer Signature Event
oracle.apps.po.suppliersignature -> Supplier Signature Event
oracle.apps.po.event.requester_change -> Requester change Request pending
oracle.apps.po.event.suppchnresp -> Response to Supplier Change Request Event
oracle.apps.po.event.supplier_change -> Supplier Change, and PO is Responded

4. OTM Event – These event is launched for OTM integration flow, to send the PO details to OTM.

oracle.apps.po.event.document_action_event -> Document Action Event

5. Receiving Events

oracle.apps.po.group.receive -> PO ERES Receiving Group Event
oracle.apps.po.line.receive -> PO ERES Receiving Line Event
oracle.apps.po.rcv.deliver -> PO ERES Receiving Delivery
oracle.apps.po.rcv.inspect -> PO ERES Receiving Inspection
oracle.apps.po.rcv.rcvtxn -> Receive Transaction
oracle.apps.po.rcv.transfer -> PO ERES Receiving Transfer

Hope this helps.

Posted in Oracle Purchasing | No Comments »

Encumbrance : Transactional Data Flow from PO to GL

Posted on March 12th, 2009 by Sanjit Anand ||Email This Post Email This Post

Here is basic data flow from the subledger (PO) to the Subledger Accounting module (SLA) to General Ledger (GL) in Context to R12.

arrow-up-3Upon reserving and approving PO:

  1. On reserving and approving the PO, encumbrance entries get generated in GL_BC_PACKETS with source_distribution_type as po_distributions_all and SOURCE_DISTRIBUTION_ID_NUM_1 as po_distribution_id.
  2. Encumbrance entries will also get generated in the table PO_BC_DISTRIBUTIONS which was introduced in R12. This table has the “reference4” and “reference3” columns where the PO/Req number and distribution id gets populated.
  3. It is recommended that you use the table PO_BC_DISTRIBUTIONS instead of GL_BC_PACKETS to view the encumbrance entries.
  4. Accounting entries created on reserving the PO can be viewed in the SLA menu in Purchasing.
    • Navigation: Purchasing > Accounting > SLA: User Main Menu > Journal Entries > query by transactions dates and ledger name
  5. The following accounting entries will be available for viewing:
    DR – Budget Account
    CR – Reserve for Encumbrance Account
  6. These accounting entries are populated in the XLA_AE_LINES. The event type code in XLA_AE_HEADERS for this Encumbrance entry is “PO_PA_RESERVED”.
    • The table PO_BC_DISTRIBUTIONS and XLA_AE_HEADERS are linked with the column “event_id”.
    • The table XLA_AE_HEADERS and GL_BC_PACKETS are linked with the column “ae_header_id”.
    • The table XLA_AE_HEADERS and XLA_AE_LINES are linked with the column “ae_header_id”.

The Concurrent Request Transfer Journal Entries to GL has to be submitted from Purchasing to transfer the encumbrance entries to GL.

arrow-up-3 Upon Receipt of goods or services:

  1. “On Receipt” and “Period-End” types of receipt accruals (for inventory or expense receipts) are processed through the GL_INTERFACE table. When a PO has Accrue on Receipt set to “Y”, the Receiving Transaction Processor generates the accounting entries in RCV_RECEIVING_SUB_LEDGER upon “Receipt and Deliver” of the PO.
  2. Then the Create Accounting-Receiving concurrent program has to be submitted from Purchasing to create SLA journals which will insert records in XLA_AE_HEADERS and XLA_AE_LINES.
  3. The Create Accounting-Receiving program will spawn another program called Create Accounting which will generate the entries in GL_INTERFACE.
    • There is an option to make the journal entry and post the journals automatically at the time of submitting the Create Accounting program itself. This option is used by setting the profile option SLA: Disable Journal Import to “NO”. This setting is preferred because it indicates that Journal Import will ALWAYS accompany the transfer of data from the subledger.
    • Another main implication of this value is that on failure of Journal Import, the data will be rolled back to SLA tables and hence, there will not be any data in GL_INTERFACE.
  4. Once the accounting is created for Receiving transactions in the Receiving subledger, the encumbrance reversal entry can be viewed in SLA menu in the Purchasing module, as well as in SLA menu in Costing.
    1. The following accounting entries will be available for viewing:
      DR – Reserve for Encumbrance Account
      CR – Budget Account
    2. These accounting entries will be available in the table XLA_AE_LINES. The event type code in XLA_AE_HEADERS for this encumbrance reversal entry is “DELIVER_EXPENSE” for Expense destination receipts and “PO_DEL_INV” for inventory destination receipts.

Take a note, In R12, Subledger Accounting (SLA) options have been introduced and accounting entries can be viewed at the SLA menu. As a part of Subledger Accounting, new SLA tables XLA_AE_HEADERS and XLA_JE_LINES have been introduced. Receiving Subledger is no longer directly linked to GL_JE_LINES. Instead, it is linked through the subledger tables XLA_AE_HEADERS and XLA_AE_LINES.

arrow-up-3Reconciliation and Troubleshooting

  • Encumbrance Account Details Report: Used for variances between the GL and subledger encumbrance balances & negative GL encumbrance balances.
  • Encumbrance Document Details Report : This report helps to identifies journal entry lines generated for a specified purchasing document.
  • Requisition/Purchase Order Distribution Detail Reports : This report identify documents that have failed budgetary control.
  • Open Encumbrance Balance with Transaction Detail Report : This reports summary balances and detailed source document information by account.

Posted in Oracle Purchasing | No Comments »

Accounting fundamentals for Techies : Encumbrance – Part II

Posted on March 4th, 2009 by Sanjit Anand ||Email This Post Email This Post

This post is answer of reader’s query which was pending from long time.

To elaborate in details , lets take sample case with two items.

accural method4

 

 

 

Emburance

Read the rest of this entry »

Posted in Basic Accounting, Oracle Purchasing | 2 Comments »

Oracle iSupplier portal – How its Works

Posted on January 9th, 2009 by Sanjit Anand ||Email This Post Email This Post

Oracle iSupplier Portal enables secure, self-service business transactions between companies and their suppliers provides suppliers with the ability to directly manage business transactions and access secure information

Key business flows Include:

  • Purchase Order Acknowledgement
  • Create Advance Shipment Notice and Advanced Shipment Billing Notice
  • Create Invoice

Core Functionality of this application are :

1) PO Collaboration

  • View and Acknowledge PO
  • Submit PO Change Requests and Split Shipments
  • Manage Deliverables
  • View agreements and PO revision history
  • Issue Work Confirmations

2) Shipment Notices

  • Inbound logistics
  • Plan the optimum route
  • You can view Delivery Schedules, receipt, returns and overdue receipts

3) Inventory

  • View item inventory Information like on-hand stock, item locations, lot and serials
  • Vendor Managed inventory – supplier manage their inventory at customer’s location
  • Consigned inventory – View on hand stock on consigned items as well as associated p2p transactions.

4) Supplier Management

  • Vendor registration
  • Supplier profile Management e.g. address, business classification, bank details, tax details, item, category etc.

5) Buyer’s Internal view

  • Provide all information which supplier view
  • Search information across all the suppliers
  • Search and view supplier items

6) For Invoice and Payments

  • This provides view the history and status of all invoices
  • This Provide view the history of all payments done

Check out at link for Oracle Datasheet .

Posted in Oracle Purchasing | No Comments »

iProcurement – How It Works

Posted on January 4th, 2009 by Sanjit Anand ||Email This Post Email This Post

Oracle iProcurement enables internal corporate requesters to independently order items from both local (internal) and remote (external) catalogs. It is the starting point for the ordering process and provides powerful self-service requisitioning capability with an intuitive, Web shopping interface.

It is a key component of Oracle Advanced Procurement, the integrated suite that dramatically cuts all supply management costs.

In an efficient and automated manner, Oracle iProcurement:

  • Constitutes a key component of the procure-to-pay business flow.
  • Helps an enterprise process and manage requisitions.
  • Helps an enterprise process and manage receipt of the requested goods or services.

As a part of Oracle Advanced Procurement, iProcurement

  • Delivers measurable savings
  • Reduced maverick spend
  • Greatly simplified process for purchasing goods and services
  • Requesters can quickly purchase the items they need with an easy to use interface that provides all the information they require to make purchases while directing them to preferred vendors and pricing
  • For purchasing managers iProcurement provides powerful tools for managing catalogs in real time, stores and content zones

If you are planning to implement this application, here are the Core features & functionality of this application, boardly divided under these heads.

1.Catalog Management

  • This Provides flexible solution to catalog and content management
  • Punchout / transparent Punchout feature will establish direct link to supplier’s web store to access their catalogs
  • This stores and provide a way for requesters to shop among a variety of catalog types and sources.
  • This provides a category and descriptor Management (Such as supplier and Price)
  • This also control on requester’s access based on categories, catalog sources and operating unit

2.Shopping

  • Configure stores to include any combination of local catalogs, punchout catalogs, informational catalogs, and transparent punchout catalogs.
  • Administrators can control which catalogs and stores are available to different classes of requesters.
  • Powerful search Capability
  • Shopping list- Create own favorite shopping list of frequently ordered items. Create public list that can be access by all requestor
  • Saved shopping carts- Create n number of shopping carts in progress.
  • Non Catalog request – Request for items and services which are not in catalog
  • Automatic document creation- Supplier PO contracts and quotation generate PO and releases accordingly without buyer’s intervention.
  • Center Led Procurement- Create global contract agreement and use it for all organization.

3. Checkout

  • Delivery
    • Provide options to stock delivery option like multiple destination types, delivered at one time addresses location.
    • This also integrated with Enterprise asset management
  • Billing
    • You can manage multiple account distribution and account generation workflow rules.
    • This is integrated with Oracle projects and Oracle Grants enables requesters to optionally reference projects, tasks, and award information about shopping cart order lines.
    • Encumbrance support lets user view funds online before submitting requisition.
  • Notes and attachments
    • This Provide additional information to approvers, buyers, suppliers, and receivers by attaching text, URLs, and other file types to the requisition.
  • Approvers
    • Approval and workflow setup determines the approver list for each requisition. During checkout, the requester can add approvers and change the first approver in the approver list. You can also customize it to meet your business needs.

4.Desktop Receiving

  • From their desktop, a requesters can receive internally and externally sourced items or the entire requisition.
  • View supplier advanced shipment notices (ASNs) as well as internal shipments
  • Workflow-driven receipt confirmation mechanism that proactively sends a notification to requesters to confirm receipt on the due date.

5.Requisition Tracking & Management

  • This enables you to track the status of all the requisitions and also Procure to Pay life cycle
  • This will keep real time notification keeps you up-to-date

If your compnay or Procurement dept looking option to simplify and automate company’s flow of ordering for Services,Refill for inventory,CIP , Opex, Capex Purchasing then this application will drastically reduce employee and bookkeeper time spent in procurement process.

Posted in Oracle Footprint, Oracle Purchasing | 1 Comment »

Evaluated Receipt Settlement

Posted on December 17th, 2008 by Sanjit Anand ||Email This Post Email This Post

Do you know , Evaluated Receipt Settlement (ERS) is a procedure for the automatic settlement of goods receipts. It was pioneered by General Motors (GM) to save the company time and money . Major benefits of ERS include invoice variance prevention , the elimination of non-value-added work (like tasks associated with reconciliation), and opportunity cost of capital savings.

dgreybarrow What is it?

ERS is a business process between trading partners that conduct commerce without invoices. In an ERS transaction, the supplier ships goods based upon an Advance Shipping Notice (ASN), and the purchaser, upon receipt, confirms the existence of a corresponding purchase order or contract, verifies the identity and quantity of the goods, and then pays the supplier.

dgreybarrow In A typical Real Life senaraios with client using ERP prefreably Oracle EBS Suite.

Evaluated Receipt Settlement (ERS), also known as “Invoice on Receipt” or “Pay on Receipt”, is a process whereby company creates a system invoice on behalf of the supplier for receipts booked against PO’s or BPA releases. The processes from invoicing to payment are thereby automated, reducing the level of human error and improving payments to suppliers.

dgreybarrow Benefits of ERS

  • Provide enhanced automation in the Procure to Pay Business flow
  • Automate invoicing for suppliers on BPA’s where multiple releases and shipment lines will be created
  • Automate invoicing for PO’s with multiple PO lines and multiple shipment lines
  • Less paperwork
  • Matching of the PO/BPA release to the invoice is done automatically, without any manual intervention required by AP
  • Elimination of blocked invoices
  • Elimination of manual data entry errors
  • No delay in payment due to “lost” Invoices
  • Supplier does not need to send paper invoices
  • Improved on-time payment of invoices due to fewer PO/Invoice discrepancies and invoices lost in the mail
  • Regular on-time payments

If your customer have ERS Suppliers that uses BPA for direct material supplies where goods can be accurately received , you can explore this options.

dgreybarrowA note with Oracle EBS Functionality

This feature is alternately known in Oracle User Guides as:Evaluated Receipt Settlement (ERS) or Payment on Receipt (POR) or Self-Billing Invoices (SBI)

dgreybarrow The Oracle Process

 

ERS

dgreybarrow How does it work in Oracle ?

Receipt transactions trigger invoice creation

  • Receipt
  • Delivery
  • Advance Shipment Notice
  • Advance Shipment and Billing Notice

Therefore , Depending on your business needs, you can use Pay on Receipt to automatically create invoices for:

  • All your vendors; or
  • Select vendors; or
  • Select Purchase Orders

Invoices are generated by running the Pay on Receipt AutoInvoice and Payables Open Interface Import processes.

Invoices move normally through Approval and Payment processes.

Process Returns with automatic Debit Memos that are matched to the original Purchase Order.

In such cases, Invoices are consolidated at one of the following levels:

  • Packing Slip – Triggers one invoice per packing slip
  • Receipt – Triggers one invoice per receipt
  • Supplier Pay Site – Triggers one invoice per supplier pay site

    Hope this helps. let me know , if you have any question. next Will discuss more on tax part of ERS.

Posted in Oracle Purchasing | No Comments »

Accounting fundamentals for Techies : Encumbrance

Posted on November 3rd, 2008 by Sanjit Anand ||Email This Post Email This Post

Before start of this topic you should be clear on these term;

  • Encumbrance
    This is your any pre-expenditure, such as a purchase order, which will lead to a charge against an account.
  • Commitment
    A journal entry you make to record an anticipated expenditure, as indicated by approval of a requisition.
  • Obligation
    An encumbrance you record when you turn a requisition into a purchase order.

dgreybarrow So…What Are Commitments?
Commitments are obligations for future expenditures made , and this should be for an employee or vendor PO’s. Commitments are tracked to help departments forecast their expenditures so that they do not exceed their budget available.

If you are using encumbrance you can get answer of these two question.

  • How much do I have left to spend?
  • Alert me if spending too much from allocated budget.

How much I left to spend , will be based out of these formula

Funds Available = Budget – Actual – Encumbrances.

budget is always unaltered, Encumbrances is reversed when matching to AP invoice.

dgreybarrow Oracle Vanilla encumbrance accountingBriefing

Oracle encumbrance accounting feature is supported by a process called funds reservation, which is implemented in the General Ledger as a user-exit or spawned program.

What is required if enabled Purchase Orders and Purchase Requisitions to first undergo a funds check when they are submitted. The system checks the line amount(s) of the requested purchase against the budget for the GL account(s) and alerts the user if that PO or Req. will exceed the funds on the account.This process of verification of available funds based on pre-defined summary templates.

Journals are then recorded in a special table called GL_BC_PACKETS, where they will sit temporarily before being converted by a concurrent process called “Program – Create journal” into permanent encumbrance journals.

The modules capable of initiating such transactions are the purchasing module for the creation of three documents, Standard Purchase Order, Requisition and Purchase Order Releases and the Accounts Payable module for the different invoices. It is possible to control the type of encumbrance created by these modules via the set-up of the applications.

The benefit of the encumbrance accounting feature is the ability to have the system control the expenditure budget from the General Ledger, reducing the risks of potential over expenditure.

This is often a legislated requirement for public organizations.

embubrance

The transactional flow has funds reservation being performed through the GL_BC_PACKETS table when reserving funds for purchasing documents, and through the GL_INTERFACE table for receipt accruals which can be either On Receipt or at Period End. The funds checker process takes place whenever funds reservation and/or adjustment is made.

After transactions have taken place in Purchasing, it will become necessary to run the Create Journals program in GL. This program essentially sweeps through the GL_BC_PACKETS table and creates journals for the entries as entered.

Essentially this process allows the different manager to understand their “funds available” based on the following formula.

Funds Available = Budget – Actual – Encumbrance

Emburence

The Oracle system has the ability to control this formula per fiscal period using the different balances tracked within GL_BALANCES (Essentially the General Ledger) by PTD (Period To Date), QTD (Quarter To Date), YTD (Year To Date),PJTD (Project To Date).

If you are coming from other Products like SAP or SUN , let clear these two terms in Oracle context in Project module specific.

  • Actual Transactions – Actual transactions are recorded project costs. Which may includes labor, expense report, usage, burden, and miscellaneous costs.
  • Commitment Transactions – Commitment transactions are anticipated project costs. Such examples include purchase requisitions and purchase orders or contract commitments.

dgreybarrowBasic Oracle Process

The basic process flow for encumbrance accounting activity related to Oracle Purchasing typically is as follows:

  1. Create a requisition.
  2. Approve and reserve funds for the requisition.
  3. AutoCreate requisition onto a purchase order.
  4. Approve and reserve PO (which automatically reverses the requisition funds reservation)
  5. Receive against the purchase order (either period-end or online accruals) and the funds are reversed for the amount received and entered against the charge account.

Take a note, funds reversal also occur when documents are cancelled or finally closed.

Requisitions, when autocreated onto a purchase order, have their funds reversed either when the PO is approved and reserved or when the requisition line(s) are rejected or returned.

dgreybarrowOracle Product associated with encumbrance

  • General Ledger
  • Purchasing
  • Payables
  • Projects
  • Grants

Next will see Accounting Treatment in encumbrance.

Posted in Basic Accounting, Oracle Purchasing | 2 Comments »

Oracle ASL-Sourcing

Posted on July 27th, 2008 by Sanjit Anand ||Email This Post Email This Post

For this topic, presuming you already aware of sourcing module of Purchasing family of Oracle EBS footprints.If you hear this first time, then next paragraph is meant for you.

Sourcing is a function with strategic importance within the broader context of procurement. Infact it is a subset of procurement with strategic context. Sourcing sets thestage for the entire company’s purchase for direct and indirect materials, and involveshighlevel, company-wide approaches to obtaining materials and services, identifying andevaluating potential suppliers to meet those needs, negotiating and implementingcontracts with selected suppliers, monitoring and improving ongoing supplier relationships.

Two important concept , sourcing rule and ASL .

dgreybarrow Sourcing Rule

Sourcing rules define inventory replenishment method for either a single organization or all organizations in the enterprise. They describe sourcing supply; for any organization,[Adopted user Documentation]

  • they answer the question “where do I get part A from?”
  • User defines rankings and % allocation for replenishment sources in the form of Sourcing Rules.

Assign sourcing Rules typically follow prioritity from Global to Item Orgnization sepecfic as below:

Global->Organization->Item Category->Item->Item Category-Organization->Item Organization

dgreybarrow ASL

All procurement organizations maintain lists that associate the items and services they buy from supplier organization.

Data stored in a global repository containing relevant details about each item/supplier/supplier site relationship, is known as an Approved Supplier List (ASL).

This repository includes information about all suppliers with business statuses ranging from ‘Approved’ (the supplier has demonstrated the ability to satisfy rigorous quality, cost, and delivery requirements over a sustained period) to ‘Debarred’ (the supplier is temporarily/permanently disallowed on purchase orders due to performance failure, ethics violations, etc.) or ‘New’ if you have never placed a purchase rorder with the supplier.

dgreybarrowWhy do we use ASL-Sourcing

This is because of three simple great reason, as

  • Automatically default supplier and pricing information onto Document Lines
  • Source the item from negotiated purchase agreements
  • Reduce manual intervention

dgreybarrow Which Other Products use Sourcing Rules

  • Purchasing
  • Planning
  • Supplier Scheduling
  • Supply Chain Planning

dgreybarrow How to start to utilize this function

In order to utilize this you have to perform these setup steps:

  • Define Item or category
  • Define Supplier/Supplier Site
  • Create Quote or Blanket Purchase agreement
  • Define ASL
  • Define Sourcing Rule
  • Assign Sourcing Rule to Assignment Set

dgreybarrow Conversion. Migratioon, Integration

If you are implementing First time, need to do conversion and other activity, What should be the best strategy for mass upload of Approved Supplier List and Sourcing Rule.Is there any API or interface to do the same?

This capability exists through the Purchasing Document Open Interface (PDOI).You can import Global Approved Supplier List(ASL) through the Purchasing Document Open Interface (PDOI)

Read this

Approved Supplier Lists (ASL)

dgreybarrow Table Used in ASL-Sourcing

Object Name Object Type Detail Description
PO_APPROVED_SUPPLIER_LIST Table This table stores the relationship between an item orcommodity; a supplier, distributor, or manufacturer; ship-to organizations; and approval/certification status
PO_ASL_ATTRIBUTES Table This table stores all information for thesupplier/item/organization relationship defined inPO_APPROVED_SUPPLIER_LIST. This informationis maintained separately to allow each organization to define its ownattributes, even if using a Global ASL entry for the supplier/item relationship and approval status
PO_ASL_DOCUMENTS Table This table stores sourcing references to supply agreements,blanket agreements, and catalog quotations associated with particular suppliers and items in PO_APPROVED_SUPPLIER_LIST
PO_ASL_STATUSES Table This table stores the user-defined approval/certification statuses forthe ASLs
PO_ASL_STATUS_RULES Table This table stores the business rules associated with each defined ASL status
MRP_SOURCING_RULES Table This table stores sourcing rule names and descriptions. The Define Sourcing Rule form populates this table
MRP_ASSIGNMENT_SETS Table This table stores information about Sourcing Assignment Sets.The Define Assignment Sets form populates this table
MRP_SR_ASSIGNMENTS Table This table stores the assignment of sourcing rulesor bills of distribution to items, organizations, category, orat the global level. The Assign Sourcing Rules Form populates this table
PO_ASL_ATTRIBUTES_VAL_V wiew This view used by the Create Documentsworkflow that is created from table PO_ASL_ATTRIBUTES and tablePO_APPROVED_SUPPLIER_LIST

Hope this helps.

Posted in Oracle Purchasing | No Comments »

« Previous Entries Next Entries »