Posted on January 30th, 2011 by Sanjit Anand ||
Email This Post
Looking for API which can delete desired party record completely.. use this API which can be used to Purge the Party Information from TCA Architecture.The name of the API is apps.hz_purge.purge_party.
Read the rest of this entry »
Posted in Oracle TCA | No Comments »
Posted on January 28th, 2011 by Sanjit Anand ||
Email This Post
Do You know, though R12 Oracle eBTax is New module , but this provides Half of the Tax Compliance Solution , as this lack these features as compare to Tax complete solution like Vertex:
1.Tax rates
2.Situs/Place of Supply rules (e.g., modified origin)
A tax can only be based on either the ship-to or the ship-from
In Texas, the district taxes are likely to be calculated and remitted to the wrong district
3.Tier tax & max tax rules
- A tax can only have a reduced basis
- In Florida, Tennessee, Arkansas and North Carolina caps cannot be calculated
- All taxes are calculated by the total line with no consideration to units
4.Product/services taxability rules
5.Returns or remittance capability
In addition, the functionality provided in EBTax may work for companies with very limited tax exposure or “nexus.”
Other functional limitation’s are
Lets hope Oracle can add some of the missing link in future releases.
Posted in Oracle E-Business Tax | No Comments »
Posted on January 27th, 2011 by Sanjit Anand ||
Email This Post
If your company is doing Consol and you have to see results across all SOB’s for timely investigation and resolution during close, use this query .(11.5.10.2)
select sob.name from_sob,
sob1.name to_sob,
gc.name,
gc.description,
gc.from_currency_code,
gch.from_period_name,
gch.to_period_name,
gch.to_currency_code,
gch.status,
gjb.name batch_name
from apps.gl_consolidation gc,
apps.gl_consolidation_history gch,
apps.gl_sets_of_books sob,
apps.gl_sets_of_books sob1,
apps.gl_je_batches gjb
where gc.consolidation_id = gch.consolidation_id (+)
and gc.from_set_of_books_id = sob.set_of_books_id
and gc.to_set_of_books_id = sob1.set_of_books_id
and gch.je_batch_id = gjb.je_batch_id (+)
Posted in Oracle General Ledger | No Comments »
Posted on January 26th, 2011 by Sanjit Anand ||
Email This Post
In Procure to Pay (P2P) mainly 4 application Payable, Iexp, Iproc, and PO and Projects Module heavily producing Financial events for Tax , which is mostly Input in Nature.
- Oracle Payables Invoice
- Payables Credit/Debit Memo
- Purchase Order
- Purchase Transaction Quote
- Purchase Requisition
- Purchase Prepayment
whereas in Order to Cash (O2C) four main application like OM, OKS, Quote and AR using and producing Financial events for Tax with these transactions.
- Sales Transaction Quote
- Receivables Invoice
- Sales Credit/Debit Memo
- Sales Adjustment
Posted in Oracle E-Business Tax | No Comments »
Posted on January 20th, 2011 by Sanjit Anand ||
Email This Post
First enhacement is Contracts in any OU can be accessed w/o changing responsibility
- Approvals:Flag a contract if it requires approval based on renewal type
- Manual contract creation
- New negotiation status “Draft”
- Create New HTML contract search form (Swan) with more flexibility to search
- Billing:
- Suspend billing functionality
- Multi price list usage on the same contract (single currency only)
- Pricing:
- Service Contract request type has been seeded in advanced pricing:
- Leverage DFF’s
- Other fields can map to Pricing entities like qualifiers/modifiers, etc. In 11i it was limited to OM and Quoting forcing to write PLSQL to grab DFF’s from SC.
- Discounting can be applied on the contract header, lines and sublines. Earlier it was only at Subline level.
- Other Module Integration:
- Install Base terminations and Transfers are tied to Service contracts. Whenever an install base record is transferred to a new owner, a new service contracts can be created. Earlier in 11.5.10, it worked similarly only for terminations.
- New profile for these install base transferred contracts is OKS: Transferred Contract Identifier.
Posted in Service Contracts | No Comments »
Posted on January 18th, 2011 by Sanjit Anand ||
Email This Post
These are major enhancement in R12 Advance Collection.
- Multi Org Access Control:(MOAC) enabled.
- Uptake of Cross-Operating Unit Initiative: Collections activities such as strategies and work items, dunning letters, and collections calls can incorporate transactional and customer data from different operating units if needed.
- Consolidation of Collections Functionality into Advanced Collections: Collections Workbench in AR is obsolete.
- New Implementation Checklist and Setup Screens: New implementation tool designed to ease setup and provide a single place to record and manage implementation decisions.
- Improved Payment Processing and Customer Funds Capture: Seamless integration with Oracle Payments’ make payment formatting and end-to-end electronic payment processing features very efficient.
- Use of Oracle Territory Management to Define Collections Territory Hierarchy.
- XML Publishing Technology for Collections Correspondence.
- Configurable Metrics: A new configurable Metrics tool allows managers to define metrics formulas that are automatically calculated and displayed on the Profile tab for collections users.
Posted in Release12 | No Comments »
Posted on January 17th, 2011 by Sanjit Anand ||
Email This Post
You can find the details in these post.Major Enhancement in R12 Receivables are:
- Partial Period Revenue Recognition: Partial Period Revenue Recognition enables the generation of revenue recognition schedules that respect the start and end dates of contractual obligations.
- Revenue Deferral Reasons: Event-Based Revenue Management allows users to define revenue deferral reasons and corresponding revenue recognition events.
- COGS and Revenue Matching: new COGS and Revenue Matching feature satisfies this matching principle by synchronizing the recognition of revenue with the recognition of associated COGS.
- Enhanced Payment-Based Revenue Recognition: Feature achieves payment based revenue recognition by associating transaction lines with revenue impacting contingencies.
- Line Level Cash Applications
- Refunds Enhancements: Oracle Receivables is fully integrated with Oracle Payables to deliver a seamless, automated process to generate check and bank account transfer refunds.
- Balance Forward Billing: enhanced version of the existing consolidated billing functionality for industries where customers are billed for all their account activity on a regular, cyclical basis. You see more details here.
- Late Charges: enhanced Late Charges functionality enabling the creation of standard late charge policies that can be assigned to customer accounts or account sites.
- Multi Org Access Control(MOAC) enabled.
- Integration with Subledger Accounting
- Receivables Reconciliation Enhancements: Easily reconcile your receivables using enhanced reporting.
- Collections Workbench Obsolescence: Features moved to Oracle Advanced Collections.
- Bills of Exchange Obsolescence: The Bills of Exchange feature is obsolete and replaced by the Bills Receivable feature.
- Trade Accounting Obsolescence: The Oracle Trade Accounting feature is obsolete and replaced by Oracle’s Deduction Management solution.
Those you are using ORACLE IRECEIVABLES or planning to use , can find major enhancement in R12 as:
- Trading Community Architecture: TCA Integrated.
- Oracle Payments: Integrated with Oracle Payments.
- Multi Org Access Control(MOAC) enabled.
- Enhanced User Self Registration: Feature has been enhanced.
- Cross Customer Site Payments: Oracle iReceivables has enhanced the payment functionality to allow the selfservice users to pay their bills and review their payments across customer sites
Posted in Oracle Receivable | No Comments »
Posted on January 17th, 2011 by Sanjit Anand ||
Email This Post
The Oracle PLM solution is comprised of the following elements:
- Agile Product Collaboration :Provides stakeholders in the extended design and supply chain secure access to critical product record data for initiation and approval of design, manufacturing, customer, and supplier driven changes.
- Key Points of this application are
- Product Definition
- Change Collaboration
- Document Management
- Manufacturer Management
- Multiple Organizations
- Agile Product Governance and Compliance :Manages product and program compliance against industry standards and environmental / regulatory requirements such as the Waste of Electronic and Electrical Equipment (WEEE) directive and the Restriction of Hazardous Substance (RoHS) regulations.
- Agile Product Cost Management :Enables companies to manage product costs and make informed sourcing decisions early on, synchronizing product cost intelligence and processes across design, sourcing, manufacturing and supplier tiers throughout the product lifecycle.
- Agile Product Quality Management :Drives improved product quality and customer satisfaction by tightly integrating customer, product, quality, and regulatory information within a closed-loop corrective action system.
- Key Points of this application are
- Product Quality
- Closed Loop Corrective Action
- Design for Quality
- Supply Chain Quality Management
- Agile Product Portfolio Management :Optimizes companies’ product development investments. Provides tightly synchronized program and product information and achieves cross-program, multi-enterprise visibility and decision support to maximize resource utilization.
- Agile Engineering Collaboration:Addresses the specific requirements of the engineering organization. Provides comprehensive product IP management across multiple CAD tools and disciplines in a central product record. Optimizes internal and external collaboration and IP reuse
- AutoVue Electro-Mechanical Prof. for Agile:Provides native document collaborative visualization across the global enterprise, and the ability to leverage native design files directly from the enterprise product record. Enables direct visual access to files without requiring the original authoring tool or translators.
- Agile Product Lifecycle Management Data Mart
- Agile Product Lifecycle Management Business Intelligence
Oracle (Agile) PLM Integration Products
- Oracle (Agile) ERP Adapter
Posted in Beyond Apps | No Comments »
Posted on January 15th, 2011 by Sanjit Anand ||
Email This Post
This is New Product in R12 which provides the infrastructure for transaction tax knowledge management and delivery using a global system architecture that is configurable and scalable for adding country specific tax content.
Posted in Oracle E-Business Tax | No Comments »
Posted on January 3rd, 2011 by Sanjit Anand ||
Email This Post
You can apply all or part of a receipt or on-account credit memo to a single debit item or to several debit items.
For example, a customer may send a single check to pay all of one invoice and part of another invoice.
The customer may also have an on-account credit memo to use with the check to close an open debit item.
Usually , these points to consider when applying receipts and on-account credit memos to transactions:
- Credit Memo Search
- Transaction Balance for Applications Always Used profile option
- Receipt Application on Cross-customer Transactions
- Foreign Currency Receipts
- On-Account Credit Memos
- Balance Forward Bills
Posted in Oracle Receivable | No Comments »