Saturday 23 August 2014

Customers and Account Receivables tables in Oracle



Customer tables in Oracle Applications R12 are as follows:-

  • HZ_CUST_ACCOUNTS
  • HZ_CUST_ACCT_SITES_ALL
  • HZ_CUST_SITE_USES_ALL
  • HZ_PARTIES
  • HZ_PARTY_SITES
  • HZ_LOCATIONS


Account Receivables tables in Oracle Applications R12 are as follows:-

  • RA_CUSTOMER_TRX_ALL
  • RA_CUSTOMER_TRX_LINES_ALL
  • RA_CUST_TRX_LINE_GL_DIST_ALL
  • RA_CUST_TRX_LINE_SALESREPS_ALL
  • AR_CASH_RECEIPTS_ALL
  • AR_RECEIVABLE_APPLICATIONS_ALL
  • AR_PAYMENT_SCHEDULES_ALL
  • AR_CASH_RECEIPT_HISTORY_ALL

Thursday 8 August 2013

Account Payables tables in Oracle Application R12

Account Payables tables in Oracle Applications R12 are as follows:-

  • AP_SUPPLIERS
  • AP_SUPPLIER_SITES_ALL
  • AP_INVOICES_ALL
  • AP_INVOICE_LINES_ALL
  • AP_INVOICE_DISTRIBUTIONS_ALL
  • AP_HOLDS_ALL
  • AP_BATCHES_ALL
  • AP_CHECKS_ALL
  • AP_INVOICE_PAYMENTS_ALL
  • AP_PAYMENT_SCHEDULES_ALL
  • AP_PAYMENT_HISTORY_ALL
  • CE_BANK_ACCOUNTS
  • CE_BANK_ACCT_USES_ALL
  • CE_PAYMENT_DOCUMENTS

Thursday 13 June 2013

Steps to create rtf template in BI Publisher

Steps to create rtf Template

Required: For creating XML template you need following things

1.      BI publisher.
2.      XML file with xml tags.

Step 1: Load XML Data
           
            Open Microsoft word
Navigate to Add Ins -> Data -> Load XML data
           

Select the .xml file to load. Once the file get loaded successfully it will pop up a message that Data loaded successfully.

Step 2: Insert Fields
Go to Add-Ins -> Insert -> Field


Chose the field and click on insert. And click Insert. In this way design the layout according to requirement.

Sample layout is shown below:

Step 3: Create Repeating Groups


Another way to add the repeating group is to write xml tags.
For example
<?for-each:G_C_SRC_HDR_ID?>
C_INV_ITEM_ID
<?end for-each?>

Step 4: Adding conditional formatting
            Navigate to Add-Ins -> Insert ->Conditional Format
Check for null value of field CF_BILL_TO_CONTACT 

Step 5: Print on all pages
            There are few requirements where we need to print some objects on each page (header data). This can be done with xml tag as
<?start:body?>
            --Body
<?end body?>

Here whatever above <?start:body?> will be consider as header and whatever  below <?end body?> is consider as footer. So in this way we can print object on all pages by putting them above the start tag or after the end tag.

Step 6: Validate template
            Save your file with rtf format. Before running template need to be validated. Navigate to Add-Ins -> Tools -> Validate template
In case of no error it will print the message as “No error found”. If any error exist you need to fix and then again validate it.
 
Step 7: See the preview
            Navigate to Add-Ins -> Preview -> PDF.
You can also preview output in HTML, RTF, EXCEL and Power Point format as well.

The header/footer on the first page is different from the remaining pages in the output 

 Navigate to Insert ->Header

Select the Blank header


It will open the Header and footer Design
Click the checkbox Different First Page

Edit the 1st Page Header

Now go to second page and edit second page header

Save the changes and preview the output.
Output will contain first page header different from rest of the pages.

Page Numbering Starts with 2nd page in generated output


In the above different header option Insert Page Number in the second page header.
Edit header go to 2nd page and Insert Page Number

Insert page Number at current position.

go to format page number option
It will open a dialog box
Select start at radio button and insert  0.
Preview the output.

Totals: PAGE TOTAL, Grand Total and Page Breaks


Template structure

Template contain Onhand quantity which is numeric in nature
So add field after ONHAND_QUANTITY. Name it as PT

<?add-page-total:PT;’ONHAND_QUANTITY’?>
This PT field will calculate the page total. That calculated page total need to be displayed.
Now create one more field in the template and add the code
<?show-page-total:PT;’999G999D99’?>

 For PAGE Breaks add the field with code
<?split-by-page-break:?>
Sample Output

 ------------------------------------------------------------------------------------------------------------------


Thursday 18 April 2013

A Simple and easy steps to Create New Custom Form Oracle Applications



A Simple and easy steps to

Create New Custom Form Oracle Applications


---------------------------------------------------------------------------------------------------------------
Oracle Applications
Simple and easy steps to Create New Custom Form Oracle Applications
A beginner’s guide  to Create New Custom Form Oracle Applications


Custom form creation
  1. This is Oracle forms navigation panel after opening TEMPLETE.fmb in it.
  2. Click on the data block
  3. Delete BLOCKNAME and DETAILBLOCK from it   
  4. Now click on Windows
  5. Add new window by clicking +
  6. Window will appear like this (with added window)
  7. Go to the properties of window (press F4 or right click à properties)
  8. Change subclass information (click on the property class radio button)
  9. Now go to triggers
  10. Click on the PRE-FORM
  11. Change BLOCKNAME to <your block name> i.e. Window name that you  have difined
  12.  defined window name
  13. Now press compile
  14. Click on the Program Units
  15.  Go to APP_CUSTOM (Package Body) and change <your first window > to defined window then compile  
  16. Now to go to Data Blocks and create new data block by (+) and choose wizard method
  17. Press Next
  18. Choose table or view and Press Next
  19. Search table and add columns then Press Next 
  20. Click next (till final window) click on Finish Now
  21. That wizard is followed by layout wizard click next  
  22. Select (new canvas) then Press Next
  23. Select columns then Press Next
  24. Select Tabular button then Click next
  25.  Set Title and Number of record to display
  26. Click to Finish
  27.  Now Adjust layout 


Thursday 21 March 2013

A simple and easy step to Oracle applications Inventory management



A Simple and easy steps to

Oracle applications Inventory management 


---------------------------------------------------------------------------------------------------------------
Oracle Applications
Simple and easy steps to Oracle applications Inventory management
A beginner’s guide for Oracle applications Inventory management



What is Oracle Inventory Management?

Good inventory management is everything about knowing what is on hand (On hand quantity), where it is in use (Shipment and cross inventory), and how much finished product results.





In Oracle inventory there are many things which treated as inventory it could be
         

·        Finished goods.

·        Spare parts.

·        Services.

·        Raw materials.

·        Purchased inventory for own purpose.


What inventory can do?

 

Oracle inventory can

 

·        Gives parts their own unique identification numbers.

·        It can help you to plan replenishment.

·        It can give you Statistics about your on hand availability of products.

·        Forecast for material management.

·        Receive faulty products.

·        Issue products and materials and many more.


Life Cycle - Receipt to Issue  


For managing the Inventory Oracle Inventory uses the process which is named as RECEIPT TO ISSUE this process works as -
                                             When any inventory reaches in our warehouse we receive the inventory .After receiving we can transfer the received inventory within our organisation and to other organisation and after all we can issue material from Oracle inventory

  
Receipt to Issue

Receive Inventory -
                                   
We can Receive material by so many different ways which are
  • Purchasing.
  • Work in process.
  • Inventory (Receive from different inventory)
Transfer Inventory - 

                                  By using different applications we can generate request to transfer inventory
  • Shipping.
  • Order Management.
  • Work in process.
  • Inventory .
Issuing Inventory - 

                                  The following Applications can be issued to issue material

  • Order management.
  • Purchasing.
  • Work in process.
  • Inventory.

Inventory Organization Structure

In Inventory organization you can store and transfer items and one organization can have more than one inventories.
by the book definition "Sub inventory are unique physical or logical separation of material inventory  "
In Oracle inventory items or material under all organization is kept in sun inventories.
In sub inventory there is Locators or we can say one sub inventory can have more than one locators.
these locators help us to identify physical area where we put inventory items. Tracking of items is possible with the help of locators 

 

inventory organization structure

Unit of measure -

Item -