Back Button Auto Focus

Source
link

1. Verify that your camera has an AF-On button.  If not, you’ll need to set up the AE/AF-lock button in the custom menus to use it as the AF-On button.  In the Nikon D90, this is custom setting f4.
2. Set the camera’s AF servo mode to Continuous (AF-C).  This is done through the switch next to your lens mount, or via a custom menu setting. D90 users: hold down the AF button on the top of your camera, and turn the Main Command Dial until AF-C is displayed in the top LCD panel.
3. In the camera menus, go to submenu “a” (Autofocus)
4. Set custom setting a1 (Continuous Release Mode) to Release Priority (in the D90, this is already set for you when you choose continuous servo AF mode)
5. Find the custom setting for AF Activation (a5 on the D3s) and set it to AF-On Only. This step is not necessary for the D90 and other cameras, as it is already set up by custom setting f4.

Now you’re all set up and ready to go.

HOW TO USE THE AF-ON TECHNIQUE IN THE FIELD

To emulate single-servo mode (focus/recompose/shoot)

1. Place the active AF point on your subject
2. Press the AF-On button to acquire focus
3. Release the AF-On button to lock focus
4. Recompose and shoot

To focus continuously on a moving subject

1. Place the active AF point on the subject
2. Press the AF-On button
3. Keep the AF-On button pressed to track focus while simultaneously pressing the shutter release
4. Remember to initiate the VR system (if your lens supports it) by half-pressing the shutter button prior to releasing the shutter.  Remember, VR takes about a half-second to stabilize, so you’ll want to anticipate your subject.

Now that you understand how to use the technique, you’ll want to spend some time practicing.  It usually takes about a day of shooting in the field to get used to the new technique.  Once you know how to use it, the AF-On only method of focusing will help you get more “keeper” shots.

OM Flow with Tables

Order Management Tables.

Entered
oe_order_headers_all 1 record created in header table
oe_order_lines_all Lines for particular records
oe_price_adjustments When discount gets applied
oe_order_price_attribs If line has price attributes then populated
oe_order_holds_all If any hold applied for order like credit check etc.

Booked

oe_order_headers_all Booked_flag=Y Order booked.
wsh_delivery_details Released_status Ready to release

Pick Released

wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)
wsh_picking_batches After batch is created for pick release.
mtl_reservations This is only soft reservations. No physical movement of stock

Full Transaction

mtl_material_transactions No records in mtl_material_transactions
mtl_txn_request_headers
mtl_txn_request_lines

wsh_delivery_details Released to warehouse.
wsh_new_deliveries if Auto-Create is Yes then data populated.
wsh_delivery_assignments deliveries get assigned

Pick Confirmed

wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock

Ship Confirmed

wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged
mtl_material_transactions On the ship confirm form, check Ship all box
wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped

oe_order_lines_all Shipped_quantity get populated.
wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all If all the lines get shipped then only flag N

Autoinvoice

wsh_delivery_details Released_status=I Need to run workflow background process.
ra_interface_lines_all Data will be populated after wkfw process.
ra_customer_trx_all After running Autoinvoice Master Program for
ra_customer_trx_lines_all specific batch transaction tables get populated

Price Details

qp_list_headers_b To Get Item Price Details.
qp_list_lines
Items On Hand Qty
mtl_onhand_quantities TO check On Hand Qty Items.

Payment Terms

ra_terms Payment terms

AutoMatic Numbering System

ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.

Customer Information

hz_parties Get Customer information include name,contacts,Address and Phone
hz_party_sites
hz_locations
hz_cust_accounts
hz_cust_account_sites_all
hz_cust_site_uses_all
ra_customers

Document Sequence

fnd_document_sequences Document Sequence Numbers
fnd_doc_sequence_categories
fnd_doc_sequence_assignments
Default rules for Price List
oe_def_attr_def_rules Price List Default Rules
oe_def_attr_condns
ak_object_attributes
End User Details
csi_t_party_details To capture End user Details

Sales Credit Sales Credit Information(How much credit can get)

oe_sales_credits

Attaching Documents

fnd_attached_documents Attched Documents and Text information
fnd_documents_tl
fnd_documents_short_text

Blanket Sales Order

oe_blanket_headers_all Blanket Sales Order Information.
oe_blanket_lines_all

Processing Constraints

oe_pc_assignments Sales order Shipment schedule Processing Constratins
oe_pc_exclusions
Sales Order Holds
oe_hold_definitions Order Hold and Managing Details.
oe_hold_authorizations
oe_hold_sources_all
oe_order_holds_all

Hold Relaese

oe_hold_releases_all Hold released Sales Order.

Credit Chk Details

oe_credit_check_rules To get the Credit Check Againt Customer.

Cancel Orders

oe_order_lines_all Cancel Order Details.


Source

BULK COLLECT FORALL ROLLBACK

Source


OPEN c_dept_data;
LOOP
FETCH c_dept_data BULK COLLECT INTO vrt_dept_id,vrt_dept_name LIMIT 1000;

FORALL i IN 1 .. vrt_dept_id.COUNT
UPDATE departments_tmp
SET dept_name = vrt_dept_name(i)
WHERE dept_id = vrt_dept_id(i);

EXIT WHEN c_dept_data%NOTFOUND;
END LOOP;
CLOSE c_dept_data;
...


Rollback behavior
If one of the bulk DML statements fails, the individual statement is rolled back and previous DML statements within the FORALL series of statements are not rolled back and the FORALL statement stops executing.
For example if you are using FORALL to insert 100 rows and an error appears on 78th row the execution will stop and rows from 78 to 100 will not be inserted indeed. If you want to overcome this behavior and to insert all rows you can use the SAVE EXCEPTIONS clause.
With the SAVE EXCEPTIONS the cursor attribute SQL%BULK_EXCEPTIONS is used. It is an array that records two elements ERROR_INDEX and ERROR_CODE:

...
v_bulk_errors EXCEPTION;
PRAGMA EXCEPTION_INIT (v_bulk_errors, -24381);
…
BEGIN -- outer BEGIN
…
BEGIN –- inner BEGIN clause
OPEN c_dept_data;
LOOP
FETCH c_dept_data BULK COLLECT INTO vrt_dept_id,vrt_dept_name;

FORALL i IN 1 .. vrt_dept_id.COUNT
SAVE EXCEPTIONS
UPDATE departments_tmp
SET dept_name = vrt_dept_name(i)
WHERE dept_id = vrt_dept_id(i);

EXIT WHEN c_dept_data%NOTFOUND;
END LOOP;
CLOSE c_dept_data;

EXCEPTION WHEN bulk_errors THEN
FOR i in 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
Dbms_output.put_line(
'An error '|| i ||' was occured ' ||
SQL%BULK_EXCEPTIONS(i).ERROR_INDEX ||
' during update of dept_id: '||
vrt_dept_id(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX)||
'. Oracle error: ' ||
SQLERRM(-1 * SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
END LOOP;

END; -- end inner BEGIN

In this case the collection variables will be populated on every 1000 rows, after that the FORALL will be executed for them and then will be fetched the next 1000. Be aware of that the previous values for the collection are overwritten.
The other workaround to cope with memory problems coming from large PL/SQL tables is to execute the following supplied stored procedure inside your code:

..
dbms_session.free_unused_user_memory;
..

It will free unused memory for your session after large portions of data was processed. For full details about solving of memory problems with this procedure, see: Procedure DBMS_SESSION.FREE_UNUSED_USER_MEMORY Specification
You can use the SQL%BULK_ROWCOUNT attribute, which is available with the FORALL statement. For each processed row in FORALL there is a corresponding row for this attribute. For example, if you want to know did the n-th processed row from FORALL have affected some rows then you must call SQL%BULK_ROWCOUNT(n). If no rows were affected, the n-th row will be zero.

Discrete Label Types and Business Flows

The following table provides a list of the various business flows and the types of labels that you can associate with each flow. The horizontal header row of the table lists the various label types that are available. The far left vertical column lists the warehouse-related business flow. Yes indicates that the system can generate the label type for that business flow. No means that the system does not generate that label type for the business flow.

Discrete Label Types and Business Flows

Bus. Flow	Mat'l	Serial	LPN	LPN Cont.	LPN Sum	LOC	Ship	Ship Cont.	WIP Cont.	Flow Cont.	WIP Move Cont.
Receipt	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Inspection	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Deliver	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Receiving Put away drop	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
LPN Correction / update	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Sales order Cross-Dock	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	No	No
Replen. drop	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Cycle count	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Phys. Count	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Mat. Stat. Update	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
Cost Group Update	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Lot Split / Merge	Yes	Yes	Yes	Yes	No	No	No	No	No	No
Misc / Alias Receipt	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Inter-org Xfer	Yes	Yes	Yes	Yes	No	No	No	No	No	No
Sub. Xfer	Yes	Yes	Yes	Yes	No	No	No	No	No	No
LPN Gen.	No	No	Yes	No	No	No	No	No	No	No
Serial Gen.	No	Yes	No	No	No	No	No	No	No	No
Pick Load	Yes	No	Yes	Yes	Yes	No	Yes	Yes	No	No
Pick Drop	Yes	No	Yes	Yes	Yes	No	Yes	Yes	No	No
Pack / unpack / update LPN	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Ship Con.	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	No	No
Cartonization.	Yes	No	Yes	Yes	Yes	No	Yes	Yes	No	No
Misc. / Alias Issue	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Dyn. Loc	No	No	No	No	No	Yes	No	No	No	No
Import ASN	No	No	Yes	Yes	Yes	No	No	No	No	No
WIP Comp.	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Put. Pregen.	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
WIP Pick Load	Yes	No	Yes	Yes	No	No	No	No	Yes	No
WIP Pick Drop	Yes	No	Yes	Yes	No	No	No	No	Yes	No
Inv. Put. drop	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Flow Line Start	No	No	No	No	No	No	No	No	No	Yes
Flow Line Op.	No	No	No	No	No	No	No	No	No	Yes
Flow / Work ord. Assem. Comp.	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Replen. Load	Yes	No	Yes	Yes	Yes	No	Yes	Yes	No	No
WIP / Flow Put Away Drop	No	No	No	No	No	No	No	No	No	Yes
Pck. Wrkbch	No	No	Yes	Yes	Yes	No	Yes	Yes	No	No
Manufacturing Cross-Dock	Yes	Yes	No	No	No	No	No	No	Yes	No
Pick Release	No	No	No	No	No	No	No	Yes	No	No	No
Replen. Drop	No	No	No	Yes	No	No	No	No	No	No	No
Flow Line Start	No	No	No	No	No	No	No	No	No	Yes	No
WIP Move Job Txn	No	No	No	No	No	No	No	No	No	No	Yes

From the previous tables, the following business flows are also supported in the Mobile Supply Chain Applications (MSCA):

• Receipt
• Inspection
• Delivery
• Replenishment Drop
• Cycle Count
• Physical Count
• Miscellaneous/Alias Receipt
• Inter-Org Transfer
• Subinventory Transfer
• Serial Generation
• Pick Load
• Pick Drop
• Ship Confirm
• Miscellaneous/Alias Issue
• Dynamic Locator
• WIP Completion
• Process Dispensing
• Process Production
• Process Quality
• WIP Move Contents
  

Oracle Change/Modify PO Print Logo XSL-FO

SOURCE
Changing the Logo on PO Print is a little tricky. I say tricky purely because even though the PO Print program is a XML Publisher based report the layout part of the report is XSL-FO type. So all the details are in XML.

--------------------------------------------------------
Note: For doing this we need to have XML Publisher template builder installed. Pls follow the below instructions

Download the patch from Metalink. Latest version as of today is Patch 12395372: UPDATE FOR BI PUBLISHER DESKTOP 10.1.3.2.1 (5.6.3) size = 95.9 MB Product=BI Publisher (formerly XML Publisher)

Unzip this patch and then run BIPublisherDesktop.exe to install in a directory
--------------------------------------------------------
So lets get to the task.

Step 1: Create an RTF Document and embed the image into the document. I create a MSWord document and 'Save As' RTF document. And in Word (Menu)Insert -> Picture -> From File -> Select the image.

Step 2: Update the size of image to approx the size it appears in the document.

Step 3: Once you have template builder installed, the plug-in adds new menu options in Word. Tools -> Export -> XSL-FO Style Sheet. Screenshot attached

Step 4: An XML file is generated, Open the file and search for tag 'fo:instream-foreign-object' tag which is of our interest.

Step 5: Copy the tag contents from the beginning to the end of the tag 'fo:instream-foreign-object'. So this is our image xdofo:uid 

Step 6: Open XML Publisher, Search for Template 'Standard Purchase Order Stylesheet', Duplicate the template entering required details. Download PO_STANDARD_XSLFO.xsl and rename to XXC_PO_STANDARD_XSLFO.xsl

Step 7: Open XXC_PO_STANDARD_XSLFO.xsl and search for 'fo:inline' which contains the Logo info. Uncomment the inline tags and replace the 'fo:external-graphic content' with the tags contents we copied in step 5.

The file should look like this.

Step 8: Save XXC_PO_STANDARD_XSLFO.xsl and attach the file to the template we created in Step 6. Also update the xsl:style sheet definition(at the beginning of the document) to refer to xdo namespace as follows.

'xsl:stylesheet version="1.0" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:ora="http://www.oracle.com/XSL/Transform/java/" xmlns:xdofo="http://xmlns.oracle.com/oxp/fo/extensions" xmlns:xdoxliff="urn:oasis:names:tc:xliff:document:1.1" xmlns:xdoxslt="http://www.oracle.com/XSL/Transform/java/oracle.apps.xdo.template.rtf.XSLTFunctions" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"' 

Step 9: Attach the new template to PO Document Types. (Document Type Layout), so the new template will be picked for the PO document creation

Step 10: For this article purpose lets simply the process and see if we can get the PO Document with the new Logo, by using the preview button in XML Publisher(for the new template we created in Step 6).Here we have it.

R12.2 Links

Oracle E-Business Suite Release 12.2 Information Center - Documentation

Doc ID 1583110.1

http://docs.oracle.com/cd/V39571_01/current/html/docset.html