How is add access for a oracle contract created by someone else.

In general contracts are secured by user,to add access a contract follow the screenshot.

Return Requisition to Preparer.

Operations that can be done after approving a requistion can be done by:

Purchasing User -> Auto Create -> Find ->Tools.

Check below screenshot for more info.

Approval Management (AME)

Setup a AME for Oracle Invoice Approval:

1.Query for the particular transaction type. (In this case Payables Invoice Approval)
2.Click on Attributes, to open the attributes screen for that transaction type.

3.Lets create a new attribute using create:

4.Create a new condition based on the attribute by navigating to conditions Tab:

5.Now we have the condition we need to define actions what do you want to do?
Navigate to Approval group tab to define the group to be used in the action:

Dynamic approver:

6.Actions(Navigate to actions type)
we can see that the actions type is associated with the approval group or vice versa.

The Setup part is done now comes the real rules part of all.(linking conditions and actions)
7.
Step 1: enter the name

Step 2: Add your conditions:

Step 3:
Add your actions

Step 4:Review

If there is No Mathcing PO use this approval group for approving the invoice.

End.

Now we are done with the setup of AME.Easy isn't it?

To Get the cost groups and WAC associated with projects.

1.To get Cost Group with a project:

PJM -> Project Definition ->project Parameters

2.To get the WAC from cost group :

INV -> Setup -> Costs -> Cost Groups-M

O2C - Order to Cash Flow.

Order to Cash flow starts with putting in an order in Order Management.

1. Enter an Sales order. A customer puts in a order for an Item. So put the customer details and the Item details/Quantity etc in the Line level. The order is in Entered Status.

Tables : oe_order_headers_all, oe_order_lines_all

2. Book the sales order, the flow status code column will be updated to reflect that the order is booked.

3. A entry is created in wsh_delivery_details in status 'Ready for Release' and the demand interface(Demand Interface) updated the demand in Inventory(MTL_DEMAND).

4. Reservations needs to be created for the Order placed. Reservations program (Schedule Orders) will create the reservations in Inventory.(MTL_RESERVATIONS)

5. Pick Release the Sales Order using 'Release Sales Orders' form, this steps picks the onhand inventory for the order. A delivery is created in this step. (wsh_new_deliveries). A move order is generated to move the order quantity(MTL_TXN_REQUEST_HEADERS/LINES)

6. Complete/Release Move order, which ensures the Pick Confirm for the delivery.

7. Ship Confirm the delivery, this will remove the demand and reservations and closes the order. Also interfaces the order line details into AR Interface (ra_interface_lines_all).

There are so many little details which I will try to add in a while.

PL/SQL

1.How to use a REF CURSOR?

->define TYPE (TYPE L_REF_CURSOR_TYPE IS REF CURSOR)
->define a variable of that type and open for some statement and done.

2.Standards when defining a concurrent program based on a PL/SQL package.

->The proc to be attached need to have first 2 parameters as OUT named(Errbuf OUT NOCOPY VARCHAR2,retCode OUT NOCOPY VARCHAR2)

3.Calling a CONC program from pl/sql->fnd_request.submit(applname,concname,null,null,FALSE,parameters);

Hello All.

Hello to all the vistors of my blog.Here I am to put in my learning of Oracle Applications.If you have any doubts or anything you could reach me on mail.

Cheers.