Back-to-Back Order – How to


Back-to-Back Order is very useful functionality in Oracle Applications.

Key Business Drivers

  • Data integration

  • Lower inventory cycle time

  • Lower inventory cost

  • Link supply to specific demand

  • Can offer a variety of product to customer

  • Used heavily in contract manufacturing environment where the product is standardized and the company plans to focus more on product design rather than manufacturing

Many times business suffers a loss when data is transferred between quotations, orders, purchase orders or invoices?

Damage to any business due to data loss or corruption is always very high. This can be due to a simple user error or data corruption. During the manual transfer of data, the input of incorrect information or staff errors are very real risks. This can have a profound impact as your business grows and staff are under more pressure to process orders in a market where the client expectation is no longer to have their order processed in days or hours but in real-time.

Back to Back order process allows you to process information and orders in very logical manner ensuring a simplistic and efficient process. The integration between quotations, order processing and stock management means that all orders can be processed in real time and you are no longer dependant on a manual process to be run.

e.g. When the PO is received, reservation gets applied automatically against the Sales Order. This prevents allocating material to some other demand.

The key behind the integration of a system is the ability to seamlessly integrate different pieces of information, this leads us to back-to-back order processing.

The key areas that are focused on as part of the back to back process are:-

  • Quotations

  • Orders

  • Requisition

  • Invoices (in ‘Oracle Accounts Payable’ and ‘Oracle Accounts Receivable’)

  • Purchase Orders

Back to back order processing provides an integrated seamless link from the quotation stage, through to the purchasing of stock (or services), to dispatching, delivering and invoicing your client and the receipt and payment of invoices. It is also extended to invoicing (against PO/receipt) and payment to your supplier. All this process is done using Oracle Work-Flow, standard work flow is given by Oracle but if you want you can modify the same to fulfill business needs. Approval processes are also taken care by Work-Flow.

The entire process can be performed in the minimal amount of time without any redundancy. Each document has reference of some other document so it doesn’t get lost in between. Below are the steps in Back to Back order.

  • Quotations are created and sent to the client.

  • The client places the order and all required acknowledgements are sent.

  • Requisitions / Purchase Orders are automatically created for the required stock.

  • Management of awaiting stock from suppliers.

  • Tracking and managing supplier and customer communication.

  • Receiving of stock and handling of part deliveries.

  • Dispatching the order to your customer with management of delivery locations and methods.

  • Customer Invoicing.

  • Supplier payment.

Some of the important documents that gets created automatically through the different stages in this cycle include (automatic creation of document/s depends on setup).

Quotations, Order Acknowledgements and confirmations, Invoices and Proforma Invoices, Purchase Orders, Stock Receipt Slips, Stock Transfer Slips, Dispatch Notes, Packing to name a few.

For demo please visit two links given below:

Advertisements

Oracle Timecard (OTL) Automation


Recently i have seen many requests for OTL timecard automations in Oracle. One of the reasons is the financial downturn in the martket.

Many companies have announced furlough for employees- meaning the offices and manufacturing units will be shutdonw for a specified amount of time and it will be mandatory for employees to either take that time off from their vacation time, flex time, may be borrow it from next year or simply be unpaid for that time period. Whatever be the case, it saves company a lot of money that it was otherwise obligated to pay in vacation time or paid days. Now because its mandatory, it has to be in the system for the payroll to pick it up.

If the organization uses time entry system – like oracle – to enter vacation/flex time, and processes payroll then following needs to happen in order for a succesfull furlough automation.

– Employees time must be entered on the online timecard.

– The timecard must be approved by manager or Auto-approval process.

– This OTL timecard must be transferred to Batch Element Entries for Payroll.

To automate this process we will use HXC Timecard APIs provided by Oracle. These APIs help us in creating a timecard for a day, week, and also attach elements/ projects to the timecard. Also, the APIs submit the timecard with a workflow process type so it can either be picked for AUTO processing or Manual approval.

Before we go into the details, we have to see how a typical timecard is built. For the sake of simplicity, we will consider Monthly Paid (exempt) employees.

A timecard is a combination of DAYS. Each DAY will be one Row in a table. For Every day that you need to enter time (e.g. Saturday Sunday will not need a time entry being a holiday) you need a DETAIL type row also. And, for each DETAIL record that has to go into an element or project for costing or payroll purpose, we need an ATTRIBUTE also.

These are nothing but the TIME BUILDING BLOCKS. To make things simple, lets go and see these records:

select * from hxc_time_building_blocks

TYPE: MEASURE ( Number of hours to be put in that particular day) or RANGE (For period like week or day).
SCOPE: TIMECARD, DAY, DETAIL or APPLICATION_PERIOD

Now, if you see a typical timecard, this is how it looks (Use the hierarchical Query below):

TIMECARD (12/1/2008  – 12/7/2008) TYPE: RANGE
|_  DAY (12/1/2008 – 12/1/2008) TYPE: RANGE
|_  DETAIL (12/1/2008):  8 HRS   (may have attributes)  TYPE:MEASURE
|_  DAY (12/2/2008 – 12/2/2008)
|_  DETAIL (12/2/2008):  8 HRS
|_  DAY (12/3/2008 – 12/3/2008)
|_  DETAIL (12/3/2008):  8 HRS
|_  DAY (12/4/2008 – 12/4/2008)
|_  DETAIL (12/4/2008):  8 HRS
|_  DAY (12/5/2008 – 12/5/2008)
|_  DETAIL (12/5/2008):  8 HRS
|_  DAY (12/6/2008 – 12/6/2008)
|_  DAY (12/7/2008 – 12/7/2008)

SELECT htbb.time_building_block_id, htbb.TYPE, htbb.measure, htbb.unit_of_measure, htbb.start_time, htbb.stop_time,htbb.parent_building_block_id, ‘N’ parent_is_new, htbb.SCOPE,htbb.object_version_number, htbb.approval_status,htbb.resource_id, htbb.resource_type, htbb.approval_style_id,htbb.date_from, htbb.date_to, htbb.comment_text,htbb.parent_building_block_ovn, ‘N’ NEW, ‘N’ changed,htbb.application_set_id, htbb.translation_display_key
FROM apps.hxc_time_building_blocks htbb START WITH ( htbb.time_building_block_id in (6848088) AND htbb.object_version_number in (1 ) )CONNECT BY PRIOR htbb.time_building_block_id = htbb. parent_building_block_id AND PRIOR htbb.object_version_number = htbb.parent_building_block_ovn ORDER BY htbb.time_building_block_id ASC

NOW Over to APIs….

hxc_timestore_deposit.create_timecard_bb
— Create a Timecard building block (only timecard, no days, or details)
— Here are the parameters it takes
(
p_start_time => to_date(’01-DEC-2008 00:00:00′,’DD-MON-YYYY HH24:MI:SS’) ,
p_stop_time =>  to_date(’07-DEC-2008 23:59:59′,’DD-MON-YYYY HH24:MI:SS’),
p_resource_id => emp.person_id ,
p_comment_text => ‘Automated TimeCard: DEC08’,
p_approval_style_id => 41, –This is your workflow approval style, default to AUTO APPROVE
p_app_blocks => l_tbl_timecard_info,
p_time_building_block_id => l_tc_bb_id –returns the id of  TC Building block
);

hxc_timestore_deposit.create_day_bb
— Creates a DAY building block (only DAY no details)
— Here are the parameters it takes
(
p_day => l_start_date,
p_parent_building_block_id => l_tc_bb_id,
p_comment_text => ‘Automated TimeCard: DEC08’,
p_app_blocks => l_tbl_timecard_info,
p_time_building_block_id => l_day_bb_id
);

hxc_timestore_deposit.create_detail_bb
— Creates a DETAIL building block, in next step we have to attach the attribute to this DETAIL
— Here are the parameters it takes
(
p_type => ‘MEASURE’,
p_measure => 8, –Number of Hours
p_parent_building_block_id => l_day_bb_id,
p_comment_text => ‘Automated TimeCard: DEC08’,
p_app_blocks => l_tbl_timecard_info,
p_app_attributes => l_tbl_attributes_info,
p_time_building_block_id => l_detail_bb_st_id
);
hxc_timestore_deposit.create_attribute (
p_building_block_id=> l_detail_bb_st_id,
p_attribute_name=> ‘Dummy Element Context’,
p_attribute_value=> ‘ELEMENT – 60110’, –This is the Accrual PTO Element we want to update through this API.
p_app_attributes=> l_tbl_attributes_info);

HXC_TIMESTORE_DEPOSIT.EXECUTE_DEPOSIT_PROCESS
–This is the Submission Call. This process will submit the timecard, days and details with attributes. Timecard will stay in SUBMITTED State until approved via Manual or AUTO Approve process.
(
p_validate => FALSE,
p_app_blocks => l_tbl_timecard_info,
p_app_attributes => l_tbl_attributes_info,
p_messages => l_tbl_messages,
p_mode => ‘SUBMIT’,
p_deposit_process => ‘OTL Deposit Process’,
p_retrieval_process => ‘BEE Retrieval Process’,
p_timecard_id => l_new_timecard_id,
p_timecard_ovn => l_new_timecard_ovn
);

Hope this article helped you in understanding the basics of the Time Entry APIs. Please note that this is  the initial and basic knowledge. You will need some more knowledge – like DELETE timecards API for rollback in case of any issues. UPDATE timecard APIs etc for a full fledge capability on OTL timecard automation.

OCP Advisor – Mohan Dutt


Name

Mohan Dutt, a.k.a. OCP Advisor

Expertise

Oracle 11i, Oracle R12, Project Management

Organization

Oracle, Hyperion, PwC and a few others

Contacts

Email: ocp.advisor@gmail.comhttp://ebizocp.blogspot.com  

Blog:

Site : www.mohandutt.com

1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: Started my professional career in exports for a global electrical power equipment manufacturer. Those were exciting times when software companies like Oracle were launching an integrated application to address all the operations of a global company. I joined the consulting practice of Pricewaterhouse Coopers. PwC was perhaps the Oracle consulting organization at that time. Later I joined an Oracle Advantage Partner. About four years ago, I joined Hyperion and today I am part of the Oracle ecosystem.

2.      Please share any of your Oracle work related professional /project experience.

Ans:  For more than a decade, I have implemented, upgraded, migrated, managed and supported various releases of Oracle E-Business Suite from 10.7 to 12. I was fortunate to work in global implementations on a single global instance for multiple projects. Oracle Release 12 addresses many of the requirements that I came across the projects over the years and would highly recommend to any organization planning to scale their operations globally without worrying about their enterprise application scalability.

3.      What would be your recommendation for Oracle Applications/ Financials professional in regard to available certification paths? Also what are pre-requisite for any of 11i or R12 Certification

Ans: There are several certification options for the Oracle E-Business Suite professionals. Oracle offers Oracle Certified Expert track and Oracle Certified Professional tracks. Based on an individual’s work experience and expertise, one can choose their certification roadmap. The certification exams ask real-life case study based questions and hence an expert knowledge level for the application module (e.g. General Ledger, Payables, Receivables etc) is required.  Certification is the recognition of one’s superior skill and expertise. Hence, I encourage individuals to get certified through this globally recognized credential. Certification opens new doors and also provides an implicit assurance to your clients or users of your professional ability.

4.      Please advise how an individual interested in Oracle Applications related certification, i.e. Payables, how she/he should go for it i.e study material, duration, practice etc

Ans: As mentioned in my previous answer, it is assumed that the individual has working knowledge and exposure to the application. Oracle University provides instructor led training (ILT) classes for each of the modules. Attending an ILT class would help one get a very good idea about the exam content since the exams are based on the courses. In case one is already an expert implementer or power user, only a quick revision of the exam content topics is necessary. For this profile of candidates, I have recommended reviewing the Oracle Tutor documents. Oracle Tutor documents are available as patch downloads on Metalink. Both the ILT student guides and Oracle Tutor documents have practice exercises that reinforce the module concepts. In case one is not confident about a specific exam topic I would suggest a review of the Oracle user guide and implementation guide for the module. Lastly, I would recommend the #1 habit for highly successful OCP individuals – read the EBS OCP blog as often as you can! There are practice questions that one can answer and evaluate one’s exam preparedness.

5.      You have received lots of recognition and accolades; please share some information about those.

Ans: I have been working closely with the Oracle Applications community for a decade now. I have participated in many roles at the Oracle Application User Group (OAUG) over the years. It was a pleasant surprise to be recognized in 2007 as the Member of the Year for my contributions. Today, I continue to participate in various forums and engage in conversation (offline and online) with Oracle professionals from all around the world. I hope to continue my self-described role as an Oracle Applications Evangelist in the future too.

6.      Need your view on terms Functional, Technical and Techno-Functional. How you think these have relevance. Do techno-functional professional real advantageous or it is kind of overlapping.

Ans: An individual’s education background typically determines their intial role – functional or technical. For example, with an accounting background one would probably start as an end user or implementer in a functional role. As one adds experience across projects and over the years, an individual becomes more techno-functional with the relative percentages depending on their interest and expertise. To be a solution expert as an implementor or any super user, one has to pick up both functional as well as technical knowledge. So I feel for further career advancement, one should pick up both the skills. In a senior position, one is assumed to have both the skill sets to architect any solution.

7.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: We are fortunate to be working on Oracle technologies, which are always the leading edge, and with a complete roadmap for any enterprise and business. This is also a time for introduction of new platforms and tools. As a professional in the Oracle space, focus on upgrading your skills to the latest releases and tools. Once you have gained expertise, have a plan for certification because that also serves as a measurable goal for your personal growth.

8.      Your feedback on Knoworacle.wordpress.com

Ans: Knoworacle.wordpress.com is an excellent blog that explains Oracle application concepts in a very lucid and interesting manner. Subscribe to the blog and read the posts everyday. We are very lucky to have blogs like knoworacle teaching us the finer points of the application. Learning never stops till you knoworacle.

9.      Please any additional questions/ thoughts from your sides

Ans: Thank you very much for the opportunity to speak to your blog readers. Once again, I encourage all Oracle certification aspirants to visit the #1 ranked (on Google search) blog on certification topics. Best of Luck from your OCP Advisor!

Disclaimer:  Opinions expressed by the OCP Advisor is entirely his own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed are not validated by Oracle.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Data flow for Order-to-Cash cycle


Data flow for Order-to-Cash cycle  

Hello friends, here we are having one of the contribution from “Devendra Gulve” , very precise and useful explaination on O2C cycle. hope this be helpful to you.

For more details please visit http://functionalguy.blogspot.com

 

1. Order Entry 
This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table.

  • Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table oe_order_headers_all
    • No record exists in any other table for this order till now.
  • Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID.

2. Order Booking 
This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below table get affected.

  • oe_order_headers_alL
  • oe_order_lines_all
  • wsh_delivery_details
  • wsh_delivery_assignments

*In shipping transaction form order status remains “Ready to Release”.

At the same time, Demand interface program runs in background and insert into inventory tables mtl_demand.

3. Reservation 
This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved. Once this program get successfully get completed, the mtl_demand and mtl_reservations table get updated.

4. Pick Release 
Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order.

Pick release can be done from ‘Release Sales Order’ form or ‘Pick release SRS’ program can be scheduled in background. In both of these cases all lines of the order gets pick released depending on the Picking rule used. If specific line/s needs to be pick release it can be done from ‘Shipping Transaction form. For this case Pick Release is done from ‘Release Sales Order’ form with Pick Confirm=NO. 
Once pick release is done these are the tables get affected:

  • If step 3 is not done then MTL_RESERVATIONS gets updated now.
  • wsh_new_deliveries
  • wsh_delivery_assignments
  • wsh_delivery_details
  • MTL_TXN_REQUEST_HEADERS
  • MTL_TXN_REQUEST_LINES
  • Mtl_material_transactions_temp
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

*In shipping transaction form order status remains “Released to Warehouse” and all the material still remains in source sub-inventory. We need to do Move Order Transaction for this order. Till this no material transaction has been posted to MTL_MATERIAL_TRANSACTIONS

5. Pick Confirm/ Move Order Transaction

Items are transferred from source sub-inventory to staging Sub-inventory. Here material transaction occurs.

Order line status becomes ‘Picked’ on Sales Order and ‘Staged/Pick Confirmed’ on Shipping Transaction Form.

  • MTL_MATERIAL_TRANSACTIONS_TEMP
  • oe_order_lines_all
  • MTL_MATERIAL_TRANSACTIONS
  • mtl_transaction_accounts
  • wsh_delivery_details
  • wsh_delivery_assignments
  • MTL_ONHAND_QUANTITIES
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

* This step can be eliminated if we set Pick Confirm=YES at the time of Pick Release 

6. Ship Confirm 
Here ship confirm interface program runs in background. Data removed from wsh_new_deliveries. 

The items on the delivery gets shipped to customer at this stage.

  • oe_order_lines_all
  • wsh_delivery_details
  • WSH_SERIAL_NUMBERS
  • mtl_transaction_interface
  • mtl_material_TRANSACTIONS
  • mtl_transaction_accounts
  • mtl_demand, MTL_reservations
  • MTL_ONHAND_QUANTITIES
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

7. Enter Invoice 

After shipping the order the order lines gets eligible to get transferred to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. This is also called Receivables interface, that mean information moved to accounting area for invoicing details. Invoicing workflow activity transfers shipped item information to Oracle Receivables. At the same time records also goes in the table RA_INTERFACE_SALESCREDITS_ALL which hold details of sales credit for the particular order.

ra_interface_lines_all (interface table into which the data is transferred from order management) Then Auto-invoice program imports data from this table which get affected into this stage are receivables base table. At the same time records goes in ra_customer_trx_all and ra_customer_trx_lines_all

8. Complete Line 
In this stage order line level table get updated with Flow status and open flag. 
oe_order_lines_all

9. Close Order 
This is last step of Order Processing. In this stage only oe_order_lines_all table get updated. These are the table get affected in this step. 
 
oe_order_lines_all

oe_order_HEADERS_all

 You will get the details of column values getting updated at different stages and table joins information at http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html

devendra gulve — Expert’s page – click here

special Thanks TO dEVENDRA gULVE ( http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html )

Thanks – Shivmohan Purohit

11i Manufacturing Expert – Devendra Gulve


Name

Devendra Gulve

Expertise

Module: INV, BOM, OM, Depot Repair

 skill area: Manufacturing and Distribution

Organization

Current: Zensar Technologies, Pune, India

Past: Mahindra & Mahindra Nashik, Valley Gauges, Pune.

Contacts

Email:devendragulve@gmail.com                        

blog/site: http://functionalguy.blogspot.com/

 

1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I was in Manhindra and Mahindra, Nashik for some days as a Trainee Engineer. After Engineering I joined Valley Gauges in Pune. In 2005 I joined Symbiosis for doing full time MBA in IT. After MBA I joined Zensar Technologies, Pune. In Zensar I am working as a Oracle Apps Associate Consultant. The project I am working in has only one Functional person and that’s me, so I need to handle all the issues irrespective of the module or domain. I am getting very wide exposure to the system in this project.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: Anybody who wants to be a functional consultant in any domain has to have the knowledge of the processes followed in that particular domain. For example a Finance consultant has to know the accounting entries, details of P/L, Balance sheet etc and a Manufacturing consultant must know how material flows on the shop floor, how material is managed, classified, located, controlled as well as process to fulfill the order etc. The list of things one must know is unlimited but to start one shall know the basic standard processes followed in the particular functional area.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Manufacturing Modules.

Ans: I do not a great experience of taking / giving interviews, still I can try list down some points. But the questions definitely flow on the basis of past experience and the requirement of the client.

·        Types of transactions, actions associated with the transaction.

o       E.g. Sub-inventory transfer, Sales order issue, PO receipt, etc

o       Actions associated will the accounting entries, change in on-hand, sub-inventory valuation, etc.

·        Order-to-cash cycle

·        Organization structure

·        What are the various intra-operation steps?

o       Queue, run, to move, reject, scrap

·        What are the different types of Bill of Material?

o       Standard, Model, Option class, Planning, Product Family

·        What are the item attributes for an item to enter the sales order?

o       Customer ordered, Customer order enabled, OE transactable.

·        What is a modifier?

o       Modifiers enable you to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods, coupons) and freight and special charges that the pricing engine applies immediately to pricing requests or accrues for later disbursement.

·        MRP, MPS, MDS

·        Use of Bill of Material.

I will try to list down more questions modules / process wise at add it to my blog i.e. http://functionalguy.blogspot.com/

4.      What Oracle Configurator module does what the general feature and how it used in Oracle Applications.

Ans:  Oracle Configurator is the product from Oracle which gives you the flexibility to configure the BOM at the time of entering as order as per the customer requirement. You don’t need to defined deferent combination of your offerings prior the order. It saves times, maintenance cost etc. To use this in Oracle Apps you need to do some setups which are summarized at http://functionalguy.blogspot.com/2008/04/setup-for-oracle-configurator.html if one needs to use complex logic to define the dependencies of the option selected then he/she can go for Oracle Configurator Developer for the complex logic.

5.      What is Kanban method, how it used and implement in Oracle Inventory. What are the other related concepts with kanban and oracle inventory?

Ans: Kanban is a material control / management system, which is a part of Lean manufacturing. In this kanban cards are used to show status (Empty / Full) of the bin carries components. Once the bin become empty the process to fulfill it starts. For more details please visit http://functionalguy.blogspot.com/2007/04/kanban-introduction-and-benefits.html

6.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I can’t give suggestions just like that. Improvement comes with time and combination of success and failure.

7.      Your feedback on Knoworacle.wordpress.com

Ans: I really appreciate your efforts towards this blog. It is well manages and in the easy language to understand. You are also planning to start free on-demand training through your blog is appreciable. One more thing which I liked is you are coming-up with the T-shirt with your blog’s logo and name. Great work, please keep-up and let me know in case I can help you.

here you can find his contribution here– click here

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Oracle Expert – Mandeep Dhami


Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Mandeep Dhami, An Oracle Application experts in his area. I encourage you all to ask ur query/ question to him.

Name

Mandeep Dhami

Expertise

Module: Payables, Assets, Internet Expense and GL

Organization

Current: Merrill Lynch

Past: J.P. Morgan Chase

Contacts

Email: mandeepdhami4u@hotmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I have just got into the world of Oracle Professionals, working as Functional Consultant on Payable, Assets, Internet Expense and GL modules. So far I have been involved in implementing the above modules of Oracle across various locations in Asia Pacific region. I have been involved from operations side giving requirements to the deployment team, who then sets up the system and then I get involved in doing System Integration Testing (SIT). Once SIT is successfully done we get the same testing done by end users as part of Users Acceptance Testing (UAT). This also involves giving training and preparing training material for the end users.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: It will be too early for me to comment on this as I am quit novice in this role. But whatever I have experienced so far I can say that the functional consultant should have good knowledge about the working of various modules from end users perspective.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Financials Modules.

Ans:  What accounting entries are generated when an invoice is entered and paid?

What’s the difference between cross validation rule and security rule?

4.      What is your favorite Oracle Applications modules, share some of your interesting professional work experience.

Ans: My favorite module is Payables. In terms of interesting experience I can recollect one when implementing oracle payables for one of the locations where they were giving cash advance to employee. This was also a new learning for me. I got the solution for the same after consultation with my colleagues from the team. The real problem was to sale this solution to the location as first of all this application was new for them and this functionality was to be used by them only in the region. It took couple of training sessions with detailed flow chart and training material to get them agree to the solution suggested.

5.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I would say that the professional should have good knowledge about the modules they are working on and should always strive to be up to date with latest happenings on their areas of work. I would also suggest visiting such blog (http://knoworacle.wordpress.com/) which are full of information and knowledge.

6.      Your feedback on Knoworacle.wordpress.com

Ans: Very good initiative by you to share knowledge on Oracle. There are various articles on different modules of Oracle and all these is from your own practical experience which makes this initiative all that more special, important and accurate.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Oracle-Expert-Raju-ghosal


Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Raju Ghosal, An Oracle Applications DBA, experts in his area. I encourage you all to ask ur query/ question to him.

Name

 Raju Ghosal

Expertise

Oracle Application SysAdmin /Cloning

Contacts      

Email: raju.ghosal@gmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: Currently working with a Multinational in Developing strategic projects deployment plans; analyzing and coordinating ERP business applications across all phases of an entire Software Application Life Cycle (SALC).

I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

I was also a part of management advisory board for all BCP activities.

 2.      Please share some/ any of your Oracle work related professional /project experience.

Ans:  I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

 3.      What is term Environment Management in context of Oracle Applications, How it is relevant for Oracle Applications setups in various organizations

Ans: Environment management duties include:

Instance Management – Work with DBAs, SA’s and CT Application Teams in coordinating instance refreshes, downtimes, usage for initiatives.

Oracle Patch Management – Coordinating with Functional teams /DBA Teams /Prod Support teams/Oracle Teams, etc on Patches/SRs for Oracle Application Instances. 

Opening SR Reviews and Follow Ups – Host weekly status calls

Coordinating Finance Technology Environment Initiatives – examples:  10G Upgrades, Partitioning, etc with DBAs, Functional Teams, App Leads and Prod Support.

Status Reports – Produce various surveys, reports, logs, etc pertaining to Technology Initiatives, issues and standard operations.

Conducting Business Continuity Planning initiatives which includes Crash and Recovery test and High Availability Test etc.

 4.      You take lot of interview, what are the common professional skills you look in candidates, how you advise candidates to focus on to improve their interview performance.

Ans: The common qualifications I look for in a candidate are:

Should be confident of what he is speaking. Should have sound knowledge on the business impact of the task he is doing or has done. He/She should understand the business logic involved or the process flow of the application he is working on.

He/She should have excellent attitude towards work and always willing to learn.

5.      How you differentiate between Support, Development, Implementation and other different kind of activities as part of team scope and work. How they different and how a professional should identify his role and relevance. What are skills require for different kind of activities.

Ans: Implementation is the whole of processes that defines a complete method to implement software in an organization. It is based on best practices and case studies from various literature sources and presents a collection of processes and products that make up a complete implementation method to allow any organization to plan and execute the implementation of ERP software.

Developer Role is to prepare the Technical Specification (based on a Functional Specification given by a Functional Consultant), build the code, Review the code and finally to prepare the Unit Test Cases. Sometimes the developer may be asked to do a technical research for an optimal solution.

After a go live, the application needs a maintenance/support to resolve the issues/tickets raised by the users when using the application. Ticket is like a request for changes/bug fixing or a request for a new Developer Role includes bug fixing/change the existing code due to new requirements/build a new code etc.

 6.      Need your view on terms Functional, Technical and Techno-Functional. How you think these have relevance. Do techno-functional professional real advantageous or it is kind of overlapping.

Ans: Techno Functional professionals has always the advantage over Functional or Technical guys specially in cracking the Interviews as they are very good to map the Business needs with the jobs they are doing moreover they are in very high demands among Multinationals where you need to gel well with the actual business users.

To my understanding a professionals should be well versed with the business needs along with the technical jobs they are expected to perform. This gives a win-win feeling to both the Business needs and the technologies as a whole.

7.      Your feedback on Knoworacle.wordpress.com

Ans: Good going…I wish all the best for future Endeavour.

8.      Please any additional questions/ thoughts from your sides

Ans: You should publish few DBA related articles which are in high demands in current market scenarios.

Disclaimer:  Opinions expressed by the OCP Advisor is entirely his own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed are not validated by Oracle.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )