Transactions AND Average Costing

Source

The following table indicates whether specific transactions update the average unit cost of an item.

Transactions	Update Average
Purchase Order Receipt to Receiving Inspection	No
Delivery from Receiving Inspection to Inventory	Yes
Purchase Order Receipt to Inventory	Yes
Return to Supplier from Receiving	No
Return to Supplier from Inventory	Yes
Miscellaneous Issue	No (if default cost is used)
Miscellaneous Receipt	No (if default cost is used)
Shipment Transaction/FOB Receipt	No
Shipment Transaction/FOB Shipment: Sending Org	No
Shipment Transaction/FOB Shipment: Receiving Org	Yes
Receipt Transaction/FOB Receipt: Sending Org	No
Receipt Transaction/FOB Receipt: Receiving Org	Yes
Receipt Transaction/FOB Shipment	No
Direct Inter-Organization Transfer: Sending Org	No
Direct Inter-Organization Transfer: Receiving Org	Yes
Cycle Count	No
Physical Inventory	No
Sales Order Shipments	No
RMA Receipts	Yes
RMA Returns	No
Average Cost Update	Yes

Note: The accounts in average costing transactions are the default accounts when average costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.

Source 

We're going to:

1. Create a Bursting Control File to email Suppliers
2. Upload the control file to the Data Definition
3. Test it out by calling the XML Publisher Report Bursting Program
4. (Optional) Extend the Report to automatically submit the Bursting program

At this point please make sure you have done the following EBS bursting prerequisite steps:

• (Optional, but highly recommended) Upgrade to 11.5.10.2 / XMLP 5.6.3 or higher (ATG RUP5 or higher is nice)
• Apply 5968876 XDO:EBS-BURSTING INTEGRATION PATCH
• Restarted your applications processes - or the button to upload your bursting control file won't appear!
• Set the Temporary Directory under XML Publisher Administrator, Administration, General - to e.g. /tmp, or you'll get error message:

Bursting Control File

Next, lets get into the Bursting control file and look at it a bit closer:
1. Create Bursting Control File to email Suppliers custom Separate Remittance Advice 

subject="Virtuate - Remittance Advice for Payment ${C_CHECK_NUMBER}">
Please find attached Remittance Advice for payment ${C_CHECK_NUMBER}.

Regards,
The Payables Team
Virtuate Limited

  

Hmm, what does all this jargon in the control file do? Well, here's a pretty picture that explains a lot of it: 




Make sure it all works ... gotta make sure its the right flavor!
Navigate into Payables, Submit Request, XML Publisher Report Bursting Program, and specify the request from your last custom Separate Remittance Advice request. 



Add code to after report trigger to automate bursting

declare
    v_req_id number := 0;
  begin
    if nvl(:p_burst,'N') = 'Y' then
      v_req_id := xxv8_xmlp_burst_pkg.submit_request_burst('XXV8_APXPBSRA',:p_conc_request_id);
      if v_req_id > 0 then
        srw.message(20002, 'Submitted request_id ' || v_req_id);
        commit;
      else
        srw.message(20002, 'Failed to submit request');
      end if;
    end if;
  end;

create or replace package body XXV8_XMLP_BURST_PKG AS
function submit_request_burst
( p_code in varchar2
, p_request_id in number
) return number
is
  l_req_id number := 0;
begin
  if p_code = 'XXV8_APXPBSRA' then
    l_req_id := fnd_request.submit_request('XDO','XDOBURSTREP',NULL,NULL,FALSE,
                                           p_request_id);
  end if;
  return l_req_id;
end submit_request_burst;

end XXV8_XMLP_BURST_PKG;
/

Research Files

phillipcapital

pdf site:motilaloswal.com/


https://sensibleinvestingblog.wordpress.com

https://oreng.co.in

https://equitylensman.blogspot.com - @chiragdashj


https://www.plindia.com/LatestReports.aspx

https://dialwealth.wordpress.com/

https://investorpicks100.blogspot.com


https://valuationinmotion.blogspot.com

https://eightytwentyinvestor.com

https://www.rupeeiq.com

https://finception.in

https://www.munafasutra.com/nse/intradayTipsBTST/

investorzone.in

http://stocksandbiceps.com

https://www.ipoandmore.com

FIND Special Characters Oracle

 CREATE OR REPLACE TYPE WWT.WWT_XXWMS_CHAR_LIST_NRR IS TABLE OF CHAR(1 CHAR);

WITH wc
AS (SELECT inventory_item_id, segment2
FROM   mtl_system_items_b
WHERE  inventory_item_id IN (18736091,18736071,18791648,18689552,12492301,18695455
,616432,7304252,212663)
AND    organization_id = 101
)
 SELECT  t.inventory_item_id,
        CAST( c.COLUMN_VALUE AS CHAR(1 CHAR) ) AS character,
        COUNT(1) AS frequency
FROM    wc t,
        TABLE(
          CAST(
            MULTISET(
              SELECT SUBSTR( t.segment2, LEVEL, 1 )
              FROM   DUAL
              WHERE  REGEXP_LIKE( SUBSTR( t.segment2, LEVEL, 1 ), '[^a-zA-Z0-9]' )
              CONNECT BY LEVEL <= LENGTH( t.segment2 )
            ) AS WWT.WWT_XXWMS_CHAR_LIST_NRR
          )
        ) c
GROUP BY t.inventory_item_id, c.COLUMN_VALUE
/

WITH msib_wc
AS (SELECT  segment2
FROM   mtl_system_items_b
WHERE  inventory_item_id IN (18736091,18736071,18791648,18689552,12492301,18695455)
AND    organization_id = 101
)
SELECT  CAST( c.COLUMN_VALUE AS CHAR(1 CHAR) ) AS character,
        COUNT(1) AS frequency
FROM    msib_wc  ,
        TABLE(
          CAST(
            MULTISET(
              SELECT SUBSTR( msib_wc.segment2, LEVEL, 1 )
              FROM   DUAL
              WHERE  REGEXP_LIKE( SUBSTR( msib_wc.segment2, LEVEL, 1 ), '[^a-zA-Z0-9]' )
              CONNECT BY LEVEL <= LENGTH( msib_wc.segment2 )
            ) AS WWT.WWT_XXWMS_CHAR_LIST_NRR
          )
        ) c
GROUP BY c.COLUMN_VALUE
/

Vastu Zones And Significance

Link


In any living space there is an importance to a particular activity to be performed in Particular zone of the house. And accordingly you will have good, bad or no effects. Having any activity or any objects or color, Anti to that zone can create negative effect to the occupants. Similarly one can use individual zone for their own benefits.

Living Space is divided into 16 zone as per the theory of Five Elements and each zone has its own significance.

Five Elements (Pancha Tatva) 
Water (Blue) -  Air (Green) - Fire (Red) -  Earth (Yellow) - Space (White)
​
16 Zones
North (N), North North East (NNE), North East (NE), East North East (ENE), East (E), East South East (ESE),  South East (SE), South South East (SSE), South (S), South South West(SSW), South West(SW), West South West(WSW), West (W), West North West(WNW), North West (NW), North North West(NNW)

North - N
(Money and Opportunity)
If you are lacking opportunity or wants to create new opportunity this is the zone to look for.

​North East - NE
(Clarity of Mind)
If you are lacking clarity in your thought process or don't know what to do then this is the zone to look for.

North North East - NNE
(Health and Immunity)
If you are facing any health related issue this is the zone to look for other zone related to specific health issue.

East North East - ENE
(Recreation and Fun)
If you are missing fun and recreation in your life, life is getting boring then this is the zone to look for.

East - E
(Social Association)
If you don't have friends or no social life then this is zone to look for.

East South East - ESE
(Anxiety and Churning)
If you are always anxious and keep thinking about unnecessary things then this is the zone to look for.

South East - SE
(Fire Cash and Liquidity)
If you have blocked payment or your source of income is affected then this is the zone to look for.

South South East - SSE
(Power and Confidence)
If you lack confidence or feel powerless then this is the zone to look for.

South - S
(Relaxation and Fame)
If you think your are always stressed, sleepless nights and don't get recognition you deserve then this the zone to look for.

South South West - SSW
(Expenditure and Disposal)
If you think that you are not getting results for whatever you do and there are unnecessary , uncontrollable expenditure then this is the zone to look for.

​South West - SW
(Relationship and Skill)
If there are relationship issues, or even though you are skillful but you are benefiting from it then this is zone to look for.

West South West - WSW (White/Gray)
(Education and Saving)
Even if you are hardworking but you are not doing well with your studies or you are not able save any money then this is the zone to look for.

West - W (White/Gray)
(Gains and Profits)
If you think you are lacking gains and profits for hard work you do or in business then this is the zone to look for.

West North West - WNW (White/Gray)
(Depression and Detoxify)
If you are depressed or stuck with past memories then this is the zone to look for.

North West - NW
(Support and Banking)
If you are lacking support from your loved once or outside world (Bank, Govt dept etc) then this is the zone to look for.

​North North West - NNW 
(Sex and Attraction)
If you are lacking zeal in your married life, If you think people don't get attracted to your product or thing you do then this is zone to look for. 

When Buying New House

Link

So what are the things to look for when buying new house, your dream home?

We are considering following factors to help you make the decision:

1) House Entrance
2) Toilet Locations
3) Kitchen Location

Lets discuss about the house you should not buy ( Unless you are willing to do the major renovations before moving in )

Main entrance is the most important factor while making any decision. Entrance location, If its good then it can bring prosperity and if its bad then it can ruin everything.

House with Entrances Location to Avoid 

SW entrance should be avoided at any cost. Similarly NE, SE and SSW entrances should be avoided as even remedies may not work.

Having entrance here will isolate the family from rest of the world for any possible reason. There will be losses, accidents in the house. These entrances will results into total wastage of your efforts.

House with Toilet Positions to Avoid

Toilet is the disposal activity and If toilet is in NNE, NE or SW you should avoid buying that house unless you are willing to relocate it. Having toilet there will create health related issues. There wont be any peace of mind, relationship issues may occur. Having toilet in NE can also cause Cancer to the occupant after certain age.

House with Kitchen Location to Avoid

Kitchen (Cooking Range) represent fire and having Fire in zone of relationship is not good. So having Kitchen in SW should be avoided as it will add fire into the relationship and any remedy may not work. Having fire in the NE (zone of Clarity of Mind) should be avoided. Also having kitchen in the zone of disposal (SSW) should be avoided as occupant may not gain from the food cooked here and can have health issues. And relocation of the kitchen is the only option in those cases. Also if you own the business then avoid the kitchen in SE as it can create the situation where you will end up working for someone else. 

So make the wise decision or you can leave it to experts to make decision for you. We can help you decide when buying new house.

Find string in File from directory : DOS

findstr /S /M /C:"p_num_dup_labels" *

Generate XML from SQL

   FUNCTION  get_xml_data( p_sql_stmt IN VARCHAR2, p_row_set_tag IN VARCHAR2, p_row_tag IN VARCHAR2 )
   RETURN CLOB
   IS
      l_ctx    dbms_xmlgen.ctxHandle;
      l_xml    CLOB;
 
   BEGIN
 
 
      l_ctx := dbms_xmlgen.newContext(p_sql_stmt) ;
      dbms_xmlgen.setrowsettag(l_ctx, p_row_set_tag );
      dbms_xmlgen.setRowTag(l_ctx, p_row_tag );
      l_xml := dbms_xmlgen.getXML(l_ctx);
      DBMS_XMLGEN.closecontext ( l_ctx )  ;
 
      RETURN l_xml ;
 
   EXCEPTION
      WHEN OTHERS THEN
 
        RETURN NULL ;
     
   END  get_xml_data 

Read CLOB line by line

create table nrr_test_clob (c clob);

truncate table nrr_test_clob

insert INTO nrr_test_clob (c) values (
'<REPORT>
  <HEADER>
   <REPORT_NAME> WMS PICK TASK RELEASE</REPORT_NAME>
     <REQUEST_ID> 236560596</REQUEST_ID>
     <REQDATE> 02-MAR-2018 04:53:2525 PM</REQDATE>
     <REQUSER> RAYKARN</REQUSER>
     <FROM_DATE> 11-JAN-2018 01:00:0000 AM</FROM_DATE>
     <TO_DATE> 19-JAN-2018 09:00:0000 PM</TO_DATE>
     <FACILITY> WPC</FACILITY>
     <ORG> </ORG>
     </HEADER>
     <DATE_SUMMARY>
     <DATE_ROW>
     <COUNT_PREV>2447</COUNT_PREV>
     <COUNT_TODAY>0</COUNT_TODAY>
     <COUNT_TOMORROW>0</COUNT_TOMORROW>
     <COUNT_WEEK>644</COUNT_WEEK>
     <COUNT_MONTH>697</COUNT_MONTH>
     <COUNT_FUTURE>39</COUNT_FUTURE>
     </DATE_ROW>
     </DATE_SUMMARY>
     </REPORT>');
----------------------------------------------------------------------------------------------------------------------

select to_char(regexp_substr(test.c, '.+', 1, level)) pattern
from nrr_test_clob test
connect by level <= regexp_count(test.c, '.+');

----------------------------------------------------------------------------------------------------------------------


DECLARE

   l_clob   clob ;
   l_offset number := 1;
   l_amount number := 32767;
   l_length    number ;
   lc_buffer varchar2(32767);
   i   pls_integer := 1;
   idx pls_integer := 0;


   -- For UNIX type file - replace CHR(13) to NULL
   C_CR char := chr(13); -- carriage return
   --CR char := NULL;
   C_LF char := chr(10); --line feed
   
BEGIN


   SELECT c
   INTO   l_clob
   FROM   nrr_test_clob ;
 
   l_length := dbms_lob.getlength(l_clob);

   dbms_output.put_line('l_length => '||l_length) ;
 
   <<len_lbl1>>
   WHILE ( l_offset < l_length ) LOOP
 
      idx := idx + 1;
     
      dbms_output.put_line(idx||' l_offset => '||l_offset||' l_length => '||l_length) ;
 
      -- If no more newlines are found, read till end of CLOB
      IF (instr(l_clob, c_lf, l_offset) = 0) THEN
       
         l_amount := l_length - l_offset + 1;
   
      ELSE
   
         l_amount := instr(l_clob, c_lf, l_offset) - l_offset;
       
      END IF;
   
      dbms_output.put_line('l_amount => '||l_amount) ;
 
      -- This is to catch empty lines, otherwise we get a NULL error
      IF  ( l_amount = 0 ) THEN
   
         lc_buffer := '';
   
      ELSE
   
         dbms_lob.read(l_clob, l_amount, l_offset, lc_buffer);
   
      END IF;
   
      dbms_output.put_line('Line #'||i||':'||lc_buffer);


      -- This is to catch a newline on the last line with 0 characters behind it
   
   
      IF (instr(l_clob, c_lf, l_offset) = l_length) THEN
   
         lc_buffer := '';
   
         dbms_output.put_line('Line #'||idx||':'||lc_buffer);
   
      END IF;

      l_offset := l_offset + l_amount + 1;
 
   END LOOP len_lbl1 ;
 
 
END ; 

ASN

rcv_headers_interface
rcv_transactions_interface
mtl_serial_numbers_interface
rcv_serials_interface


rcv_shipment_headers
rcv_shipment_lines
mtl_supply


rcv_serials_supply
rcv_Serial_transactions
mtl_serial_numbers