XDO Tables - XML Publisher report queries XDO_DS_DEFINITIONS_B XDO_DS_DEFINITIONS_TL XDO_TEMPLATES_B XDO_TEMPLATES_TL XDO_LOBS XDO_FONT_MAPPINGS XDO_FONT_MAPPING_SETS_B XDO_FONT_MAPPING_SETS_TL select * from XDO_DS_DEFINITIONS_B where data_source_code = 'Data source short code' select * from XDO_DS_DEFINITIONS_TL where rownum < 3 select * from XDO_TEMPLATES_B where TEMPLATE_CODE = 'Template Short code' select * from XDO_TEMPLATES_TL where TEMPLATE_CODE = 'Template Short code' select ...
XML Publisher Reports oracle Apps Overview XML Publisher, which is also called Oracle Business Intelligence Publisher (BI Publisher), is a template-based reporting tool that leverages standard technologies for data extraction and display. Business users can build the layout and rules for the report themselves by using common desktop tools. Development engineers can concentrate ...
How to Use FNDLOAD? It is merely time consuming task to create same setup data on each instance separately. Hence to migrate setup data from 1 instance to other (Eg. From DEV to PROD), ldt & lct files are used. LDT (Data Loader Files)- This files are Used to upload & download setup data on different instances. LCT (Data Config Files)- This files are used to create LDT Files. There are difference lct files for different sets of data. Eg: Value Set- afffload.lct,Request Set- ...
How to Uncheck ignore for planning flag using "wsh_deliveries_pub.delivery_action" API
DECLARE
l_delivery_id NUMBER;
l_delivery_detail_id NUMBER;
-- MO_GLOBAL.init('ONT');
l_init_msg_list VARCHAR2(1000);
l_return_status VARCHAR2(1000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);
l_trip_id VARCHAR2(1000);
l_trip_name VARCHAR2(1000);
v_counter NUMBER;
p_api_version NUMBER;
p_init_msg_list VARCHAR2(200);
p_commit VARCHAR2(200);
p_validation_level NUMBER;
p_tabofdeldets apps.wsh_delivery_details_pub.id_tab_type;
p_action VARCHAR2(200);
p_delivery_id NUMBER;
p_delivery_name VARCHAR2(200);
p_count NUMBER;
v_context VARCHAR2(100);
x_return_status VARCHAR2(200);
x_msg_count NUMBER;
x_msg_data VARCHAR2(4000);
CURSOR ignore_for_plan_cur IS SELECT DISTINCT
wnd.organization_id,
wnd.ship_method_code,
wnd.status_code,
wnd.name,
wnd.delivery_id,
wdd.delivery_detail_id
FROM
wsh_new_deliveries wnd,
wsh_delivery_details wdd,
fnd_lookup_values_vl flv,
wsh_delivery_assignments wda
WHERE
wnd.organization_id =:p_org_id
AND wnd.ignore_for_planning = 'Y'
AND upper(flv.lookup_code) = upper(wnd.ship_method_code)
AND flv.lookup_type = 'SHIP_METHOD'
AND upper(flv.attribute1) <> upper('yes')
AND wdd.released_status IN (
'N',
'R',
'S',
'Y',
'B',
'X'
)
AND upper(wnd.status_code) <> upper('CL')
AND wda.delivery_id = wnd.delivery_id
AND wda.delivery_detail_id = wdd.delivery_detail_id;
-- AND wnd.DELIVERY_ID IN (126064);
BEGIN
FOR ignore_plan_rec IN ignore_for_plan_cur LOOP
fnd_file.put_line(fnd_file.log,'Unchecking the flag' || ignore_plan_rec.delivery_id);
wsh_deliveries_pub.delivery_action(
p_api_version_number => 1
,p_init_msg_list => l_init_msg_list
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
,p_action_code => 'INCLUDE_PLAN'
,p_delivery_id => ignore_plan_rec.DELIVERY_ID
,p_delivery_name=>ignore_plan_rec.NAME
,p_asg_trip_id=> null
,p_asg_trip_name=> null
,p_asg_pickup_stop_id=> null
,p_asg_pickup_loc_id=> null
,p_asg_pickup_stop_seq=> null
,p_asg_pickup_loc_code=> null
,p_asg_pickup_arr_date=> null
,p_asg_pickup_dep_date=> null
,p_asg_dropoff_stop_id=> null
,p_asg_dropoff_loc_id=> null
,p_asg_dropoff_stop_seq=> null
,p_asg_dropoff_loc_code=> null
,p_asg_dropoff_arr_date=> null
,p_asg_dropoff_dep_date=> null
,p_sc_action_flag=> null
,p_sc_intransit_flag=> null
,p_sc_close_trip_flag=> null
,p_sc_create_bol_flag=> null
,p_sc_stage_del_flag=> null
,p_sc_trip_ship_method=> null
,p_sc_actual_dep_date=> null
,p_sc_report_set_id=> null
,p_sc_report_set_name=> null
,p_sc_defer_interface_flag=> null
,p_sc_send_945_flag=> null
,p_sc_rule_id=> null
,p_sc_rule_name=> null
,p_wv_override_flag=> null
,x_trip_id => l_trip_id
,x_trip_name => l_trip_name
);
COMMIT;
END LOOP;
END;
END;
Oracle Apps Interview question related to Multi Org 1. What is Multi Org Architecture?The Multiorg Architecture is meant to allow multiple companies or subsidiaries to store their records within a single database.The multiple Organization architecture allows this by partitioning data through views in the APPS schema. Multiorg also allows you to maintain multiple sets of books. Implementation of multiorg generally includes defining more than one Business Group. 2. How can I know if I am using ...
Purchase Requisition without a Purchase Order ============================================== SELECT prh.segment1 "PR NUM", TRUNC (prh.creation_date) "CREATED ON", TRUNC (prl.creation_date) "Line Creation Date", prl.line_num "Seq #", msi.segment1 "Item Num", prl.item_description "Description", prl.quantity "Qty", TRUNC (prl.need_by_date) "Required By", ppf1.full_name ...
PURCHASE REQUISITION WITHOUT PO SELECT prh.segment1 "PR NUM", TRUNC (prh.creation_date) "CREATED ON", TRUNC (prl.creation_date) "Line Creation Date", prl.line_num "Seq #", msi.segment1 "Item Num", prl.item_description "Description", prl.quantity "Qty", TRUNC (prl.need_by_date) "Required By", ppf1.full_name "REQUESTOR", ppf2.agent_name "BUYER" FROM po.po_requisition_headers_all prh, po.po_requisition_lines_all prl, apps.per_people_f ppf1, ( SELECT DISTINCT agent_id, agent_name FROM apps.po_agents_v) ...
PO details query in oracle apps R12 SELECT HOU.SHORT_CODE OU, PHA.CREATION_DATE PO_CREATION_DATE, PHA.APPROVED_DATE PO_APPROVED_DATE, NVL(PRH.INTERFACE_SOURCE_CODE, PRH.APPS_SOURCE_CODE) REQUISITION_SOURCE, ...
