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

WHT Technical Brief

Posted on June 18th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This post is more for BSA's , IT Analyst and developer for more technical insights.

WHT Codes and Groups

  • AP_TAX_CODES_ALL - this Hold WHT code name and description
  • AP_AWT_TAX_RATES_ALL- This hold WHT rate
  • AP_AWT_GROUPS WHT - This hold group name and description
  • AP_AWT_GROUP_TAXES_ALL WHT - This hold group associated with WHT code

Here are the details for WHT related columns in the important tables:

  • AP_INVOICES_ALL
    • AWT_FLAG
    • AWT_GROUP_ID
    • PAY_AWT_GROUP_ID
  • AP_INVOICE_LINES_ALL
    • LINE_TYPE_LOOKUP_CODE (=AWT)
    • LINE_SOURCE (=AUTO WITHHOLDING)
    • AWT_GROUP_ID
    • PAY_AWT_GROUP_ID
  • AP_INVOICE_DISTRIBUTIONS_ALL
    • AWT_FLAG
    • AWT_GROUP_ID
    • AWT_TAX_RATE_ID
    • AWT_GROSS_AMOUNT
    • AWT_INVOICE_ID (invoice id of WHT invoice)
    • AWT_ORIGIN_GROUP_ID
    • AWT_INVOICE_PAYMENT_ID
    • AWT_WITHHELD_AMT
    • WITHHOLDING_TAX_CODE_ID
    • AWT_RELATED_ID
    • PAY_AWT_GROUP_ID
  • AP_INVOICES_INTERFACE
    • AWT_GROUP_ID
    • AWT_GROUP_NAME
    • PAY_AWT_GROUP_ID
    • PAY_AWT_GROUP_NAME
  • AP_INVOICE_LINES_INTERFACE
    • AWT_GROUP_ID
    • AWT_GROUP_NAME
    • PAY_AWT_GROUP_ID
    • PAY_AWT_GROUP_NAME
  • AP_EXPENSE_REPORT_HEADERS_ALL
    • AWT_GROUP_ID
  • AP_EXPENSE_REPORT_LINES_ALL
    • AWT_GROUP_ID

Hope this helps.

Posted in Oracle Payable | No Comments »

Long time no post

Posted on June 10th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

True, it has been a while since I have posted anything, mostly due to being too busy with work to consider posting. This might sound like a lame excuse- but then its unfortunately true. Of late, I have so many things- good band and ugly too- going on in my life leaving me busy ..super busy....2 million

One of the good things has been noticing upon logging in, to see my blog crossing 2.18 millions page view, and that I have now up to 1427 subscribed users. Nice number- makes me feel really good. There are 571 comments pending for last 2 qtr to be cleared out. Recently upgraded to blogging software 2.9.2 from 2.3, which makes life somewhat easy.

Let’s see. Many other things happening around are keeping me on my toes. But it’s time I got some of my routines back. And hey, blogging used to be one of my routine activitiess. I read somewhere that for something to become an actual routine in your life you must do it regularly, methodically, religiously for 6 months and then it becomes a true blue routine in your life. Will start sharing some more things from new exposed area like salesForce.com, QlikView, Jira, DataHub etc. very soon.

Going forward, maybe I should contemplate making this site multilingual. What say?

Once again THANK YOU to everyone who visiting your site regularly.:)

Posted in Misc | 8 Comments »

Page 1 of 11