This appendix lists the setup details for a stand-alone, mobile nonconformance collection plan.
A stand-alone collection plan needs to be created and associated with every mobile transaction where nonconformances can be logged, for example, License Plate Number Inspection.
Create a collection plan with the following elements:
Sequence | Collection Element Name | Prompt |
---|---|---|
10 | Nonconformance Source | Nonconformance Source |
20 | Short Description | Short Description |
30 | Nonconform Severity | Nonconform Severity |
40 | Nonconform Priority | Nonconform Priority |
50 | Nonconformance Type | Nonconformance Type |
60 | Nonconformance Code | Nonconformance Code |
70 | Nonconform Item Type | Nonconform Item Type |
80 | Item | Item |
90 | Revision | Rev |
100 | Quantity | Quantity |
110 | UOM | UOM |
120 | Quantity Nonconforming | Quantity Nonconforming |
130 | Nonconforming UOM | Nonconforming UOM |
140 | Nonconformance Status | Nonconformance Status |
150 | Owner | Owner |
160 | Email Address | Email Address |
170 | Send Email | Send Email |
180 | Entered by User | Entered by User |
190 | Date Opened | Date Opened |
Associate and enable the current plan with the target mobile transaction, for example, License Plate Number Inspection. Additional collection elements can be added to your plan, depending on the transaction.
This action passes the nonconformance information to the Nonconformance Master collection plan, using the QA Results API.
Collection Element: Nonconformance Source
Action Rules
Sequence | Element | Condition |
10 | Nonconformance Source | is entered |
Action this rule invokes: Execute a SQL Script
Token Name | Collection Element |
---|---|
&NCSOURCE | Nonconformance Source |
&ITEMTYPE | Nonconform Item Type |
&ITEM | Item |
&ITEMREV | Revision |
&QTY | Quantity |
&ITEMUOM | UOM |
&NCQTY | Quantity Nonconforming |
&NCUOM | Nonconforming UOM |
&SDESC | Short Description |
&NCSEV | Nonconform Severity |
&NCPRI | Nonconform Priority |
&NCTYPE | Nonconformance Type |
&NCCODE | Nonconformance Code |
&CRE | Created By |
&ORG | Organization |
SQL Text
declare
retval number;
creid number;
CURSOR USERID IS
SELECT USER_ID
FROM FND_USER
WHERE USER_NAME = '&CRE';
begin
INSERT INTO Q_NONCONFORMANCE_MASTER_IV
(
PROCESS_STATUS,
ORGANIZATION_CODE,
PLAN_NAME,
INSERT_TYPE,
NONCONFORMANCE_SOURCE,
NONCONFORM_ITEM_TYPE,
ITEM,
REVISION,
QUANTITY,
UOM,
QUANTITY_NONCONFORMING,
NONCONFORMING_UOM,
SHORT_DESCRIPTION,
NONCONFORM_SEVERITY,
NONCONFORM_PRIORITY,
NONCONFORMANCE_TYPE,
NONCONFORMANCE_CODE
)
values
(
1,
&ORG,
'NONCONFORMANCE MASTER',
1,
&NCSOURCE,
&ITEMTYPE,
&ITEM,
&ITEMREV,
&QTY,
&ITEMUOM,
&SDESC,
&NCSEV,
&NCPRI,
&NCTYPE,
&NCCODE
);
OPEN USERID
FETCH USERID INTO creid;
retval:=fnd_request.submit_request
(
application=>'QA',
program=>'QLTTRAMB',
argument1=>'20',
argument2=>'1',
argument3=>creid,
argument4=>'NO');
commit;
end;
/