Parallel Pick Release in Shipping ( R12 New Feature)

Oracle has introduced lots of Interesting features in R12 (e-business Suite).In this post I will talk about the one such feature.
Parallel Pick Release
With this feature user can now run the Pick Release processes in parallel and improve the over all performance.

Advantages
One of Key Advantage of with Parallel Processing of the Pick release process is user can apply /engage additional (if available) resources to process the Pick release data that was previously process by 1 process only and hence save lot of time by submitting this process in Parallel.

Following are the changes made for this feature –

1. A new Parameter (No. Of Child Processes) has introduced in Pick release Concurrent Program.
2. A new profile option (WSH: No. Of pick release child processes) has introduced , it indicate how many child processes you want to spawn.

Shipping Purge in Oracle e business Suite (R12 - New Feature)

In R12 E-business Suite Oracle has introduced another new feature to Purge Shipping Execution (WSH) data.
(Oracle Apps)

In this Post I will explain the various feature offered in Oracle Shipping (e-business ).
Shipping Purge allow us to purge Shipping data for

•  Delivery
•  Trip
•  Delivery Lines
•  LPN

For purge, Oracle in R12 (e-business suite) has added a new concurrent program “Shipping Purge”, It has lot of parameters and allow you to purge shipping data based on parameters.

Some of parameters for the concurrent Program.

Actual Shipment Date for Pick Release (R12 New Feature)

Oracle in e-business R12 has offered a new feature to let user enter the “Actual Departure Date” at the time of Pick Release.

In Oracle Shipping Module (e-business), complete process from Pick Release to Ship confirm has already automated and not required any human Interface. Only point that left is ability to record the shipping Date as the data on which actual (physical) shipment has happened. As of now system record the shipping date as the date on which Shipping data processed on Oracle System.Now in R12 onward Oracle has introduced feature to allow user enter Actual Shipment Date

Workflow in Oracle Shipping Execution (R12 New feature)

Oracle has offered many new features in R12.In this post I will talk about the Introduction of the workflow in Oracle Application Shipping Module offered in R12.

In R12 Oracle Shipping (WSH) is utilizing the workflow.

Advantages of Workflow

• Automate the Shipping business process by adding them in the Shipping workflow.
• Routing based on the business rules.
• Send the Notification to user about some Important event, e.g sending notification about
• Backorder deliver
• Dollar Amount or Volume in Delivery etc
• Best of all now with workflow user can visualize the Shipping process, by means of workflow monitor and thus improve our visibility.
• Integration with the 3rd party APIs will be easy , we can just add them where every they requited by customizing the workflow.
  

New Blog about Management Tips.

Hi Friends

I have started a new blog http://egenmgmt.blogspot.com/  . This is about some Managements , I am not expert in that , I try to blog what so ever I read and learn. Please do visit in your FREE time and let me know how am I doing.

Thanks

XML Publisher /BI Publisher Report .

This Post is about  XML Publisher Reports

XML Publisher /BI PublisherBI Publisher (XML Publisher) is one awesome tool introduced by Oracle Corp. It has made report designing a very easy and simple (especially for E-Business reports).

With BI Publisher
We can design Complex Reports in less time (Business User can design the layout with an easy Desktop Tool like Microsoft word/Excel /Adobe etc).
Cost of maintenance will be low.
Total Cost of design and Maintenance will be low.Here we can leverage the workdone by the functional Analyst by utlizing his/her layout design.Technical Analyst in this case has to focus on data model and then mapping the data with the Layout desgined ny Functional analyst.My Exerience says that on an average an IT analyst spend 40% time in layout design.With BI Publisher we can cut that to 10-12%.

Oracle Reports to BI Publisher Reports Conversion

This Blog is about how ro convert rdf report to BI Publisher reports.

In this blog I will explain brief how to convert the Oracle report into BI Publisher report and then deploy in Enterprise BI Server or Oracle e-business Suite. (In this blog I will cover the Oracle BI Enterprise server, Steps are almost same for e-Business Suite).
In Oracle Report we are following the traditional approach, by saying that I mean

1. Data Model
2. Layout
3. Translation

has binding and store in single file. Where as in BI Publisher we have separate file for Data Model, Layout and translation. For a Data Model system will pick the layout and translation at run time.
Conversion Utility that converts Oracle Reports to BI Publisher reports therefore generate several files when it converts oracle standard reports to BI Publisher reports.

Advantage Of BI Publisher reportsBI Publisher has ability to design/display highly formatted report from multiple data source.

BIPBatchConversion is the utility to migrate reports from Oracle Reports to BI Publisher.

This utility converts Oracle XML reports in BI Publisher reports, but if the reports are not in XML format then this utility will not converts them in one step.

BI Publisher/XML Publisher reports for Oracle Apps

This Post is about how to Integrate BI Publisher/XML Publisher reports with Oracle Apps

Reports for Oracle Apps with XML Publisher


In last so many, I have found that Oracle Report tool is not very developer friendly and formatting of report
take lot’s of time ( and money) especially reports like

1. 1. Invoicing
2. 2. Check Printing
3. 3. Forms and labels
4. 4. Contracts etc

 And most of the customers has implemented 3rd Party software, and these tools are really expensive in terms maintenance, labor, licensing as well as Integration.
But with the introduction of the XML Publisher, Oracle done a great job for developer community especially for e-Business Suite developer.

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to design and publish reports by integrating familiar desktop word processing tools with existing E-Business Suite data. XML Publisher leverages standard, well-known technologies and tools, so you can develop and maintain user defined (custom) report formats.

It has removed complexity and reduces total cost and that results in increase in Productivity with outoncreas in cost.

With XML Publisher

Manual Splitting - Model Vs Model Option

In Oracle Order Management we have choice to manaully Split the complete model , but in case we want to Split Option or Option calls , system will not allow us to do so.

Manual Split -
Model - Select the Model line and then go to Action > Select Split.
Try to Split the Option , Select the Option or Option Class , Press the Action Button , "Split" will not appear in the available actions.

Hope that helps

What is ship_to_org_id and ship_from_org_id in Oracle Order Management.

Thsi Post is for Oracle Apps (Order Management).

ship_from_org_id column in Oracle Order Management application means warehouse from where you ship the goods to customer.Please keep in mind ship_from_org_id should be an Inventory organization (Because you want to ship the goods and if you don't define your warehouse as Inventory org then how you will able to ship the from from there ) , Technically , if you define and organization and not mark it as Inventory Org , then in Order Management Waregouse column ( lines level) , your organization will not appear , till you mark it as Inventory org and assign items to it.

Ship_to_org_id is the location where you actually want to ship the good , this is possibly be your customer's place and it can be or can't be an Inventory org.

Important table and view to look into for this are
1.SHIP_TO_ORG_ID
hz_parties
hz_cust_accounts
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL

2.SHIP_FROM_ORG_ID
org_organization_definitions
HR_ORGANIZATION_INFORMATION



Hope that's help.

Order Managemnt Line Flow - Generic, Bill Only with Inventory Interface in R12i

This post is about the workflow "Line Flow - Generic, Bill Only with Inventory Interface " available in Oracle Apps Order Management.


Most of time ct. used this workflow if they don't want to perform Shipping , e.g If we go to Walmart and buy some stuff and then carry the good along with us. In this case Walmart just required to do Invoicing (Billing ) and reduce Inventory ( need to run Inventory Interface) , so this workflow is best for these type of scenarios.

Here I will talk about the Change in User experience when Migrate from R11i to R12i with respect to OPM items.

If customer is using Line Flow - Generic, Bill Only with Inventory Interface and Items are defined in the OPM Inventory (not using Discrete Inventory) , then the user experience will change in R12 as compared to R11i.

With the R12 onwards the OPM and Discrete Inventory is Integrated and now user can define OPM as well as Discreate Items in the same UI ( Discrete Inventory UI is enhanced for this purpose).With OPM and Discreate Inventory now is in 1 Module , when ever user create Sales Order with this workflow system will prompt user and ask him to Enter the Subinventory Code ( it doesnlt matter if it belongs to OPM or Discrete).

Where as in R11i , system never ask user to provide the Subinventory Code for OPM items.

In case you don't want user to Enter SubInventoty , you can define a Defaulting rule to populate the SubInventory ( If your requirement is complex you can define defaulting rule based on PL/SQL api).


Hope that Helps

Adding a New Line is Order with OE_ORDER_PUB

Below is code to add New Line in an existing Sales Order with OE_ORDER_PUB.

create or replace
package body xxorderprocess as

function xxcreateOrder
(
p_order_type_id NUMBER,
p_sold_to_org_id NUMBER,
p_ship_to_org_id NUMBER,
p_price_list_id NUMBER,
p_transactional_curr_code VARCHAR2,
p_flow_status_code VARCHAR2,
p_cust_po_number VARCHAR2,
p_order_source_id NUMBER,
p_inventory_item_id NUMBER,
p_ordered_quantity NUMBER,
p_tax_code VARCHAR2,
p_code VARCHAR2,
p_header_id NUMBER,
p_line_id NUMBER

)
return VARCHAR2 is
l_api_version_number NUMBER := 1;
l_return_status VARCHAR2(2000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
l_xxstatus VARCHAR2(1000);