Category Archives: Oracle Apps

Assemble To Order

Go to Routing:

ATO16

Change the Status to Release:

Save the Job:

ATO17

Once Released go to Move Transactions:

ATO18

Create a Move Transaction as below:

ATO19

Save the Record.

Go to Complete WIP Transactions form:

ATO20

Search by Job Number:

ATO21

Continue next:

Enter the Quantity and Done:

ATO22

The ATO booking the Order is Done.

Assemble-To-Order-1

Related posts:

Assemble To Order

Once the Order is progressed make the item Create Configuration Eligible:

ATO10

ATO11

Once we Progress the Order for this line a new concurrent program is kicked off:

ATO12

See the Output:

ATO13

The AutoCreate Final Assembly Orders concurrent program has created a WIP job against the sales order. You can use the WIP Job Number to release the job and complete WIP related transactions.

Find the Discrete Job:

ATO14

Find the Discrete Job which we got from the Standard Concurrent Request which is 256635.

ATO15

Assemble-To-Order-3

Assemble-To-Order-1

Related posts:

Assemble To Order

Enter a Sales Order with ATO Items:

An ATO Item (model) is an item that for which you open a final assembly order to assemble items in response to customer’s orders. Assemble To Order (ATO) is also an item attribute that you can apply to standard, model, and option class items.

Add Order Management Super User, Vision Operations (USA) Responsibility for your User:

ATO1

Go to Sales Orders Form:

ATO2

Enter Customer Number as 1608, and all the other fields are defaulted from the defaulting rules:

ATO3

In others tab Payment Terms, Warehouse, Sales Channel, etc. are defaulted.

ATO4

Go to Line Items: Enter the Ordered Item as CN97444 which is an ATO (Assemble To Order) model in the Ordered Item field. You will need to select the option items and included items using the Configurator page.

ATO5

When Configurator button is pressed and OAF page is opened which give the option to select the items:

ATO6ATO7

Once Selection is done finish the configuration. Once Configuration is done the Sales Order is shown as below.  Once done Book the Order and make sure the Line Type is Standard (Line Invoicing).

ATO8

Once the Order is Booked go to line items and right click on the PTO Item and Progress the Order. The same can be achieved from Actions:

ATO9

Assemble-To-Order2

Related posts:

Create Location Assignment API

TCA Create Location Assignment API

Name of the API : UPDATE CUSTOMER PROFILE
Base Tables Affected : HZ_LOC_ASSIGNMENTS
PL/SQL Procedure used : CREATE_LOC_ASSIGNMENT
Package Used : HZ_TAX_ASSIGNMENT_V2PUB
Mandatory Parameters :
Parameter Name Parameter Type Data Type
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE
p_location_id IN NUMBER
p_lock_flag IN VARCHAR2:= FND_API.G_FALSE
p_created_by_module IN VARCHAR2
p_application_id IN NUMBER
x_return_status IN OUT VARCHAR2,
x_msg_count OUT NUMBER
x_msg_data OUT VARCHAR2
x_loc_id OUT NUMBER

Procedure:

 General Tips for Running the Create Location Assignment API:

a) Save the API in a script file and then run the script from the SQL Prompt (Example : RUN create_loc_assignment.sql)
b) Set the organization id before running the script as :
EXEC fnd_client_info.set_org_context(‘<orgid>’); for 11i
OR For R12
EXEC mo_global.init (‘AR’);
EXEC mo_global.set_org_context(<org_id>, NULL, ‘AR’);
EXEC fnd_global.set_nls_context(‘AMERICAN’);
EXEC mo_global.set_policy_context(‘S’, <org_id>);
c) Enter the value of the Parameter Location_Id as a value which exists in HZ_LOCATIONS table.

Example For Running Create Location Assignment API:

 Sample Output of the Create Location Assignment Script:

x_return_status = S
Location Id = 29266
Created By Moudle = TCA_V2_API
x_msg_count = 0
x_msg_data =

Script To Verify whether the Create Location Assignment API is successful:

 

Related posts:

Update Customer Profile API

TCA Update Customer Profile API

Name of the API : UPDATE CUSTOMER PROFILE
Base Tables Affected : HZ_CUSTOMER_PROFILES
PL/SQL Procedure used : UPDATE_CUSTOMER_PROFILE
Package Used : HZ_CUSTOMER_PROFILE_V2PUB
Mandatory Parameters :
Parameter Name Parameter Type Data Type
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_customer_ profile_rec IN CUSTOMER_ PROFI LE_ REC_ TYPE,
p_object_version_number IN OUT NUMBER,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2

Procedure:

General Tips for Running the Update Customer Profile API:

a) Save the API in a script file and then run the script from the SQL Prompt (Example : RUN update_customer_profile.sql)
b) Set the organization id before running the script as :
EXEC fnd_client_info.set_org_context(‘<orgid>’); for 11i
OR For R12
EXEC mo_global.init (‘AR’);
EXEC mo_global.set_org_context(<org_id>, NULL, ‘AR’);
EXEC fnd_global.set_nls_context(‘AMERICAN’);
EXEC mo_global.set_policy_context(‘S’, <org_id>);

Example For Running Update Customer Profile API:

 Sample Output of the Update Customer Profile Script:

x_return_status = S
Object Version Number = 2
Credit Rating = Excellent
x_msg_count = 0
x_msg_data =

Script To Verify whether the Update Customer Profile API is successful:

 

Related posts: