What is - fnd_standard.set_who
This is API provide by Oracle to return you the values of WHO columns .WHO columns are columns that tell you who has
1.Created/Update the value in a tables.
For all the standard table provide by in Oracle Applications , oracle has following WHO columns
1.Created_by
2.Last_Updated_by
3.Creation_date
4.Last_Update_date
5.Last_Update_login
Search over 500+ Posts
Dec 14, 2009
Dec 9, 2009
THE DIFFERENCE BETWEEN "TO BE USED" AND "TO BE LOVED
THE DIFFERENCE BETWEEN "TO BE USED" AND "TO BE LOVED
......... ......... ........ ......... ......... ......... ......... ......... ..... ......... .........
USED vs. LOVED
While a man was polishing his new car,
his 4 yr old son picked up a stone
and scratched lines on the side of the car.
In anger, the man took the child's hand
and hit it many times not realizing
he was using a wrench.
At the hospital, the child lost all his fingers
due to multiple fractures.
When the child saw his father.....
with painful eyes he asked, 'Dad when will my fingers grow back?'
The man was so hurt and speechless;
he went back to his car and kicked it a lot of times.
Devastated by his own actions..... .
sitting in front of that car he looked at the scratches;
the child had written 'LOVE YOU DAD'.
Anger and Love have no limits;
choose the latter to have a beautiful, lovely
life & remember this:
Things are to be used and people are to be loved.
The problem in today's world is
that people are used while things are loved.
Let's try always to keep this thought in mind:
Things are to be used,
People are to be loved.
I'm glad a sweet person forwarded this to me as a reminder...
I hope you have a good day no matter what problems you may face
it's the only day you'll have before it's over.
NOTE - This Sweet and Nice thing is not my creation , someone very close to me forwaded this to me . I found it's so Awesome and Touching. so sharing with all of you. .
......... ......... ........ ......... ......... ......... ......... ......... ..... ......... .........
USED vs. LOVED
While a man was polishing his new car,
his 4 yr old son picked up a stone
and scratched lines on the side of the car.
In anger, the man took the child's hand
and hit it many times not realizing
he was using a wrench.
At the hospital, the child lost all his fingers
due to multiple fractures.
When the child saw his father.....
with painful eyes he asked, 'Dad when will my fingers grow back?'
The man was so hurt and speechless;
he went back to his car and kicked it a lot of times.
Devastated by his own actions..... .
sitting in front of that car he looked at the scratches;
the child had written 'LOVE YOU DAD'.
Anger and Love have no limits;
choose the latter to have a beautiful, lovely
life & remember this:
Things are to be used and people are to be loved.
The problem in today's world is
that people are used while things are loved.
Let's try always to keep this thought in mind:
Things are to be used,
People are to be loved.
I'm glad a sweet person forwarded this to me as a reminder...
I hope you have a good day no matter what problems you may face
it's the only day you'll have before it's over.
NOTE - This Sweet and Nice thing is not my creation , someone very close to me forwaded this to me . I found it's so Awesome and Touching. so sharing with all of you. .
Sales Order line stuck at "Create Supply Order - Eligible".
In this blog I will explain why some time Sales Order line stuck at "Create Supply Order - Eligible" , and every attemept to progress it push the workflow to SHIP activity but then again back to Create Supply activity with result = Unreserve.
I have notice that this is very common issue that customer encounter , Workflow for order line looks good and at SHIP_LINE - Notified , but then it go backs ro "Create Supply " workflow activity with Result code = Unreserve.
In Order management we have different kinds of flows and their is possibility that this issue MAY appears in any type of flow (ONE and ONLY reason for this type of issues is DATA CORRUPTION).In this blog I will explain only why that has happend in Back to Back Orders.
Reason is very Simple - When a requisition gets created for a Sales Order line, order line gets reserved to this requisition. When sub inventory information is changed for this line, this reservation gets deleted and line moves back to Supply Eligible state.Point I want to explain here is if any changes made to back to back order line that impact the values like
Schedule ship date,
Subinventory,
Quanity etc.
Sales Order line moves back to Supply Eligible state.
I have notice that this is very common issue that customer encounter , Workflow for order line looks good and at SHIP_LINE - Notified , but then it go backs ro "Create Supply " workflow activity with Result code = Unreserve.
In Order management we have different kinds of flows and their is possibility that this issue MAY appears in any type of flow (ONE and ONLY reason for this type of issues is DATA CORRUPTION).In this blog I will explain only why that has happend in Back to Back Orders.
Reason is very Simple - When a requisition gets created for a Sales Order line, order line gets reserved to this requisition. When sub inventory information is changed for this line, this reservation gets deleted and line moves back to Supply Eligible state.Point I want to explain here is if any changes made to back to back order line that impact the values like
Schedule ship date,
Subinventory,
Quanity etc.
Sales Order line moves back to Supply Eligible state.
How to get Complete info (Data /table) of Oracle Sales Order
Just want to share one good piece of Information here -
In case you are intrested to see what all tables involved in end to end O2C cycle and what all data they stores , then run the Concurrent Program "Diagonastic Order Information".
This Concurrent program will print Name and data of all the tables from OE_ORDER_LINES_ALL to RA_CUSTOMER_TRX_ALL .
In case you are intrested to see what all tables involved in end to end O2C cycle and what all data they stores , then run the Concurrent Program "Diagonastic Order Information".
This Concurrent program will print Name and data of all the tables from OE_ORDER_LINES_ALL to RA_CUSTOMER_TRX_ALL .
Dec 8, 2009
Raise and Receive Events in Oracle Applications and Workflow.
Oracle Apps and workflow Events.
In this blog I will explain with Simple example how to use EVENTS in Oracle Workflow and then how to Raise Event in Oracle Application and Receive event in Oracle Workflow.
In my next blog I will explain in details about how to RAISE and RECEIVE events in Oracle Workflow, but here I will limit my self to RAISE event from Oracle Apps and then RECEIVE in Oracle workflow.
Step#1 - Define Event in Oracle Apps.
Navigation > Oracle Admin Workflow > Business Events > Press Button Create Event /Create Group Event.
Note - In this blog I will limit myself to "Create Event" Only and will not discuss "Create Event Group".
Enter
Please Note that when an event is raised , information about event stoted in Data type WF_EVENT_T.
WF_EVENT_T structure stores
Step 2 - Create the subscription for the Event , an event subscription registration indicating that a particular event is significant to a system.When ever an event is raised , event manager searches and execute amy subscripion assocaited with Event.
Navigate to Subscription tab and Select "Create Substription" and Define
Event Filter - Triggering Event
Phase - Order in which subscription to event execute, Phase with value 1 to 99 run synchronously , 100 and above are deferred., The phase number 0 (zero) is reserved for Oracle Workflow seeded subscriptions
Rule Date - Key /Message .
Action type - we have 4 options here , in my Example , I have defined Action Type = "Launch Workflow" as I want to Launch the workflow.
Create your Subscription .Since I have selected Action Type = "Launch Workflow", I need to create workflow with RECEIVE EVENT activity .
Below are Steps to create Workflow with RECEIVE Event activity.
1.Step #1 - Drag the Event Activity on your workflow and Select Event Action = Receive.Since it is a simple test i just added a wait and end activity.
Step # 2 - Make sure you have Include 3 Mandatory Attribute
\
Go to Workflow Adminstator and test the Event , by first query for your Event in Event Tab and then Press the Test Button .
It will trigger the Event
Event In turn trigger all the subscription assocaited with the Event.
In our example , since Action Type for My Subscription is "Launch Workflow", it will trigger my workflow as shown .
you can check the triggering of the workflow , either by query the Workflow @workflow Admin Page > Search in Item_type/item_key
OR
by executing below database queries.
In this blog I will explain with Simple example how to use EVENTS in Oracle Workflow and then how to Raise Event in Oracle Application and Receive event in Oracle Workflow.
In my next blog I will explain in details about how to RAISE and RECEIVE events in Oracle Workflow, but here I will limit my self to RAISE event from Oracle Apps and then RECEIVE in Oracle workflow.
Step#1 - Define Event in Oracle Apps.
Navigation > Oracle Admin Workflow > Business Events > Press Button Create Event /Create Group Event.
Note - In this blog I will limit myself to "Create Event" Only and will not discuss "Create Event Group".
Enter
- Name
- Description
- Status
- Owner Name/Tag etc for Event
WF_EVENT_T structure stores
- Event Header Properties like Event Name, Event Key , CoRelation ID,, Parameter list etc.
Step 2 - Create the subscription for the Event , an event subscription registration indicating that a particular event is significant to a system.When ever an event is raised , event manager searches and execute amy subscripion assocaited with Event.
Navigate to Subscription tab and Select "Create Substription" and Define
- System
- Source Type
- Event Filter
- Phase
- Status
- Rule Data
- Action Type
- On Error
- If Action Type = "Launch Workflow" then Define Workflow Type
- Workflow Process
Event Filter - Triggering Event
Phase - Order in which subscription to event execute, Phase with value 1 to 99 run synchronously , 100 and above are deferred., The phase number 0 (zero) is reserved for Oracle Workflow seeded subscriptions
Rule Date - Key /Message .
Action type - we have 4 options here , in my Example , I have defined Action Type = "Launch Workflow" as I want to Launch the workflow.
Create your Subscription .Since I have selected Action Type = "Launch Workflow", I need to create workflow with RECEIVE EVENT activity .
Below are Steps to create Workflow with RECEIVE Event activity.
1.Step #1 - Drag the Event Activity on your workflow and Select Event Action = Receive.Since it is a simple test i just added a wait and end activity.
- Event Name
- Event Type
- Event Key
\
Go to Workflow Adminstator and test the Event , by first query for your Event in Event Tab and then Press the Test Button .
It will trigger the Event
Event In turn trigger all the subscription assocaited with the Event.
In our example , since Action Type for My Subscription is "Launch Workflow", it will trigger my workflow as shown .
you can check the triggering of the workflow , either by query the Workflow @workflow Admin Page > Search in Item_type/item_key
OR
by executing below database queries.
Hope that helps , Leave your comments , as that help me to improve furthers.
Step by Step details about how to Create RMA in Oracle Order Management
In this blog I will expkain how to create RMA in Oracle Order Management , I am taking the case of creation of Return Sales Order with Receipt and Credit Memo.
1.Create New Sales Order with Order Type = "Return Only . ( we can take Mixed or any other that allow return line)
2.Since Header Order Type is "Return Only", based on the transaction Type Setup , System will default Line Type .In transaction type set the Default RMA = "Return (Receipt)" , with this Setup system will populate the Line Type = "Return (Receipt)" , enter other details like
Item #
Qty etc.
3.Go to Return tab ( Lines) and Enter Return Reason (There is LOV for Return Reason select any relevent value from LOV ).
4.Book the RMA.
5.Requery the RMA , check the Line Status , It should be "Awaiting Return".
6.Select Receipt (Purchasing Responsibility)
7.Goto Customer Tab and Enter the RMA Num .
8.Press Find Button.
9.Ignore the receipt Header , and go to Receipts form
10.Select the line
11.Press Save,System will ask for the Sub Inventory.Best bet is enter "Stores" ( Here I am taking the case Routing = Direct Delivery)
12.Press Save Button. Save action will automatically submit the "Receiving Transaction Processor (RTP) concurrent Program.
13.Check Order line status , it should be "Returned".
14.Go to View > request . Submit Concurrent Program "Workflow background Process"
with Item Type = OM Order Line
Process Deferred = Yes
Process Timeout = No.
Query Order line again , Staus Sould be "Closed"
15.Step # 14 also submit "Autoinvoice" concurrent Program.
16.Goto Transaction (Receivable Reposnsibility)
Go to Find Window
Enter Sales Order # in Sales Order Number Field
Press Find
System should dispaly your Invoice (Credit memo)
Examine the Invoice and you are good to go.
1.Create New Sales Order with Order Type = "Return Only . ( we can take Mixed or any other that allow return line)
2.Since Header Order Type is "Return Only", based on the transaction Type Setup , System will default Line Type .In transaction type set the Default RMA = "Return (Receipt)" , with this Setup system will populate the Line Type = "Return (Receipt)" , enter other details like
Item #
Qty etc.
3.Go to Return tab ( Lines) and Enter Return Reason (There is LOV for Return Reason select any relevent value from LOV ).
4.Book the RMA.
5.Requery the RMA , check the Line Status , It should be "Awaiting Return".
6.Select Receipt (Purchasing Responsibility)
7.Goto Customer Tab and Enter the RMA Num .
8.Press Find Button.
9.Ignore the receipt Header , and go to Receipts form
10.Select the line
11.Press Save,System will ask for the Sub Inventory.Best bet is enter "Stores" ( Here I am taking the case Routing = Direct Delivery)
12.Press Save Button. Save action will automatically submit the "Receiving Transaction Processor (RTP) concurrent Program.
13.Check Order line status , it should be "Returned".
14.Go to View > request . Submit Concurrent Program "Workflow background Process"
with Item Type = OM Order Line
Process Deferred = Yes
Process Timeout = No.
Query Order line again , Staus Sould be "Closed"
15.Step # 14 also submit "Autoinvoice" concurrent Program.
16.Goto Transaction (Receivable Reposnsibility)
Go to Find Window
Enter Sales Order # in Sales Order Number Field
Press Find
System should dispaly your Invoice (Credit memo)
Examine the Invoice and you are good to go.
Dec 7, 2009
Step - by Step details Order to Cash flow in Oracle Order Management
In this blog I will explain in few steps about complete Order to cash flow in Oracle Order Management.
- Create Order - Book It
- Go to 'Release Sales Order'
- Set the Required fields as shown below
- Order = Unreleased
- Order Number = Enter Order #
- Clear Schedule Ship dates and Requested Dates
- Go to Inventoty Tab and Enter Warehouse , based on your setup it will pull all the information
- Press Concurrent Button
- Go To "Shipping transaction form"
- Enter Order Number, Press Find
- Makes sure Line status = Staged/Pick Confirmed
- Go to Delivery tab and Press "Ship Confirm'
- Note Down Deliver #
- Press Ok
- Above step submit the concurrent programs, wait for Concurrent Program "Interface Trip Stop" to complete
- Goto Sales Order and Check Line Status ,It should be "Shipped".
- Go to View > request . Submit Concurrent Program "Workflow background Process"
- with Item Type = OM Order Line
- Process Deferred = Yes
- Process Timeout = No.
- Query Order line again , Staus Sould be "Closed"
- System will Trigger the AutoInvoice concurrent Program OR you have to Manually submit it
- Goto Transaction (Receivable)
- Go to Find Window
- Enter Sales Order # in Sales Order Number Field
- Press Find
- System should dispaly your Invoice
Examine the Invoice and you are good to go.
Dec 5, 2009
QuickShip UI on Oracle Order Management
Recently , I have received 1 query from my reader about the "Defer Interface" in quick ship UI in Order management.To my surprise I have never look into this UI.But after analyzing this UI I found it very very interesting.With this UI I need not to move to and fro between the tabs in Shipping transaction form, all the information about the
below are few Screen shots of UI.
As shown in UI we can see all the details about the delivery , trips and delivery details on same UI.
Ship Confirm UI will let us do the Ship Confirm
- Delivery
- Trips
- Delivery Details
- Freight Cost , Documents etc
below are few Screen shots of UI.
As shown in UI we can see all the details about the delivery , trips and delivery details on same UI.
Freight Cost UI will let us allow enter the freight Cost associated with the delivery.
Ship Confirm UI will let us do the Ship Confirm
I found QuipShip UI very interested and easy to use and it really help user doing work fatsre and more efficently.
Dec 2, 2009
How to Create Return in Oracle Receiving
In this blog I will explain how to create Retun in Receiving
Navigation > Receiving > Receipt >Go to Customer Tab > Enter RMA #
Press Find Button
In the receipt Form , you can see all the open lines for RMA.Check the line for which you want to create receipt , Update the quantity if required ,
Enter the Subinventory and other details based on your setup Press Save button.
On Save , system will uptomatically submit the "Receiving Transaction Processor" concurrent Program.
Now If you don't want to accept the complete RMA quantity from customer,we can TWO options
1.During Inspection , Reject the quantity that we don't want to accept from customer.
2.Retun the Quantity that we don't want to accept from the customer.
Option -1 : After we Receive the good, Perform the Inspection and then Reject the quantity .
Option -2 : After we receive the good , navigate to > Return , Query for RMA# and then return quantity , also in "Return TO" Enter "Customer".
Navigate to Receiving transaction > Query for RMA # , Please note that now Quantity available for receiving is = Total Quantity - Return Quantity.
Receive the good as required , it will submit the "Receiving Transaction Processor" concurrent Program ,update the inventory , progress workflow from "Wait for receiving activity" and push the credit memo data to AR Interface tables.
Navigation > Receiving > Receipt >Go to Customer Tab > Enter RMA #
Press Find Button
In the receipt Form , you can see all the open lines for RMA.Check the line for which you want to create receipt , Update the quantity if required ,
Enter the Subinventory and other details based on your setup Press Save button.
On Save , system will uptomatically submit the "Receiving Transaction Processor" concurrent Program.
Now If you don't want to accept the complete RMA quantity from customer,we can TWO options
1.During Inspection , Reject the quantity that we don't want to accept from customer.
2.Retun the Quantity that we don't want to accept from the customer.
Option -1 : After we Receive the good, Perform the Inspection and then Reject the quantity .
Option -2 : After we receive the good , navigate to > Return , Query for RMA# and then return quantity , also in "Return TO" Enter "Customer".
Navigate to Receiving transaction > Query for RMA # , Please note that now Quantity available for receiving is = Total Quantity - Return Quantity.
Receive the good as required , it will submit the "Receiving Transaction Processor" concurrent Program ,update the inventory , progress workflow from "Wait for receiving activity" and push the credit memo data to AR Interface tables.
Dec 1, 2009
Steps to create RMA in Oracle Apps
Below are simple steps to create RMA in Oracle Apps
Navigation > Receiving > Receipt >Go to Customer Tab > Enter RMA #
Press Find Button
In the receipt Form , you can see all the open lines for RMA.Check the line for which you want to create RMA , Update the quantity if required ,
Enter the Location and other details based on your setup Press Save button.
On Save , system will uptomatically submit the "Receiving Transaction Processor" concurrent Program.This CP on completation update the inventory , progress workflow from "Wait for receiving activity" and push the credit memo data to AR Interface tables as well as update the fulfill quantity on the order lines .
Navigation > Receiving > Receipt >Go to Customer Tab > Enter RMA #
Press Find Button
In the receipt Form , you can see all the open lines for RMA.Check the line for which you want to create RMA , Update the quantity if required ,
Enter the Location and other details based on your setup Press Save button.
On Save , system will uptomatically submit the "Receiving Transaction Processor" concurrent Program.This CP on completation update the inventory , progress workflow from "Wait for receiving activity" and push the credit memo data to AR Interface tables as well as update the fulfill quantity on the order lines .
Subscribe to:
Posts (Atom)