ASN Creation in Oracle EBS R12

Advance Shipment Notification (ASN) is a document that is sent to Buyer in advance of Buyer receiving the product.It helps purchasing Organization to estimate expected arrival of goods which in turn helps to determine whether production schedule, customer delivery commitments etc. are on track or there may be change in various schedules.

Supplier can send ASN by different ways of EDI. Among them one is 'iSupplier Portal'. Below are the detail steps how ASN are created from EBS iSupplier Portal.

Step1: Log in to EBS iSupplier Portal using Supplier username and password.

 Click on 'Create Advance Shipment Notices' as shown in below snapshot.

Navigation :- iSupplier Portal > Shipments > Shipment Notices

All the Purchase Orders (PO) for the respective supplier will be listed. Select the PO for which you want to create ASN and click on 'Add to Shipment Notice' button as shown in below snapshot.

In 'Shipment Lines' tab give all the details for shipment as shown in below snapshot.

In 'Shipment Header' tab enter 'Shipment Number' , 'Shipment Date' and 'Expected Receipt Date' for the ASN. You can also add all other details of Freight in 'Freight Information' section. Once all the details are entered correctly click on 'Submit' button as shown in below snapshot.

A successful message is displayed after the creation of ASN.

Shipment details are validated and inserted in Receiving Open Interface Tables.

• RCV_HEADERS_INTERFACE
• RCV_TRANSACTIONS_INTERFACE

Till the data is validated by Receiving Open Interface Shipment status remains 'Pending' as shown in below snapshot.

Step2: Log in Purchasing Responsibility using Buyer Username and Password to generate ASN.

Log in to Buyer user and submit 'Receiving Transaction Processor' concurrent program to generate ASN. Give the operating unit name in the parameters tab which pops up while submitting the 'RCVTP' program.

 Receiving Open Interface validates ASN data , and once accepted it generates ASN.
You can query for your shipment using PO number and see the details.

Navigation :- Purchasing, Vision Operations > Receiving > Manage Shipments

Hope this helps you implementing ASN in EBS.
Please give your feedback on this post.

Happy Coding.....:)

Event Driven Network(EDN) In SOA 11g

Event Delivery Network in SOA 11g:

Events are used to handle the business operations i.e.to transfer the data. Events contains the data in form of XML. In SOA, Events are handled by using either Bpel or Mediator. A process which generates the event is called Event Publisher. A process which consumes the event is called Event Subscriber.

Events are completely follows Fire and Forget mechanism means, Event Publisher don’t wait for the response from Event Subscriber. Even Event Publisher don’t know any information about Event Subscriber and vice versa. Events may contains one publisher with multiple subscribers i.e. one to one as well as one to many.

Let consider an example which demonstrates the EDN. We are going to design two SOA composites i.e. Event Publisher Process, Event Subscriber Process.

Note : We can design both publisher and subscriber in a single composite as well as in two different composites.

Design Event Publisher Process :

• Create Bpel process as shown below

• Design the Xsd file as shown below

• Drag drop the invoke activity from component pallet and follow the below screen shots.

• Drag drop one assign activity and map the data from input variable to invoke input variable.

• Finally deploy the composite.

     

Design Event Subscriber Process :

•   Create Bpel process as shown below

• Click on add symbol as shown in the above screen shot and choose the required Event which we have created in Event publisher process

•  Localize the .edl and .xsd files to your current composite.

• Drag and drop the assign activity and perform the addition operation for calculating the Total marks.

•  The bpel process will look  like as follows.

Testing

• Request to the EDN publisher process 

• Check the instance dashboard in EM for subscriber process.

• Audit Trail of subscriber process.

Please give your feedback over this blog post.

Happy Coding.

Deployment of OAF Pages In EBS R12

Below are the brief steps to deploy OAF pages in Oracle Apps Environment.

Step1: Create OAF Pages in Local Maschine:-

We create our projects in 'jdevhome/jdev/myprojects '  folder.

Folder structure to be followed while creating our application is :-

• To store VO(View Objects), VL(View Links) and AM(Application Module) we follow : jdevhome/jdev/myprojects/oracle/apps/xxcll/employee/server

• To store EO(Entity Objects) we follow: jdevhome/jdev/myprojects/oracle/apps/xxcll/employee/schema/server

• To store our XML pages/regions and Controllers (CO) we follow:  jdevhome/jdev/myprojects/oracle/apps/xxcll/employee/webui

Note: Here xxcll is a custom application top which needs to created before starting the development of our custom application. Click here to see how to create/register Custom Top in EBS R12.

Step2: Transfer source code/files to Oracle Apps Environment.:-

Once the development is done transfer all the source code in Oracle Apps Environment in $JAVA_TOP using FTP tool.

Step3: Compiling Java Files:-

• Log in to EBS server using putty(any Linux tool) as applmgr user.

• Source EBS Apps environment variable by moving to APPL_TOP directory as shown below. 

• Navigate to JAVA_TOP by executing :- cd $JAVA_TOP

• Navigate throughout the code directory being transferred and compile all the java files by executing:

          javac <filename>.java  or javac *.java

Step4: Importing xml Files:-

Run the import scripts for all the pages and regions.

Import command for Pages is :

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxcll/employee/webui/EmpSearchPG.xml -username apps -password apps -dbconnection "(DESCRIPTION =(ADDRESS=(PROTOCOL = tcp)(HOST =$EBS_HOST_NAME)(PORT =$EBS_DB_PORT))(CONNECT_DATA =(SID =$EBS_DB_SID)))" -rootdir $JAVA_TOP 

 Import command for Region is :

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxcll/employee/webui/EmpLovRN.xml -username apps -password apps -dbconnection "(DESCRIPTION =(ADDRESS=(PROTOCOL = tcp)(HOST =$EBS_HOST_NAME)(PORT =$EBS_DB_PORT))(CONNECT_DATA =(SID =$EBS_DB_SID)))" -rootdir $JAVA_TOP

Step5: Bounce EBS server:-

Bouncing the server is most important after the deployment. Steps to bounce the server are detailed below:

• Navigate to ADMIN_SCRIPTS_HOME directory by executing:                                                   cd $ADMIN_SCRIPTS_HOME

          Make sure that EBS Apps environment is sourced.

• Stop all the services by executing: ./adstpall.sh apps/apps

• While executing above script if you get any status other than 0 then you have to manually kill the running services.

• Start the services by executing: ./adstrtal.sh apps/apps

Step6: Registering xml pages in APPS:-

Log in to EBS through operations/welcome user.

Navigation: System Administrator > Application > Function

  

• In description tab provide the desired values for Function, User Function Name and Description(optional) as shown in below snapshot.

• In Properties tab select 'SSWA jsp function' as Type.

• In Web HTML tab provide the jsp page url and save the record

          URL: OA.jsp?page=/oracle/apps/xxcll/employee/webui/EmpSearchPG

This complets the registration of your OAF page in Oracle APPS.

Furthur you can attach your Functions to desired Menu and run it from respective responsibility.

Please give your feedback on this post.

Happy Coding........ :)