Monday Mar 09, 2015

Webcast: Understanding &Troubleshooting Receipts APIs In Oracle Accounts Receivable

Webcast_icon.jpgDate: March 19, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India (Mumbai)

Application Programming Interfaces (APIs) extend the existing functionality of creating & manipulating receipts through standard Oracle Receivables Receipts forms and Lockboxes. This one-hour Advisor Webcast is recommended for Accounts Receivable technical and functional users who need to create and apply receipts using Receipts APIs.

Topics will include:

  • API Overview
  • Receipts APIs
  • Review API script section
  • Execution of Receipts APIs
  • Troubleshooting Receipts API issues

REGISTER.jpg
Details & Registration via the My Oracle Support Community thread:  Advisor Webcast On 19-Mar-15: Understanding &Troubleshooting Receipts APIs In Oracle Accounts Receivable

Friday Nov 07, 2014

Service Contracts APIs are Finally Here!

For some time now customers have been lobbying hard for Public APIs for Oracle Service Contracts.  Now what you've all been waiting for: public APIs for service contracts data creation, update and deletion are finally here!

Many customers implement service contracts while retaining legacy (or building custom) front-end systems for entry of source transactions.  These legacy / custom transaction systems typically handle quoting and order entry and when a quote is approved or a deal is closed, there is a need for back-end programmatic mechanisms to create service contracts for the purposes of future administration, billing and to provide entitlements.   In Release 12.2.4 public and supported APIs for service contracts data manipulation have been provided.

For more details about the APIs see R12.2.4: Service Contracts API Bulletin - Technical Documentation on Available Public APIs (Doc ID 1941609.1)

The following APIs are provided:

API Name
Usage

OKS_IMPORT_HEADER_PUB.Create_Contract_Header

Creating a contract header of Service Agreements, Subscription Agreements, Warranty and Extended Warranty.

OKS_IMPORT_HEADER_PUB.Update_Contract_Header

Updating contract header information.

OKS_IMPORT_HEADER_PUB.Create_Template_from_contract

Creating a template contract from any contract.

OKS_IMPORT_HEADER_PUB.Create_Contract_from_Template

Creating a contract from a template.

OKS_IMPORT_LINE_PUB.Create_Contract_Line

Ccreating contract lines of type Service, Usage, Extended Warranty and Subscription.

OKS_IMPORT_LINE_PUB.Update_Contract_Line

Updating contract lines of type Service, Usage, Extended Warranty and Subscription.

OKS_IMPORT_LINE_PUB.generate_bill_schedules

Generating the billing schedules.

OKS_STATUS_CHANGE_PUB.Change_Status

Change the contract status from Entered to Cancelled, Cancelled to Entered and also to different statuses within the same status type.

OKS_TERMINATE_CONTRACT_PUB.Terminate_Contract

Terminate a contract/line/subline with various options like suppress credit, full credit or with some override amount.

OKS_DELETE_CONTRACT_PUB.Delete_Contract

Delete contract/line/subline.

OKS_RENEW_CONTRACTAPI_PUB.Renew_Contract

Renew a contract.

OKS_CASCADE_ATTRIBUTES_PUB.Oks_Cascade_Attributes

Cascade attributes like dates and price list from headers to lines and from lines to sublines.

OKS_ACTIVATE_CONTRACT_PUB.Activate_Contract

Perform QA check and submit the contract for approval for contracts which are in ‘Entered Status’.  Contracts in QA hold status are moved to Active once the contract passes the QA check.

OKS_IMPORT_SUBLINE_PUB.create_subline

Creating a subline/covered level under a service/usage or extended warranty line.

OKS_IMPORT_SUBLINE_PUB.update_subline

Updating contract subline.




Thursday Jul 03, 2014

Use the New Inventory API to make Cycle Counting Easier

So, when processing your cycle counts, have you ever wondered if there is an application programming interface (API) to add to or update your ABC Group Items? If you're on EBS Inventory release 12.2, the answer is a resounding YES! Use Doc ID 1680388.1 - New R12.2 ABC Codes API to add or update ABC Group Items, to get information on the new API, including files added, required setup, helper sql's, and a quick demo video:


With the new API INV_ABC_ASSIGNMENTS_PUB.CREATE_ABC_ASSIGNMENTS, getting a new item into a cycle count has never been easier. We hope you enjoy the API and happy cycle counting!

Tuesday Feb 04, 2014

ER Implemented - New Supplier Update API's Supported in R12 Oracle Payables!

Well we have great news for you! 

In 11i there were API's (Update_Vendor, Update_Vendor_Site and Update_Vendor_Contact) but they were not supported in R12 due to integration with Multiple product teams. The reason being was that the entities Supplier, Sites and Contacts had representations in multiple products like TCA, IBY, ZX etc and all these representations needed to be in sync.

However, most of our customers have huge volumes of supplier data which they need to be able to control programmatically so the fact that they no longer had access to these API's was frustrating.

It was requested through Enhancement Request Bug 17575099: ENHANCEMENT FOR SUPPORT OF SUPPLIER UPDATE APIS that Oracle Payables provides API's for updating Supplier / Supplier Sites / Supplier Contacts in AP_VENDOR_PUB_PKG in R12.

Well, this functionality is now available and the following new APIs had been created: 

                      - Update_Vendor_Public
                      - Update_Vendor_Site_Public
                      - Update_Vendor_Contact_Public

*** Note: These are the only procedures supported to update suppliers, sites or contacts.

We are sure that this ER being implemented will be welcome news for many.  Enjoy! 


To download the document with additional information about these new procedures please review Doc ID 1618099.1 - New Supplier Update API's in Oracle Payables


Further Information:

R12: What are New Supplier Related Tables/Packages/Programs. APIs Supportability (Doc ID 812918.1


Picture Get Proactive

About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
4
5
10
11
12
13
14
15
17
18
19
22
24
25
26
27
28
29
30
31
 
       
Today