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

Tired of the Invoice Pile? Think “Consolidated Billing Invoice”

Posted on September 10th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

The Consolidated Billing Invoice works in similar way that Statement Generation program works. The Consolidated Billing Invoice program lets you print a single, monthly invoice that includes all of your customer's transactions for the period . This will you send one consolidated billing invoice instead of a separate invoice for each transaction. For each bill to site one Consolidated bill will be generated.

dgreybarrow-2Other Oracle Vanilla Features of Consolidated Billing Invoice are:

  • You can print a single, monthly bill that includes all of a customer's transactions for the period. Consolidated Billing Invoice is normally generated at the Bill-To location level. A Consolidated Billing Invoice itemizes only Invoices, Credit memo and adjustment.
  • Consolidated Billing Invoice also have details for receipts in summarized form.
  • Customer qualified consolidated billing invoice are selected by the Cutoff date and payment terms.
  • Consolidated Billing Invoice does not includes aging.

These are bit different from Statement .

Read the rest of this entry »

Posted in Oracle Receivable | 3 Comments »

A Newbie’s Guide to E-Business Suite Integration (by Custom Code using API’S!”)

Posted on September 8th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

questionHow can we Integrate OracleApps with Custom code by using public API's? What skill is required for E-Business Suite Integration with API's?

These are the question asked by someone who never exposed to OracleApps development environment.

This was topic I discussed with client IT department folks which includes people who recently inducted in Oracle Group from other technology area, college pass outs and other group like Middleware who are also responsible to putting some nut and bolts in Oracle.Thoughts to convert this in post for newbie and Inhouse IT folks who always struggling for right information for the API Integration.So here to go:

dgreybarrow-2Important Points for those working first time with API's

  • First and foremost Important, you need to understand API Definition, which includes purpose, input parameter, output parameter, in/out parameter as well as default values for parameter
  • Next is mapping : This is where you map input data from source/staging/temp table to input parameter
  • Next is development of code , you should use cursor/temporary table to load data from user's table and use Debugging information to detect and diagnose errors.

Read the rest of this entry »

Posted in API Integration | 5 Comments »

AR Adjustments : Details,setup, Flow, Accounting and API

Posted on September 5th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

An Adjustment in AR is an amount added or subtracted from the amount due of an Invoice, Debit Memo, Chargeback, Deposit, or Guarantee.

Oracle AR lets you create Automatic or Manual Adjustments.

Read the rest of this entry »

Posted in Oracle Receivable | 1 Comment »

AR Adjustments : Details,setup, Flow, Accounting and API (Part -II)

Posted on September 5th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

As mention in last post These adjustment API available in R11i and R12 with basic functionality via different API calls:

  1. Creating an adjustment (R11i & R12)
  2. Modifying an adjustment (R11i & R12)
  3. Approving an adjustment (R11i & R12)
  4. Reversing an adjustment (R11i & R12)
  5. Create line level adjustment (This is only applicable in case of R12)

dgreybarrow-2 Details of Five Adjustment API's are herewith:

  1. AR_ADJUST_PUB.CREATE_ADJUSTMENT : This routine can be used to create an adjustment for an invoice
  2. AR_ADJUST_PUB.MODIFY_ADJUSTMENT : This routine can be used to modify an adjustment's status, comments and reason code .
  3. AR_ADJUST_PUB.APPROVE_ADJUSTMENT : This routine can be used to approve an adjustment
  4. AR_ADJUST_PUB.REVERSE_ADJUSTMENT: This routine can be used to reverse an adjustment
  5. AR_ADJUST_PUB.CREATE_LINELEVEL_ADJUSTMENT: This Routine can be used to allow user to do line level adjustment. This is only specific to R12 .

dgreybarrow-2 While Choosing API..Do not get confused with Revenue Adjustment API's

There is difference between Revenue Adjustment API and Adjustment API, unless until you are not very familiar about the functional aspect of revenue recognition.

The Revenue Adjustment API provides an extension to the existing functionality of adjusting Revenue and Sales Credits through the standard AR (Accounting Receivables) Revenue Management form.

In Receivables, it is now possible to defer Revenue Recognition , and to earn the Revenue at a later date using the Revenue Adjustment. In this process, the API uses Auto Accounting to determine the accounts to be debited/credited with each operation. Sounds good...

Read the rest of this entry »

Posted in Oracle Receivable | 1 Comment »

AR Adjustments : API – Sample code

Posted on September 5th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is sample code that you can use for creating adjustment.This is tested while integrating with POS -Oracle Integration.

Read the rest of this entry »

Posted in Oracle Receivable | No Comments »

AR Deposit : Details, setup, Flow, Accounting and API

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

Oracle AR supports two types of commitments:

  • Deposit – This records a customer’s prepayment for goods or services that you will provide in the future.
  • Guarantee : This records a contractual agreement with your customer to conduct a specific amount of business over a defined period of time.

Read the rest of this entry »

Posted in Oracle Receivable | 4 Comments »

AR Invoice API (Application Program Interface )

Posted on September 1st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

AR Invoice API allows users to create an invoice using simple calls to PL/SQL functions. The Invoice Creation API is another options for Transaction creation does not mean replacement of Transaction workbench, AutoInvoice, or the Transaction API program.

dgreybarrowWith this API's you can manage

  • Single or multiple invoice(s) creation when you required
  • This will extensive defaulting which minimizes the programming effort
  • Validation ensures quality data
  • You can use debug messages in a central repository that improves coding efficiency
  • You can get immediate results

Read the rest of this entry »

Posted in Oracle Receivable | 3 Comments »

Page 2 of 212

Next Entries »