Form: "Run Reports"
Parameter:
1. REQUEST_GROUP_CODE="AR_CREATE_ACCOUNTING" REQUEST_GROUP_APPL_SHORT_NAME="AR" TITLE="AR:AR_ACCT_EXEC"
2. CONCURRENT_PROGRAM_NAME ="RACUST" PROGRAM_APPL_SHORT_NAME="AR" TITLE="AR:AR_SRS_TITLE_CUST_INTERFACE"
3.TITLE="CMI:CMI_LAUNCH_SIM_GPA_LOAD" USE_ORG="N" CONCURRENT_PROGRAM_NAME="CMIGPASLOAD" PROGRAM_APPL_SHORT_NAME="CMI"
Use of the API FND_PROFILE
It is used to perform various actions related to profile values through PL/SQL. Some of the important ones are listed below
1. FND_PROFILE.GET(‘Name of the Profile’, variable name);
Example
SELECT fnd_profile.value('PROFILEOPTION')
,fnd_profile.value('MFG_ORGANIZATION_ID')
,fnd_profile.value('ORG_ID')
,fnd_profile.value('LOGIN_ID')
,fnd_profile.value('USER_ID')
,fnd_profile.value('USERNAME')
,fnd_profile.value('CONCURRENT_REQUEST_ID')
,fnd_profile.value('GL_SET_OF_BKS_ID')
,fnd_profile.value('SO_ORGANIZATION_ID')
,fnd_profile.value('APPL_SHRT_NAME')
,fnd_profile.value('RESP_NAME')
,fnd_profile.value('RESP_ID')
FROM DUAL;
The server-side package FND_GLOBAL returns the values of system globals, such as the login/signon or “session” type of values. You should not use FND_GLOBAL routines in your forms (that is on the client side). On the client side, most of the procedures in the FND_GLOBAL package are replaced by a user profile option with the same (or a similar) name. You should use FND_PROFILE routines in your forms instead.
1) select table_name from all_tables
2) select view_name from all_views
3) select distinct type from all_source
where name = 'CUX_SEND_MAIL_PKG'
and type = 'PACKAGE BODY'
order by line;
TYPE:
PACKAGE BODY
TYPE BODY
TRIGGER
PACKAGE
PROCEDURE
FUNCTION
LIBRARY
TYPE
JAVA SOURCE
1) Fnd_Flex_ext.get_ccid
--return CCID or 0 when flexfield segment ACCOUNT does
not exist in the value set TTI_ACCOUN
DECLARE
p_ccid
NUMBER;
BEGIN
p_ccid :=
Fnd_Flex_ext.get_ccid(application_short_name
=>
'SQLGL',
key_flex_code =>
'GL#',
structure_number =>
50190,
validation_date =>
to_char(SYSDATE,
'YYYY/MM/DD HH24:MI:SS'),
concatenated_segments =>
'B1.21399.00.6733.000000.00000000.11.00.0000.000');
IF p_ccid <>
'0'
THEN
DBMS_OUTPUT.PUT_LINE(
p_ccid);
ELSE
DBMS_OUTPUT.PUT_LINE(
FND_FLEX_EXT.GET_MESSAGE)
;
END IF;
END;
====================================================================
2) fnd_flex_keyval.validate_segs
--return true or false &
get ccid by FND_FLEX_KEYVAL.COMBINATION_ID()
BEGIN
IF fnd_flex_keyval.validate_segs(
operation =>
'CREATE_COMBINATION'
-- CHECK_COMBINATION, FIND_COMBINATION
,
appl_short_name =>
'SQLGL'
-- 請根據情況自行修改
,
key_flex_code =>
'GL#'
-- 請根據情況自行修改
,
structure_number => 50190
-- 請根據情況自行修改
,
concat_segments =>
'B1.21299.00.6733.000000.00000000.11.00.0000.000')
THEN
DBMS_OUTPUT.PUT_LINE(
(FND_FLEX_KEYVAL.COMBINATION_ID()));
--.concatenated_descriptions());
ELSE
DBMS_OUTPUT.PUT_LINE(
FND_FLEX_KEYVAL.ERROR_MESSAGE)
;
END IF;
END;
1、Check Combination:
IF (NOT fnd_flex_keyval.validate_segs(operation => 'CHECK_COMBINATION',
appl_short_name => 'SQLGL',
key_flex_code => 'GL#',
structure_number => 50394,
concat_segments => '0.0.530101.0.0.1006001.0.0',
validation_date => sysdate)) THEN
-- return the error message
RETURN fnd_flex_keyval.error_message;
END IF;
2. Create Combination:
1) fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
key_flex_code => 'GL#',
structure_number => l_id_flex_num,
validation_date => to_char(SYSDATE,
apps.fnd_flex_ext.DATE_FORMAT),
concatenated_segments => x_concatenated_seg);
2: fnd_flex_keyval.validate_segs('CREATE_COMBINATION' --'CREATE_COMB_NO_AT'
,'SQLGL'
,'GL#'
,lv_chart_of_accounts_id
,lv_concatenated_segments);
| Step | Order Header Status | Order Line Status | Order Flow Workflow Status (Order Header) | Line Flow Workflow Status (Order Line) | Shipping Transaction Status(RELEASED_STATUS in WDD) |
|---|---|---|---|---|---|
| 1. Enter an Order | Entered | Entered | Book Order Manual | Enter – Line | N/A |
| 2. Book the Order | Booked | Awaiting Shipping | Close Order | Schedule ->Create Supply ->Ship – Line | Ready to Release(R) |
| 3. Pick the Order | Booked | Picked | Close Order | Ship – Line | 1.Released to Warehouse(S)(Pick Release but not pick confirm) 2.Staged/Pick Confirmed(Y)(After pick confirm) |
| 4. Ship the Order | Booked | Shipped | Close Order | Fulfill – Deferred | 1.Shipped(After ship confirm) 2.Interfaced(C)(After ITS) |
| Booked | Closed | Close Order | Fulfill ->Invoice Interface ->Close Line -> End | ||
| 5. Close the Order | Closed | Closed | End | End |
Re-open Inventory accounting period
R11.
BG - Business Group
SOB - Set of Book
LE - Legal Entity
OU - Operation Unit
Org - Organization
R12.
BG - Business Group
LE - Legal Entity
SOB - Set of Book
OU - Operation Unit
Org - Organization
1) Supplier & Customer are belonged to OU level , difference OU only can see header information.
2) MOAC(multi-org access control) can make one responsibility to see whole supplier information.
--期初結帳找不到採購行為
open procedure:
CSTPPAHK.acq_receipt_cost_hook
edit:
a) Change o_error_num := -1 to o_error_num := 0;
b) Change o_hook_cost := 0 to
eTRM - Technical Reference
see information through below website
http://etrm.oracle.com/pls/trm1222p/etrm_fndnav.ls_object
