Search This Blog

Tuesday, January 26, 2010

List of Receipts API in Oracle Receivables

Below is the list of some of the Receipt API's in Oracle Receivables. Receipt APIs provide an extension to existing functionality for creating and manipulating receipts through standard AR Receipts forms and lockboxes.

AR_RECEIPT_API_PUB is the main package that has several procedures to perform different actions

Use this procedure to apply or unaply respectively, the cash receipts from a customer to an invoice, debit memo, or other debit item .
Use this procedure to apply or unapply a cash receipt on account.
To apply or unapply a cash receipt to another open receipt.
Procedure to create a single cash receipt for payment received in the form of a check or cash.
Procedure to reverse cash and miscellaneous receipts

In later post I will try to explain in detail how to use each API and the impact of same in application.

Thursday, January 21, 2010

For BI Publisher Reports, cannot view Barcodes when previewed output in PDF

Based on question from one of our reader here are the steps to view the barcode fonts when the report is previewed in PDF format from .rtf file.

The problem here is that the fonts are correctly installed in computer but when output is previewed instead of barcodes actual text is seen. One of the possible reason for this could be that the xdo.cfg file is not configured correctly. Below are the steps

1) Copy Barcode font in C:\Windows\Fonts directory.
2) Copy xdo.cfg in C:\Program Files\Oracle\XML Publisher Desktop\Template Builder for Word\config directory. The sample file is already available when BI Publisher desktop is installed.
3) Right click the font file and go to properties. Copy the .ttf file name. Double click the font file to get the family name.
4) Open the xdo.cfg file and paste as follows (My filename is FRE3OF9X.ttf and font family is Free 3 of 9 Extended)

[font family="Free 3 of 9 Extended" style="normal" weight="normal"]
[truetype path="C:\Windows\fonts\FRE3OF9X.ttf" /]
Note: replace brackets([ & ]) with angle brackets as was unable to paste due to HTML restriction in comments. There should be sample already available in the xdo.cfg file.

5) Try your report should work fine and barcodes should be correctly displayed.

Related Post:
Using 3 of 9 Barcodes in XML Publisher
View Barcode in XML Publisher report when run from Application

Keywords: Code 39, Barcode 39, 3 of 9 Barcodes

Tuesday, January 19, 2010

Types of Purchase Orders

Different types of purchase order in Oracle
Standard Purchase Order: A standard purchase orders is generally created for one–time purchase of various items. Standard purchase orders is created when we know the details of the goods or services we require, estimated costs, quantities, delivery schedules, and accounting distributions.

Blanket Purchase Agreements: A blanket purchase agreements are created when we know the detail of the goods or services we plan to buy from a specific supplier in a period, but we do not yet know the detail of your delivery schedules. Blanket purchase agreements can be used to specify negotiated prices for items before actually purchasing them. Blanket purchase agreements can be created for a single organization or to be shared by different business units of organization (global agreements).

Blanket Releases: A blanket release is issued against a blanket purchase agreement to
place the actual order (as long as the release is within the blanket agreement effectivity dates).

Contract Purchase Agreements: A contract purchase agreement is an agreement between buyer and a supplier for unspecified goods or services. This agreement may include terms and conditions, amount, and effective dates. Later Standard Purchase orders can be issued based on the agreements decided.

Planned Purchase Orders: A planned purchase order is a long–term agreement committing to buy items or services from a single source. Tentative delivery schedules and all other details like item, price, quantity is specified in planned purchase orders. We can issue scheduled releases against planned purchase order to create standard purchase orders.

Wednesday, January 13, 2010

Types of Discrete Jobs in WIP

There are 2 types of discrete Jobs
1) Standard - Standard discrete jobs are used to manufacture a brand new product using Bill of Materials and Routings. E.g. There is a demand in the sales order for an Assembly item which in turn creates a WIP Job. For this case standard discrete job will be created.
2) Non-Standard - Non Standard discrete jobs are mostly used to repair a defective item. E.g. A product is returned by the customer for some defective reason. For this item a non-standard job is created and item is refurbished.

Copyright (c) All rights reserved. Presented by Suresh Vaishya