oracle concepts for you: June 2015

Tuesday, 30 June 2015

Displaying subtotal and grand total based on the group column in BI Publisher Template in oracle apps

For Example

Display the sub total values based on Account code and show grand total end of the report.

The report has only one group (G_ACCT) and group columns like

Account Code, Ro Number, ROLine# ,Ro Type, Ro Date, Supplier#, Supplier Name,

Supplier Site, W/H, Buyer, Items, Qty, Price, Trxn Amount

Show the subtotal and grand total amount for Trxn amount column based on account code combination.

Steps:

Divide the for –each loop with Account code column
Do the current group logic.
Display the sub total column before closing current group loop.
Display the grand total value at end of the report.

Adding above steps logic in xml tags:

<?for-each-group:G_ACCT;./ACCOUNT_CODE?> (first F Xml tag)
<?for-each:current-group()?>(second F xml tag)
After displaying G_AMT Closing current-group for-each.
Displaying the T_AMT (grand total amount)

Output:

DROP SHIP Order Flow in oracle apps

Drop Ship is mere similar to Back 2 Back order except the supplier directly ships the order to customer rather than our inventory.
Below is the flow chart for your reference.

All steps are similar except two changes:

Source type as External in sales order line
Import source as ORDER ENTRY while executing Requisition Import

STEP 1: SALES ORDER CREATION

Let’s start with placing a new sales order.

Follow similar steps as Back 2 Back orders.

Progressing Supply Eligible

Running Workflow Background process.

Now the status of the sales order line will be Awaiting Receipt.

STEP 2: Requisition Import

As discussed before, mention Import Source as ORDER ENTRY as below.

From here we follow P2P cycle.

Querying REQ, PO, taking Receipt as below.

Corresponding # created:

Sales Order	10008
Requisition	15951
PO	6606
Receipt	23708

Now if you check the status of the sales order line it will be shipped.

Run the workflow background process.

The status will be closed which means the order has directly been shipped to customer rather than transferred to our inventory.

Different line Status of the Sales Order:

SL NO	PROCESS	BACK 2 BACK METHOD	DROP SHIP METHOD
1	SALES ORDER BOOKING	SUPPLY ELIGIBLE	SUPPLY ELIGIBLE
2	PROGRESSING SUPPLY ELIGIBLE	External Req Requested	Awaiting Receipt
3	CREATING REQUSITION	External Req Open	Awaiting Receipt
4	CREATING PURCHASE ORDER	PO Open	Awaiting Receipt
5	TAKING RECEIPT	Awaiting Shipment	SHIPPED
6	After Performing O2C CYCLE	CLOSED	Not Applicable directly send to the Customer CLOSED

This completes the explanation about BACK 2 BACK METHOD & DROP SHIP METHOD in Oracle EBS R12.

Back 2 Back and Dropship Order Process in Oracle R12.2

This order type applies when customer orders a product which you do not stock or manufacture.
In turn customer places the order, you place the order with supplier and after the shipment from the supplier, and you distribute the product to the customer.
Below is the flow chart for B2B process flow:

STEP 1: Item Creation for Back 2 Back orders

Item: Prism
Copy the Purchasing template.
Purchasing Tab: List Price : $15, Used Approved Supplier © enable
General Planning Tab: Source Type : Supplier, Make or Buy : Buy
Order Management Tab: Assemble to Order © enable.
Assign to our inventory.

STEP 2: CREATE APPROVED SUPPLIER LIST

Invoking: Order Management →Purchasing→ Supply Base→ Approved Supplier List

Lets create an Approved supplier List for the item we created (Prism).

STEP 3: Create Sourcing Rule

Invoking: Order Management →Purchasing→ Supply Base→ Sourcing Rule

We are going to create Sourcing Rule as: Prism_Sourcing.

Step 4: Assign Sourcing Rule

Query the ”Supplier Scheduling Assignment” set by using F11 key & paste our item, Sourcing rule as below.

STEP 5: BOOK SALES ORDER

Now book the sales order and the status of the line will be Supply Eligible.

Select the Supply Eligible text →Right Click→Progress Order→OK

Now the status will be changed to External Req Requested as below.

Now run the Workflow Background Process from View→ Request

STEP 6: Requisition Import

Switch the responsibility to Purchasing and Run Requisition Import from View→ Request
Select Import Source as CTO.

Here Requisition Import and Create Releases Program runs and view the output, so that we can make sure that the releases has been processed successfully as below.