Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Wednesday, January 19, 2011

[SYS] Security Rule - Block From Entering, What About Viewing?

You can enter only certain range of Cost Center once you set Security Rule up, but you CAN still view the document (e.g. PR Summary) that was created using a Cost Center that is out of you range in Security Rule.

[PO] Position Hierarchy Used for PR/PO Approval

A PR/PO was submitted for approval, how to check which Position Hierarchy user used? From Apps front end, it is impossible. Check it out from backend tables.

Sample codes:

SELECT approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT requisition_header_id FROM apps.PO_REQUISITION_HEADERS_ALL WHERE segment1='myPRNumber')

Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.

[PO] Receiving for PO with Status "Requires Reapproval"

Standard Purchase Order with 3 lines. I changed line 1 quantity. Header status changed to "Requires Reapproval". In normal scenario, I cannot do anymore Receiving activity as the status is not Approved. If my changes involved price and currency, receiving activity will generate accounting entries with wrong amount. A control is needed.

However, for a particular PO, I am able to perform receiving. The PO with "Requires Reapproval" appeared in the LOV when i tried to perform receiving. I can proceed further to next screen. However, the line i changed (line 1) is not appearing. Only the lines that i did not change appeared and allow me to do receiving. Why?

The reason being the PO is an consigned PO, which has consigned item (doubled check it from Shipment). System allows receiving for the unchanged line because receiving activity for consigned PO will NOT generate any accounting entries, no impacts. Furthermore, transaction price does not refer to PO, but BPA.

[SYS] Login Page Filled with User ID Automatically

For normal scenario, you type in the URL for Oracle Apps instance, click Apps Logon Links, then E-Business Home Page, enter your Username andPassword, you will see the HTML (jsp) menus.

To simplify the steps, you first login to HTML menus, click logout, copy the URL from the Address field in your browser. That is the address you use to access the login page, with your Username defaulted.

Tuesday, January 18, 2011

[PO] Exchange Rate for A New Line

I have a PO create months back, exchange rate was captured at the header level. If i add a new po line now, previous captured rate will be applied to the line, shipment and distribution, not today's rate.

Double check the exchange rate on Distributions line, under "More" tab.