Steps in Order Cycle:
1) Order Entry 2) Booking 3) Pick release :
For this we have to go to
Shipping Responsibilty Release sales order
Here In this form , In the ORDER tab, we have to enter ORDER Number And delete the Scheduled shipped Dates To & Requested Dates To.
In SHIPPING tab, set AUTO CREATE DELIVERY to YES. In INVENTORY tab enter WAREHOUSE, set AUTO ALLOCATE to YES and AUTO PICK CONFIRM to YES. IF we set AUTO PICK CONFIRM to NO, then We have to go for the following steps
1. go to Inventory Resp
Move order à Transact Move Order then it will ask for warehouse information. Give the same name as before [M2] In this form, In the HEADER tab, enter the BATCH NUMBER of the order that is picked .Then Click FIND Button. Click on VIEW/UPDATE Allocation, then Click TRANSACT button. Then Transact button will be deactivated then just close it and go to next step.
4) Shipping :
For this we need to go to Shipping Transaction Give the order Number, and click find Then we can see the order status.
Then we have to click DELIVERY Tab Button, in the Action LOV We have to choose, SHIP CONFIRM.
Then four concurrent program will run in the background.
Such As::
1.) INTERFACE TRIP Stop 2.) Commercial Invoice 3.) Packing Slip Report 4.) Bill of Lading
After this concurrent program will complete successfully, we have to run One more WORKFLOW BACKGROUND PROGRAM.
· If we don’t want to ship all the items, that are PICKED, then we have to click LINE/LPN tab , then click DETAIL button . Now, in that form , in the SHIPPING field, we have to enter how Much quantity of items, we want to ship . The rest remain quantity, that are Ordered will become backorder quantity .
5) Interfacing with AR :
After WORKFLOW BACKGROUND PROGRAM
AUTO INVOICE MASTER PROGRAM from
RECEIVABLE RESPONSIBILTY. After this program will complete successfully , we can the invoice details in
RECEIVALE à TRANSACTIONS à TRANSACTIONS. Here in This Form, we have to give our order number in reference field And query for the invoice details .Then we can see the invoice details.
Table Level Information:
==========================
Order Entry
• At the header level a record gets inserted into the header table OE_ORDER_HEADERS_ALL.
• At the line level, record(s) get inserted into the Line table OE_ORDER_LINES_ALL.
Order Booking
• This will update FLOW_STATUS_CODE value in the table OE_ORDER_HEADERS_ALL to “BOOKED”
• The FLOW_STATUS_CODE in OE_ORDER_LINES_ALL will change to AWAITING_SHIPPING.
• Record(s) will be created into the table WSH_DELIVERY_DETAILS with RELEASED_STATUS=’R’ (Ready to Release)
OE_INTERFACED_FLAG=’N’ (Not interfaced to OM) INV_INTERFACED_FLAG=’N’ (Not interfaced to Inv)
• Record(s) will be created into WSH_DELIVERY_ASSIGNMENTS but with DELIVERY_ID null.
Pick Release
---
IF “Autocreate Delivery” option = “Yes” THEN
• ) Create a record into the table WSH_NEW_DELIVERIES
• ) Update WSH_DELIVERY_ASSIGNMENTS with DELIVERY_ID, thus • ) Update WSH_DELIVERY_DETAILS with RELEASED_STATUS=’Y
Auto Invoicing
---
Before running “Autoinvoice Program”, record(s) will exist into the table RA_INTERFACE_LINES_ALL with
INTERFACE_LINE_CONTEXT = ’ORDER ENTRY’ INTERFACE_LINE_ATTRIBUTE1 = &Order_number INTERFACE_LINE_ATTRIBUTE3 = &Delivery_id SALES_ORDER = &Order_number
After running the “Auto invoice Program” for the order:
Records will be deleted from the table RA_INTERFACE_LINES_ALL and new details will be created into the following RA transaction tables. >RA_CUSTOMER_TRX_ALL with INTERFACE_HEADER_ATTRIBUTE1=&Order_number RA_CUSTOMER_TRX_LINES_ALL with INTERFACE_LINE_ATTRIBUTE1 = &Order_number SALES_ORDER = &Order_number
posted by Rama at 1:21 PM | 1 Comments
Know Current APPS Current Versions.
1)select product_version,patch_level from fnd_product_installations
Get current version ana Patch level information.
2)select * FROM V$VERSION Database Version infomation. 3)select * from v$instance
Instance details
4)select WF_EVENT_XML.XMLVersion() XML_VERSION from sys.dual;
Current XML Parser Version info.
5)select TEXT from WF_RESOURCES where TYPE = 'WFTKN' and NAME = 'WF_VERSION' Workflow version Number.
6)select home_url from icx_parameters
Oracle applications front end URL
7)SELECT VALUE FROM V$PARAMETER WHERE NAME=’USER_DUMP_DEST’
Get the Trace file location. 8) XML Publisher Vesion info.
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class. Forward Declaration
PL/SQL allows for a special subprogram declaration called a forward declaration. It consists of the subprogram
specification in the package body terminated by a semicolon. You can use forward declarations to do the
following:
• Define subprograms in logical or alphabetical order.
• Define mutually recursive subprograms.(both calling each other). • Group subprograms in a package
Example of forward Declaration:
CREATE OR REPLACE PACKAGE BODY forward_pack IS
PROCEDURE calc_rating(. . .); -- forward declaration PROCEDURE award_bonus(. . .)
IS -- subprograms defined BEGIN -- in alphabetical order calc_rating(. . .); . . . END; PROCEDURE calc_rating(. . .) IS BEGIN . . . END; END forward_pack;
BIND Vs LEXICAL
BIND VARIABLE :
-- are used to replace a single value in sql, pl/sql
-- bind variable may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.
-- bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses.
LEXICAL REFERENCE:
-- you can use lexical reference to replace the clauses appearing AFTER select, from, group by, having, connect by, start with.
-- you can’t make lexical reference in a pl/sql statmetns. Flex mode and Confine mode
Confine mode
On: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects.
Flex mode:
On: parent borders "stretch" when child objects are moved against them. Off: parent borders remain fixed when child objects are moved against them.
Diff Between Implicit and Explicit Cursors
1) Implicit: declared for all DML and pl/sql statements. By default it selects one row only.
2) Explicit:Declared and named by the programmer.Use explicit cursor to individually process each row returned by a Multiple statements, is called ACTIVE SET. Allows the programmer to manually control explicit cursor in the
Pl/sql block
Execution Sequences of sql clauses.
a)Select….. b)Group by… c)Having… d)Orderby..
posted by Rama at 3:09 PM | 0 Comments performance problem in a Report Tune the Report Main Query
Create indexes on columns used in where condition (eliminate full table scan) set trace on in before report and set trace off in after report
srw.do_sql('alter session set sql_trace=true'); After Report:
srw.do_sql('alter session set sql_trace=false'); Trace file will be generated at location:
select value from v$parameter where name = 'user_dump_dest'; Get the trace file location path
see execution plans in a trace file, you need to format the generated trace file with tkprof statement.
Store Code statics in local drive.
posted by Rama at 2:58 PM | 0 Comments